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
  • General Statistics

    • Total Topics
      21,601
    • Total Posts
      91,807
    • Total Members
      41,868
    • Most Online
      7,522
      10/06/21 10:53

    Newest Member
    jasebob
    Joined 21/03/23 13:16
  • Posts

    • 🟢GBPCHF broke and closed above a major falling trend line on a daily. The broken trend line turned into a key vertical support now. Probabilities will be high, that a bullish movement will initiate from that.   Next goals for buyers: 1.1423 / 1.151 For Additional confirmation use: Leading Indicators
    • Shopify Inc., Elliott Wave Technical Analysis Shopify Inc.,(SHOP:NASDAQ): Daily Chart, 21 March 23, SHOP Stock Market Analysis: Shopify keeps moving sideways as expected, as it stays between the 20 and 200EMA. As long as we do not break the red line we can assume we will be seeing further downside.   SHOP Elliott Wave Count: Wave (iv) of {i}. SHOP Technical Indicators: At the cross of 20 and 200EMA. SHOP Trading Strategy: Waiting for a potential triangle in wave (iv). TradingLounge Analyst: Alessio Barretta     Shopify Inc., SHOP: 4-hour Chart, 21 March 23, Shopify Inc., Elliott Wave Technical Analysis SHOP Stock Market Analysis: We keep moving sideways in a three wave manner, which confirms the fact we are in a corrective structure. We are moving between the 50% and 38.2% retracement of (iii).   SHOP Elliott Wave count: Wave (iv) of {i}. SHOP Technical Indicators: Above all averages.   SHOP Trading Strategy: Looking for sideways continuation in wave (iv).
    • Elliott Wave Analysis TradingLounge Daily Chart, 21 March 23,   Ethereum/U.S.dollar(ETHUSD) ETHUSD Elliott Wave Technical Analysis  Function: Follow trend Mode: Motive Structure: Impulse Position: Wave III Direction Next higher Degrees: wave (I) of Motive Details: Wave 3 equals 1.618 multiplied Length of wave 1 at 2943.53 Wave Cancel invalid level: 1073.42 Ethereum/U.S.dollar(ETHUSD)Trading Strategy: Ethereum resumes its upward trend in wave III with a chance to reach the 161.8 level of wave I at 2943.53. Also, the price has risen above the MA200 line, giving the view to a continued upward trend in wave III. Ethereum/U.S.dollar(ETHUSD)Technical Indicators: The price is above the MA200 indicating an UpTrend. The wave oscillators above Zero-Line momentum are bullish. TradingLounge Analyst: Kittiampon Somboonsod, CEWA     Elliott Wave Analysis TradingLounge 4H Chart, 21 March 23,   Ethereum/U.S.dollar(ETHUSD) Elliott Wave Technical Analysis Function: Follow trend Mode: Motive Structure: Impulse Position: Wave (3) Direction Next higher Degrees: wave ((3)) of Motive Details: Wave 3 equals 1.618 multiplied Length of wave 1 at 2290 Wave Cancel invalid level: 1369 Ethereum/U.S.dollar(ETHUSD)Trading Strategy: Ethereum resumes its upward trend in wave (3) with a chance to reach the 161.8 level of wave (1) at 2290. Also, the price has risen above the MA200 line, giving the view to a continued upward trend in wave (3). Ethereum/U.S.dollar(ETHUSD)Technical Indicators: The price is above the MA200 indicating an UpTrend. The wave oscillators above Zero-Line momentum are bullish.
×
×
  • Create New...