How to Find and Add the Hong Kong Hang Seng Index in Excel
Question details
The user wants to add the Hong Kong Hang Seng Index to their spreadsheet using the Excel Stocks data feature but needs a solution for when the index is not recognized correctly.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Tracking global financial markets and stock indices within an Excel spreadsheet.
- Observed behavior
- Excel sometimes fails to correctly identify or pull data for the Hang Seng Index when the standard ticker symbol ^HSI is entered.
Ensure you are signed in with an active Microsoft 365 subscription and have a stable internet connection, as the Stocks data type requires online access to pull financial data.
Apply the Stocks Data Type and Submit Missing Ticker Feedback
Attempt to add the ^HSI ticker using the built-in Stocks feature, and use the Data Selector to provide feedback if Excel fails to recognize the index.
Microsoft's Stocks data type relies on third-party financial data providers. Because Microsoft does not publish a comprehensive list of supported index symbols, recognition can occasionally fail or display incorrect information for specific indices like the Hang Seng Index.
Open your Excel workbook, select an empty cell, and type the standard symbol for the Hong Kong Hang Seng Index: ^HSI.
Select the cell containing ^HSI, navigate to the 'Data' tab on the top ribbon, and click on 'Stocks' in the Data Types group.
If Excel cannot automatically link the financial data, a question mark icon will appear in the cell. Click this icon to open the Data Selector pane on the right side of the screen.
If you cannot find the correct Hang Seng Index in the search results of the Data Selector, scroll to the bottom of the pane and select 'Give Feedback' to report the missing ticker directly to Microsoft.

Looking for a Lightweight and Reliable Spreadsheet Tool?
If you are frustrated by unreliable data imports or the high subscription costs of Microsoft Excel, WPS Office offers a free, lightweight, and highly compatible alternative. You can easily manage your financial datasets, import external data via CSV, and create comprehensive financial reports without the steep learning curve.

Frequently Asked Questions
Why does Excel say it cannot find the ^HSI symbol?
Microsoft Excel relies on external financial data providers like Refinitiv. If the provider's database changes or if the specific ticker format is currently unsupported, Excel will fail to recognize the symbol.
Are there alternative tickers I can use to track the Hang Seng Index?
If the main index ticker fails, you can look up specific ETF tickers that track the Hang Seng Index, such as '2800.HK' (Tracker Fund of Hong Kong), which are often recognized more reliably by Excel's Stock feature.
Do I need a specific Excel version to use the Stocks data type?
Yes, the Stocks and Geography linked data types are exclusive to Microsoft 365 subscribers and Excel for the Web. They are not supported in older standalone desktop versions like Excel 2016 or 2019.
How often is the stock data updated in Excel?
Stock data in Excel is usually delayed by 15 to 30 minutes depending on the specific stock exchange. You can click 'Refresh All' on the Data tab to manually pull the most recent available data into your spreadsheet.




