IG Index Historical Data Download

Please note: IG Index currently limits historical data downloads to 10,000 data points per user per week.

The Add-in enables on-demand downloading of IG Index / Markets historical price data into your Excel spreadsheet.

To get started, launch the Configuration Pane and search for the instrument in the Search box on the IG Index tab. Select the instrument, for example here EURUSD spot is selected:

IG Index Historical Data Download to Excel Screen

Next, you need to specify the type of data you wish to download:

  • Resolution: Select a resolution for the data you require, for example "1 Minute", "5 Minute", "1 Hour", "Weekly" etc.
  • Range: You need to specify either a date range or a number of points back from the current date/time. Please be careful when selecting a date range to ensure you don't exceed your IG Index historical data allowance. Refer to https://labs.ig.com/faq for details on how much data is available for each resolution.
  • Fields: Select which fields you would like to download, for example if you select bid, ask and open close all combinations will be downloaded i.e. open bid, open ask, close bid and close ask

Ensure the cell where you would like the data to be downloaded to is selected in your spreadsheet.

Press the "Download Data" button and the requested historical data will be downloaded from IG Index into your spreadsheet:

IG Index Historical EURUSD data in an Excel spreadsheet

Details about your data allowance will also be updated:

IG Index historical data allowance update