Data Import & Export

Troubleshoot Excel Cannot Find a Stock or ETF by ISIN Code

Maira Mehtab Sep 22, 2026 868 views

Question details

The user is unable to retrieve financial data for a specific stock or ETF in Excel using its ISIN code or ticker.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Using the Stocks data type feature in Excel to track financial instruments like ETFs or company shares.
Observed behavior: Excel fails to recognize the ISIN or ticker code, showing no results, even if the fund is known to be listed in the LSEG database.

Before you start

Ensure you have an active internet connection and a Microsoft 365 subscription, as the Stocks data type requires both to retrieve real-time financial data.

Solution 1Recommended

Try Alternative Identifiers (Tickers or Company Names)

Since the database may not index every ISIN perfectly, searching by the company name or an alternative exchange ticker can sometimes locate the instrument.

Excel's financial data is powered by third-party providers like LSEG (Refinitiv). Occasionally, a specific ISIN might not map correctly in the data feed, but the instrument itself is available under a different identifier.

Enter the company or fund name

Select the cell containing your ISIN code and replace it with the actual name of the fund or company (e.g., 'Maj Invest UCITS ETF').

Apply the Stocks data type

Go to the 'Data' tab on the ribbon and click on 'Stocks' in the Data Types group.

Use the Data Selector

If Excel cannot find an exact match, a question mark icon will appear. Click it to open the Data Selector pane on the right, and manually search using different exchange codes or tickers.

Exchange Prefix: Try appending the exchange prefix to the ticker symbol (e.g., XCSE:MAJDCS) to help Excel narrow down the search to the correct stock exchange.

Solution 2

Report Missing Data to Microsoft

If the instrument is entirely missing from the Excel financial database, reporting the issue directly to the development team is the best course of action.

Free Microsoft Office alternative

Manage Your Financial Portfolios Seamlessly with WPS Office

If you frequently encounter limitations with Excel's built-in data types, consider switching to WPS Office. It provides a lightweight, highly compatible, and completely free alternative to manage your spreadsheets and financial data.

1. Download and install: Download WPS Office from the official website and complete the quick installation.
2. Open your portfolio: Launch WPS Spreadsheets and open your existing financial tracking files.
3. Import custom data: Use the 'Get External Data' feature to import real-time stock prices from your preferred web sources seamlessly.

100% compatible with Microsoft Excel formats (.xlsx, .xls)Free and lightweight alternative to Microsoft 365Easily import external web data to track stock prices manuallyFamiliar user interface with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel's Stock data type miss certain ETFs or stocks?

Excel retrieves financial data from third-party providers like LSEG. If a specific instrument isn't included in the provider's active data feed for Microsoft, or if there is a gap in database coverage, Excel won't be able to find it.

What is an ISIN code?

ISIN (International Securities Identification Number) is a 12-character alphanumeric code that uniquely identifies a specific security, such as a stock, bond, or ETF, across global markets.

Can I manually update stock prices if Excel cannot find them?

Yes, if the Stocks data type fails, you can manually enter the data or use the 'Get Data from Web' feature in the Data tab to import stock prices directly from online financial platforms like Yahoo Finance or Google Finance.

How do I access the Data Selector in Excel?

If Excel cannot automatically resolve a stock name or ticker, a question mark icon will appear next to the cell. Clicking this icon opens the Data Selector pane on the right side of your screen, allowing you to manually search for the correct financial instrument.

Excel & Data Problems