Historic bid and offer data

2 posts / 0 new
Last post
bigyocks
Historic bid and offer data

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

bigyocks
UPDATE>> I've just had a look

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...

Log in or register to post comments