Getting Started

• Introduction
• Download
• Installation & Activation
• Troubleshooting
• Data Refresh/Updates
• Software Updates
• Manage Your Subscription
• Example Spreadsheets

General Formulas

• Black-Scholes Option Pricing
• Instrument Identifier Conversions

Technical Analysis Toolkit

• Introduction
• Simple Moving Average (SMA)
• Exponential Moving Average (EMA)
• Volume Weighted Average Price (VWAP)
• Average True Range (ATR)
• Bollinger Bands
• Aroon

Yahoo Finance

• Formula Reference
• • Stocks
  • Stocks: Income Statement
  • Stocks: Balance Sheet
  • Stocks: Cash Flow
  • Stocks: Analysis
  • Stocks: ESG Risk Ratings
  • Options Chain
  • Stock Options
  • Mutual Funds
  • ETFs
  • FX Rates
  • Cryptocurrencies
  • Commodities
  • Historical Market Data
  • News
• Historical Array Formulas
• Historical Data Download

IG Index / IG Markets

• Account Setup
• Formula Reference
• VBA Functions Reference
• Historical Price Data Download To Excel
• Historical Price Data Download To File
• Historical Client Sentiment Data Download
• Watchlists
• Live Positions, Transactions & Activity History

EODHistoricalData.com

• Overview & Setup
• Historical Price Data
• Stocks Fundamental Data
• Stocks Financial Analysis

Nasdaq Data Link

• Overview & Setup
• Formula Reference

IG Index Historical Client Sentiment Data Download

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:

• Market: Select the market from the list. We are currently collecting historical sentiment data for 30 different markets: stock indices, currencies, commodities, cryptocurrencies and single stocks. Please contact us if a market you are interested in is not currently being collected.
• Range: Specify either a date range or a number of points back from the current date/time.
• Resolution: Specify either daily or hourly data points.

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:

• CloseLong: The closing level of long positions.
• CloseShort: The closing level of short positions.
• OpenLong: The opening level of long positions.
• OpenShort: The opening level of short positions.
• HighLong: The highest long level of the day.
• HighShort: The highest short level of the day.
• LowLong: The lowest long level of the day.
• LowShort: The lowest short level of the day.

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: