Pulling Data Report NOT Chart

[David2000]

Hi guys,

I'm trying to figure out if you can pull reports on IG. I'm trying to find out the opening price of every hour since 1st Feb 22. I know I could do this manually but that is a lot of hours to write down. Anyone got any ideas on how to pull this as a report?

 

Thanks,

D

[andysinclair]

Hi David,

I have built an Excel Add-in which makes it very easy to get IG historical data, including hourly data, into an Excel spreadsheet. 

You can download it from here: https://www.excelpricefeed.com/userguide/download

And here are instructions on how to set it up for IG: https://www.excelpricefeed.com/userguide/account-setup-ig-index

Let me know how you get on or if you need any help.

Andy

 

[David2000]

9 hours ago, andysinclair said:

Hi David,

I have built an Excel Add-in which makes it very easy to get IG historical data, including hourly data, into an Excel spreadsheet. 

You can download it from here: https://www.excelpricefeed.com/userguide/download

And here are instructions on how to set it up for IG: https://www.excelpricefeed.com/userguide/account-setup-ig-index

Let me know how you get on or if you need any help.

Andy

 

That's amazing - thanks Andy, will let you know how I get on

[David2000]

18 minutes ago, David2000 said:

That's amazing - thanks Andy, will let you know how I get on

Is there a way to do this with a Mac as it looks like it isn't possible without?

[andysinclair]

8 minutes ago, David2000 said:

Is there a way to do this with a Mac as it looks like it isn't possible without?

I'm afraid it's PC only at the moment.

Otherwise, If you have Parallels you can run it on the PC version of Excel on your Mac.

[Screening]

On 14/03/2022 at 09:07, andysinclair said:

Hi David,

I have built an Excel Add-in which makes it very easy to get IG historical data, including hourly data, into an Excel spreadsheet. 

You can download it from here: https://www.excelpricefeed.com/userguide/download

And here are instructions on how to set it up for IG: https://www.excelpricefeed.com/userguide/account-setup-ig-index

Let me know how you get on or if you need any help.

Andy

 

Hi Andy, I found your post as I am looking to download the last 10 weeks of 5 minute data for FX charts. Thanks for posting it. At the moment the IG chart only provides 4 weeks of 5 minute data.  Does your excel add in give the ability to download10 weeks of 5 minute data?

Thanks very much in advance.

Trevor

[andysinclair]

23 hours ago, Screening said:

Hi Andy, I found your post as I am looking to download the last 10 weeks of 5 minute data for FX charts. Thanks for posting it. At the moment the IG chart only provides 4 weeks of 5 minute data.  Does your excel add in give the ability to download10 weeks of 5 minute data?

Thanks very much in advance.

Trevor

Yes, my Excel Add-in can provide upto 360 days of data, as per the API.

The only restriction is that IG only allow 10,000 data points to be downloaded per week, so you would need to do it in batches. Otherwise you can contact them and they can increase you quota - I have done this and now have a much larger quota.

I hope this helps.