IG Index Client Sentiment Analysis Using Excel

Excel Price Feed includes functions for using IG Index client sentiment data in an Excel spreadsheet. Client sentiment data can be used as part of your trading strategy and feed into your decision making process. You could keep track of sentiment over time and look for patterns or use it as a simple indicator.

Using the Configuration Pane, search for the instrument you are interested in. Once found, select it in the list and press the "Epic" button. This will insert the epic code into the currently selected Excel cell.

For example, here we have searched for S&P500 Index and inserted the epic code at cell A2:

IG Index Excel Select Instrument Epic

Next, you can display the name of the instrument using the EPF.IG.Name function:

IG Index Excel Name Function

The sentiment data from IG Index uses the instrument market ID rather than the epic, therefore we need to retrieve the market ID for the epic, then use the market ID to retrieve the sentiment value.

Excel Price Feed includes a MarketID function for this purpose:


Here we have added the market id function to cell C2:

IG Index Excel Market ID Function

Now we can retrieve the client sentiment data using the following functions:


Here we have added the short client sentiment function to cell D2:

IG Index Excel Market ID Function

We can use the same process for client long sentiment and other instruments (stock indices, currency pairs, stocks etc.) that we are interested in. Using the Data Bars functionality in Excel, we can add a nice visual effect to the data:

IG Index Excel Client Sentiment Summary

You can download the final spreadsheet, with formulas for using live client sentiment data from IG Index here: