The Add-in enables on-demand downloading of historical IG Index client sentiment data into your Excel spreadsheet.
To get started, launch the Configuration Pane (from the Add-in toolbar), then select the "IG Index" tab and then the "Historical Sentiment Data" tab:
To download data, you need to specify the market and range of data you wish to download:
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 client sentiment data will be downloaded into your spreadsheet:
The column headings describe the data that has been downloaded where each number is expressed as a percentage of IG Index clients:
You can now use the data in Excel together with the historic IG Index data download functionality to visualise how client sentiment changes based on the underlying market.
Please note we also provide VBA functions for retrieving historical client sentiment data.
For example, here we have plotted historical IG Index client sentiment for the S&P500 against the how the index moves: