help to build simple stock tracker tool

budget is 20$

Support to complete excel sheet;

The concept is very simple and basic, check [url removed, login to view] and see gebra record page ; I just need to get this table in excel updated at any point of time to monitor the admin tickets status if accomplished or not without manual monitor , the requirement as below :

Bidder MUST

1. Develop the stock API with [url removed, login to view] website to get the real price of any stock. This process should done in the backend and not effect user experience.

2. Develop a start and stop button to run/stop the tracking

3. The timing should be EST time and admin can change the time based on US , UAE , GMT time

1. The main target of this excel is to track the stock advise (tickets) recommendation and see if successfully achieved or not

2. Admin to enter below values;

a. Stock symbol

b. Stock entry price

c. Take Profit Price

3. System to record calculate the below :

a. Record the Ticket time and date yyyy-mm-dd hh:mm

b. System to check the real current price of the symbol

c. If entry price = current price  entry date = current date and time when the stock price = entry price yyyy-mm-dd hh:mm

d. Then system should lock the entry date which just filled from any changes if the entry price hit current price in the future.

e. After point C filled ; which mean entry date already filled then:

i. system to keep check the Take Profit price with current symbol’stock’ price

f. if take profit = current price  execution date = current date and time when the stock price = take profit price yyyy-mm-dd hh:mm

g. the system should lock the execution date which just filled from any future overwritten if the stock price equal again the Take profit price

h. if Entry date && execution date filled

i. then Profit column should be calculated as Take Profit – Entry Price with same color of “#27A9E1”

j. and Result column should be “ Success” and blue color “#27A9E1”

k. if the entry date still not accomplished then value should be “ OPEN”

l. if at any time entry date filled and execution date still not accomplished the value should be “ OPEN”

Note : 27A9E1 =


RGB 39 169 225

HSL 0.55 0.76 0.52

Skills: Excel, VB.NET

See more: build simple admin panel, php build simple chat application php, build simple cms, build simple php inventory database, simple login admin, enter admin oscommerce, creating simple php admin page, simple paypal enter promo box, build simple gallery cms, build simple portfolio, simple php admin site, build simple multiplayer flash game, build simple mp3 player site streaming, build simple php questionnaire, simple viewer admin installation, simple viewer admin, build simple mp3 player, build simple touch screen glass, simple php admin, build simple web page header

About the Employer:
( 7 reviews ) Dubai, United Arab Emirates

Project ID: #12202653

3 freelancers are bidding on average $121 for this job


Dear Hiring Manager, I am .Net developer with c# as base language. I mostly do desktop application/Scripts. I had worked for many website like amazon, ebay, alibaba , aliexpress and more... recent work done was More

$111 USD in 4 days
(4 Reviews)

I checked evey thing i can do that . Waiting for your response. 1. Profile Summary o 4+Years of software development experience in developing enterprise level Web based and Windows based applications using Microsof More

$30 USD in 1 day
(0 Reviews)

Hi, Project needs extensive coding in excel VBA for two websites - Gebra records and Yahoo finance. I have worked on similar projects. I am GARP certified FRM with first hand experience in setting up statistica More

$222 USD in 15 days
(0 Reviews)