Data Import & Export

Excel Stock Data Type: FTSE 100 and Hang Seng Ticker Support

Algirdas JasaitisAlgirdas Jasaitis Nov 13, 2026 868 views

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.

Excel Stock Data Type and FTSE 100 / Hang Seng Ticker Support
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Data tab in Excel

Open the Excel workbook that needs the index data and click the Data tab in the ribbon.

2
Start a web query

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.

3
Choose the correct table

In the Power Query Navigator, select the table that contains the index data, then click Load to import it into a worksheet.

4
Set refresh options

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.

Why the ticker is not recognized: Excel's linked stock data service does not currently cover the FTSE 100 or Hang Seng Index, so ticker formats such as ^FTSE and XLON:FTSE are not supported.
Free Microsoft Office alternative

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. 1. Download WPS Office Free: Visit the official WPS website, download the free installer for your device, and complete the installation.
  2. 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. 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.
Opens, edits, and saves .xlsx workbooks containing FTSE 100 or Hang Seng data.Free spreadsheet tools for importing CSV or web data tables without an Office 365 subscription.Familiar ribbon interface makes migration from Excel easier.Lightweight installation available across Windows, macOS, Android, iOS, and web.Microsoft Excel .xlsx, .xls, and .csv format compatibility for financial workbooks.
microsoft office alternative - wps office

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.