Excel Stock Data Type: FTSE 100 and Hang Seng Ticker Support
Question details
The user wants to know why Excel's Stock data type does not recognize FTSE 100 and Hang Seng Index ticker formats such as ^FTSE or XLON:FTSE.

- Product
- Microsoft Excel Stock data type
- Device & OS
- not provided
- Scenario
- The user is trying to insert FTSE 100 or Hang Seng index data into an Excel workbook by using the Stocks data type.
- Observed behavior
- Excel does not recognize common FTSE 100 or Hang Seng ticker formats, and the linked stock data service does not currently support those indexes.
Confirm the exact ticker format you are entering and check whether the exchange appears in Microsoft's supported data sources list. Have a CSV export or web table URL from a financial data provider ready if you need to switch to an external import method.
Use an External Data Provider or Power Query to Import FTSE 100 and Hang Seng Index Data
Use this method when you need live or refreshable index values and Excel's built-in Stock data type cannot resolve ^FTSE, XLON:FTSE, or similar Hang Seng tickers.
Excel's Stock data type depends on Microsoft's data provider partnerships and currently does not support the FTSE 100 or Hang Seng Index as linked ticker symbols. An external data provider or Power Query web connection is the most reliable way to bring the index into your workbook.
Open the Excel workbook that needs the index data and click the Data tab in the ribbon.
Click Get Data, select From Web, then enter the URL of a financial data source that publishes FTSE 100 or Hang Seng values and click OK.
In the Power Query Navigator, select the table that contains the index data, then click Load to import it into a worksheet.
Go to Data > Queries & Connections, right-click the new query, select Properties, and enable refresh options so the values can be updated without manual re-entry.
Manually Import FTSE 100 or Hang Seng Index Data from a CSV or Web Table
Use this method when you only need a static snapshot or periodic manual refresh and do not require Excel's linked Stocks data type.
Use WPS Spreadsheets for FTSE 100 and Hang Seng Data Workflows
WPS Spreadsheets is a free, lightweight Office alternative that opens and saves Microsoft Excel workbooks with a familiar interface. It does not replace Excel's linked Stock data type, but it supports manual CSV and web table imports for FTSE 100 or Hang Seng data without a paid Office 365 subscription.
- 1. Download WPS Office Free: Visit the official WPS website, download the free installer for your device, and complete the installation.
- 2. Open your workbook in WPS Spreadsheets: Launch WPS Spreadsheets and open the .xlsx workbook that contains or will contain your FTSE 100 or Hang Seng data.
- 3. Import the index data manually: Click the Data tab in WPS Spreadsheets and use the import or get data options to load a CSV or web table from your financial data provider.

Frequently Asked Questions
Which ticker format works for the FTSE 100 in Excel's Stock data type?
Currently no FTSE 100 ticker format such as ^FTSE or XLON:FTSE works with Excel's Stock data type because the index is not in Microsoft's supported exchanges and data sources.
Does WPS Spreadsheets have the same Stock data type as Excel?
No, WPS Spreadsheets does not include Excel's linked Stock data type. You can use the Data tab in WPS Spreadsheets to import CSV files or web data tables manually.
Can I import Hang Seng Index data into WPS Spreadsheets?
Yes. Download the Hang Seng data as a CSV or use a web table export, then in WPS Spreadsheets go to Data > From Text/CSV or the available import option and load the file.
Why does Excel show a Data Selector error for ^FTSE?
The Data Selector error means Excel cannot resolve the symbol because FTSE 100 is not currently supported by the linked stock data service, not because the workbook is necessarily broken.
What is a reliable alternative to Excel Stocks for FTSE 100 and Hang Seng?
Use an external financial data provider, a Power Query web connection, or manual import from CSV. For spreadsheet compatibility, WPS Spreadsheets is a free option for opening and editing the imported Microsoft Excel files.




