Data Import & Export

How to Find Partial Stock Tickers and Bond Symbols in Excel Data Types

Ayan MasoodAyan Masood Nov 10, 2026 868 views

Question details

The user wants to know why Excel's Stock and Currency data types do not return results for partial ticker searches and how to identify the correct symbols for securities.

Finding Partial Stock Tickers and Bond Symbols in Excel Data Types
Product
Microsoft Excel
Device & OS
not provided
Scenario
Searching for stock tickers and bond symbols using the linked data types feature in Excel for financial tracking and modeling.
Observed behavior
Partial searches do not return the expected securities; Excel requires an exact match including exchange prefixes or share classes to successfully link the data type.
Before you start

Ensure you have a stable internet connection and an active Microsoft 365 subscription, as the Stock and Currency linked data types require online access to Microsoft's financial data provider.

Solution 1Recommended

Use Exact Matches and Exchange Prefixes

Since Excel's search engine relies on exact matches from its database, you need to use specific exchange prefixes or share class identifiers to link the correct data.

Excel's linked data types pull information from Refinitiv. The system generally requires an exact match for the ticker symbol. When a security is listed on multiple exchanges or has different share classes, entering a partial ticker will often yield no results or incorrect suggestions.

1
Identify the exact ticker symbol

Look up the exact ticker symbol on a trusted financial website, the specific stock exchange, or using a search engine. Pay close attention to any special share classes.

2
Format the ticker with the exchange prefix

Enter the ticker into your Excel cell using the format [Exchange Prefix]:[Ticker Symbol]. For example, type 'XBUE:GGAL3' instead of just a partial identifier.

3
Apply the Stock data type

Select the cell containing your fully formatted ticker, navigate to the 'Data' tab on the ribbon, and click 'Stocks' in the Data Types group to link the financial data successfully.

Use Exact Matches and Exchange Prefixes
Data Provider Limitations: Microsoft does not guarantee a complete public list of all supported symbols. Tickers may be added or removed at any time by the data provider.
Free Microsoft Office alternative

Try WPS Office for Your Spreadsheet Needs

If you are looking for a lightweight, highly compatible alternative to Microsoft Excel, WPS Spreadsheet offers robust financial functions, extensive data analysis tools, and seamless compatibility with .xlsx files without the hefty subscription fees.

  1. 1. Download and Install: Visit the official WPS website to download WPS Office for free and install it on your device.
  2. 2. Open Your Financial Data: Launch WPS Spreadsheet and open your existing .xlsx files containing your financial and stock tracking data.
  3. 3. Analyze and Manage Data: Use built-in financial formulas, pivot tables, and charting tools to analyze your investments seamlessly.
100% free and lightweight office suite for daily productivity.Seamlessly open, edit, and save Microsoft Excel (.xlsx, .xls) formats without compatibility issues.Familiar user interface requiring no learning curve.Built-in templates for financial tracking, stock analysis, and budgeting.
microsoft office alternative - wps office

Frequently Asked Questions

Is there a complete list of all stock tickers supported by Excel Data Types?

No, Microsoft and its data provider (Refinitiv) do not publish a comprehensive, public list of all supported symbols. The database is provided 'as is' and tickers may be added or removed dynamically without notice.

Why does Excel show multiple options for a single ticker symbol?

If a ticker symbol exists on multiple stock exchanges globally, Excel's Data Selector panel will prompt you to resolve the ambiguity by selecting the specific exchange you want to pull financial data from.

Can I use partial company names to find stock data in Excel?

While typing a company name occasionally brings up the correct suggestion in the Data Selector, Excel's linked data types require an exact ticker match to function reliably. It is always safer to input the exact ticker symbol.

What should I do if my bond symbol isn't recognized by Excel?

If a bond symbol isn't recognized, verify the ISIN or specific exchange listing externally. If it's still not found, the data provider might not track that specific bond, and you may need to import the pricing data manually via a web query or CSV.