Find Jobs
Hire Freelancers

help to build simple stock tracker tool

$10-30 USD

Closed
Posted over 7 years ago

$10-30 USD

Paid on delivery
budget is 20$ Support to complete excel sheet; The concept is very simple and basic, check [login to view URL] 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 [login to view URL] 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 = BLUE RGB 39 169 225 HSL 0.55 0.76 0.52
Project ID: 12202653

About the project

3 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $121 USD for this job
User Avatar
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 statistical arbitrage hedge fund. I run a company now which specializes in MIS & Analytics with a team of experienced professionals. Thanks, Anand Sabale +91 9823 93 4779
$222 USD in 15 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED ARAB EMIRATES
Dubai, United Arab Emirates
4.6
7
Payment method verified
Member since May 6, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.