Data Import & Export

How to Find and Add the Hong Kong Hang Seng Index in Excel

Khadija KhanKhadija Khan Oct 29, 2026 874 views

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.

How to Find the Hong Kong Hang Seng Index in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Enter the Ticker Symbol

Open your Excel workbook, select an empty cell, and type the standard symbol for the Hong Kong Hang Seng Index: ^HSI.

2
Apply the Stocks Data Type

Select the cell containing ^HSI, navigate to the 'Data' tab on the top ribbon, and click on 'Stocks' in the Data Types group.

3
Open Data Selector

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.

4
Provide Feedback

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.

Apply the Stocks Data Type and Submit Missing Ticker Feedback
Try Symbol Variations: Sometimes financial data providers use different ticker formats. You can try typing simply 'Hang Seng' or 'HSI' in the Data Selector search bar to see if it yields better results.
Free Microsoft Office alternative

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.

100% compatible with Microsoft Excel (.xlsx, .xls) and CSV formatsLightweight application that runs smoothly on almost any deviceEasily import external financial data to track market indices manuallyFree to use with a familiar, easy-to-navigate tabbed interface
microsoft office alternative - wps office

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.