Jump to content
  • 0

Pulling Data Report NOT Chart


David2000

Question

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

Link to comment

6 answers to this question

Recommended Posts

  • 0

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

 

  • Like 1
Link to comment
  • 0
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 :)

Link to comment
  • 0
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

Link to comment
  • 0
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.

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...
us