Hi potential posters,
I've been using the IG Excel API tool to extract one hour price data for the major currencies but am really keen to get hold of 30min BID and OFFER data.
I can't do this through the Excel tool but understand it might be possible through a REST API or similar. I must confess I'm not much of a programmer but hopefully what I'm trying to do isn't too difficult.
Do any of you have any advice on how it could be done?
Kind regards
bigyocks
More detail on what I'm trying to do just in case..
- 1 year of 30min BID data
- 1 year of 30min OFFER data
... for the following 6 markets
- EURUSD
- GBPUSD
- AUDUSD
- USDJPY
- USDCHF
- NZDUSD
The data files in CSV/Excel format with the following layout:
Columns: time, date, open, high, low, close
Rows: one row for each 30min period
UPDATE>> I've just had a look at the VBA in the Excel tool and think I can modify that and get what I need...