How to Find Partial Stock Tickers and Bond Symbols in Excel Data Types
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.

- 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.
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.
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.
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.
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.
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.

Utilize Search Engines or Financial Tools for Discovery
If you only know part of a symbol or company name, use external search tools to find the exact symbol before entering it into your spreadsheet.
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. Download and Install: Visit the official WPS website to download WPS Office for free and install it on your device.
- 2. Open Your Financial Data: Launch WPS Spreadsheet and open your existing .xlsx files containing your financial and stock tracking data.
- 3. Analyze and Manage Data: Use built-in financial formulas, pivot tables, and charting tools to analyze your investments seamlessly.

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.




