
Excel API programming for IG Index
- or -
Post a project like this- Posted:
- Proposals: 2
- Remote
- #1326027
- Expired
Description
Description of requirements/functionality: I have a template spreadsheet that can stream in historical data from the trading broker IG Index.
They use API to link Excel inputs into their order system, and data streams.
I need a developer to help code up the following
1. extract required data (time-series) such as historica open/close prices, technical indicators
2. 'live' prices of defined tickers (product names)
3. generate automatic trade orders to feed into IG Index, from the Excel spreadsheet API
OS requirements: Windows
Extra notes:
I have attached an example Excel template on what I would like. In the tab 'Main', I show I would like 'live tick data' to be pulled in via the RTD functions provided.
There are existing functions where you should ensure I can pull in my positions and PnL data by clicking the button 'Positions'.
When I click the button 'Start/Stop data' , I need to start copying a pasting the live tick data over continuously (every pre-defined period such as 5 min).
Historical data download example in tab 'DataDownload'.
Thanks!

Kian O.
100% (1)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Kian,
Do you have the live feed as well?
JamesKian O.18 Oct 2016I will need the 'live' prices as well. But to be honest, the excel template file from IG index already has that set-up. I just need someone to help me set-up a nice, tight spreadsheet.
James M.18 Oct 2016So are you just looking for a macro really rather than "data extraction"?
If so, if you could provide a couple of example spreadsheets of what you have and how you want it to be processed that would be useful.
James -
Please share if possible your links from where data needs to fetched properly in private message if needed so that I will go through properly and let you know how to proceed further for this.
Kian O.18 Oct 2016Hi, the historical data can actually be streamed from IG index. The example template excel spreadsheet provided by them has it set-up in a basic format.
I just need someone to 'copy' the format such that I can easily pull in multiple tickers.