How to Find Mutual Funds and ETFs with Excel Stocks Data
Question details
Users are unable to locate specific mutual funds and ETFs using the Stocks data type in Excel, even when searching by common names, ISIN, SEDOL, or ticker symbols.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Importing and tracking live financial data for specific mutual funds and ETFs using Excel's built-in Stocks data type.
- Observed behavior
- Excel fails to find the requested funds, particularly certain international or UK-based funds, due to limitations with Microsoft's specific data provider.
Ensure you have an active internet connection and a Microsoft 365 subscription, as the Stocks data type requires cloud access to retrieve live financial information.
Search Using Precise Fund Names or Tickers
Excel's data provider is highly sensitive to naming conventions. Using the exact name or a supported ticker improves search accuracy.
The Stocks data type relies on specific data providers and often struggles with fuzzy matching, ISIN, or SEDOL inputs. To maximize the chances of finding your fund, you must use the exact name as it appears in standard financial databases.
Look up the precise name of the mutual fund or ETF as listed on major financial platforms, such as the Financial Times.
Type the exact fund name or supported ticker into an empty cell in your Excel spreadsheet.
Select the cell, navigate to the 'Data' tab on the ribbon, and click on 'Stocks' in the Data Types group.
If a question mark icon appears next to the cell, click it to open the Data Selector pane and manually browse for the correct match.
Install the Stock Connector Add-in
If the native Stocks data type cannot find your fund, a third-party add-in can help access alternative financial databases.
Try WPS Office for Seamless Financial Data Management
Since missing funds in Excel are tied to Microsoft's specific data provider limitations, you might prefer a lighter, more flexible spreadsheet tool. WPS Spreadsheets is a powerful, free alternative that supports full compatibility with Excel formats, allowing you to build custom financial dashboards using imported web data or custom APIs without being locked into a single provider.
Frequently Asked Questions
Why can't Excel find my UK-based mutual fund?
Excel relies on a specific third-party data provider to power the Stocks data type. If this provider does not support the specific market or identifier for that UK fund (like certain Vanguard Global Small-Cap funds), Excel will not be able to retrieve its data.
Can I search for stocks using ISIN or SEDOL in Excel?
Currently, searching by ISIN or SEDOL often fails because the Stocks data type lacks comprehensive support for these specific identifiers. It is highly recommended to use the exact fund name or the official ticker symbol instead.
How do I refresh the stock data in my spreadsheet once it is found?
To update your financial data, select the cells containing the Stocks data type, navigate to the Data tab on the ribbon, and click 'Refresh All'. This will pull the latest available market information.
