Find Jobs
Hire Freelancers

548114 Pairs Trading system in excel spreadsheet

N/A

In Progress
Posted about 12 years ago

N/A

Paid on delivery
Need following general specs for a pairs trading excel(and/or google docs sheet): Excel spreadsheet with data feed from Interactive Brokers and from Google Finance (maybe a button to chose which one to use. Even better if spreadsheet could also be converted into google docs and receive same data feeds as for excel). Ability to download interval price records from IB or Google finance (60 minutes for sake of argument, must be able to specify any time frames, including daily, weekly etc). so download closing (or opening, ask/bid etc) prices of for example SPY US and IWM US check data and synchronize times/days that prices refer to (probably a function to specify start/ end time to use over however many days/months of data needed, so download X /Y for the last 40 days, from 8am to 16:30 pm) ability to update spreadsheet automatically or by pressing command, this for totality of pairs under scrutiny. Ability to create brand new pair trade with two new instruments. Carry out a series of calculations on the data, to be presented in a series of graphs and stats. Ability to specify ratio or difference between instruments for calculations and outputs (eg. (SPY * 3) / or -(IWM *5). Ability to use log of prices to carry out calculations e.g. LOG(SPY)- LOG(IWM) Pop up alarms,colours etc when certain parameters are reached (maybe a GUI with toggle on/off sound alarm, visual etc). Ability to receive SMS or email with alarm Ability to send a trade into Interactive Brokers from the spreadsheet (or google docs if possible). Also ability to automate order sending by choosing parameters as triggers, stops, closing of positions, size, ratio between instruments etc) many thx ADC
Project ID: 2294058

About the project

Remote project
Active 12 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

About the client

Flag of
0.0
0
Member since Jan 28, 2012

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.