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
  • image.png

  • Posts

    • Elliott Wave Analysis TradingLounge Daily Chart, DogeCoin/ U.S. dollar(DOGEUSD) DOGEUSD Elliott Wave Technical Analysis  Function: Counter trend     Mode: Corrective Structure: Zigzag Position: Wave ((C)) Direction Next higher Degrees: wave I of Impulse Wave Cancel invalid Level:  Details: Wave ((4)) may is complete and the Price entry to uptrend again DogeCoin/ U.S. dollar(DOGEUSD)Trading Strategy: Dogecoin overall is still in the period of correction. In the position of wave (II) with a Zigzag pattern, the view is therefore for a short-term pullback before rising again in wave (III), waiting for the correction to complete to rejoin the uptrend. DogeCoin/ U.S. dollar(DOGEUSD)Technical Indicators: The price is below the MA200 indicating a downtrend, The Wave Oscillator is a Bearish Momentum. Elliott Wave Analysis TradingLounge H4 Chart, DogeCoin/ U.S. dollar(DOGEUSD) DOGEUSD Elliott Wave Technical Analysis  Function: Counter Trend Mode: Corrective  Structure: Zigzag Position: Wave A Direction Next higher Degrees: Wave V of Impulse Wave Cancel invalid Level:  Details: wave ((2)) Is Equal to 61.8% of Wave ((1)) at 0.1373 DogeCoin/ U.S. dollar(DOGEUSD)Trading Strategy: Dogecoin overall is still in the period of correction. In the position of wave (II) with a Zigzag pattern, the view is therefore for a short-term pullback before rising again in wave (III), waiting for the correction to complete to rejoin the uptrend. DogeCoin/ U.S. dollar(DOGEUSD)Technical Indicators: The price is below the MA200 indicating a downtrend, The Wave Oscillator is a Bearish Momentum. Technical Analyst : Kittiampon Somboonsod Source : Tradinglounge.com get trial here!  
    • ASX: ASX LIMITED - ASX Elliott Elliott Wave Technical Analysis TradingLounge (1D Chart)   Greetings, Our Elliott Wave analysis today updates the Australian Stock Exchange (ASX) with ASX LIMITED - ASX. We observe that ASX LIMITED is approaching the end of wave 2-grey, but needs more evidence on price action for confirmation, also allowing wave 3-grey to be opened to push higher thereafter.   ASX: ASX LIMITED - ASX  Elliott Wave Technical Analysis   ASX: ASX LIMITED - ASX  1D Chart (Semilog Scale) Analysis Function: Major (Minor degree, grey) Mode: Motive Structure: Impulse Position: Wave (c)-orange of Wave ((y))-navy of Wave 2-grey Details: The short-term outlook indicates that the price has continued to decline longer than expected, with wave 2-grey retracing quite deeply. Essentially, it may continue this action. However, a drop below 53.98 will call for a reassessment of the situation. Invalidation point: 53.98   ASX: ASX LIMITED - ASX  Elliott Wave Technical Analysis TradingLounge (4- Hour Chart) ASX: ASX LIMITED - ASX  Elliott Wave Technical Analysis ASX: ASX LIMITED - ASX  4-Hour Chart Analysis Function: Major (Minor degree, grey) Mode: Corrective Structure: Double Zigzag Position: Wave (c)-orange of Wave ((y))-navy of Wave 2-grey Details: The short-term outlook shows that wave (c)-orange is about to complete, and at the same time it will also complete wave 2-grey, allowing wave 3-grey to open to push higher. The important thing is that the price needs to rise above 59.39, which is also the first step to renew the long-term bullish view with wave 3-grey. Invalidation point: 64.32   Conclusion:   Our analysis, forecast of contextual trends, and short-term outlook for ASX: ASX LIMITED - ASX aim to provide readers with insights into the current market trends and how to capitalize on them effectively. We offer specific price points that act as validation or invalidation signals for our wave count, enhancing the confidence in our perspective. By combining these factors, we strive to offer readers the most objective and professional perspective on market trends.   Technical Analyst: Hua (Shane) Cuong, CEWA-M (Master’s Designation). Source : Tradinglounge.com get trial here!  
    • I overheard a discussion between two friends and one was telling the other that Bitcoin is a scam and that a lot of people preached about the halving and how people could cashout from it. The other friend was trying to convince him to continue holding his asset but he refused and replied that nothing would stop him from selling the coins he's holding.  When I heard that man mentioned cashing out from the halving, I understood that he might know about Bitcoin but he's not properly enlightened concerning it. A lot of expectations were cut short after the halving event cause most people expected Bitcoin to set a new height of $80k but then it didn't even get close to the previous all time high and have reduced below $60k currently.  I think people shouldn't get discourage by that, though I didn't experience other halvings cause I had zero knowledge about Bitcoin then but i think something similar have occurred before in one of the previous halving where Bitcoin price didn't go up as expected but later traced back and went up after some period, a lot of people might begin to panic and sell their coins but I still see this an opportunity to buy more Bitcoin and for those who are not opportuned to do so, holding is the best option, please correct me if you think am wrong  
×
×
  • Create New...
us