How to Find Missing Investment Funds by ISIN in Excel Stocks
Question details
The user wants to search for mutual funds and exchange-traded products using an ISIN because the built-in Stocks data type cannot reliably find them using fund names or abbreviations.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Searching for precise financial data for mutual funds and ETPs using ISIN identifiers.
- Observed behavior
- Excel's Stocks data type fails to locate specific funds via ISIN, as it relies predominantly on potentially inconsistent fund names or tickers from its data provider.
Verify the exact ISINs for the investment funds you are trying to look up and ensure you have an active internet connection to retrieve financial data.
Use a Financial Add-in for ISIN Lookups
Since Excel's built-in Stocks feature does not support ISIN searches, using a dedicated financial add-in is the most reliable workaround.
Excel's Stocks data type relies on Refinitiv data, which primarily indexes by ticker symbols and company names. To search precisely by ISIN, you need an external tool or add-in like Excel Price Feed, Morningstar, or Bloomberg.
Open Excel, go to the 'Insert' tab on the top ribbon, and click on 'Get Add-ins' to browse the Office Add-ins store.
Search for terms like 'finance', 'stocks', or specific tools like 'Excel Price Feed' that support ISIN conversion.
Click 'Add' to install your chosen add-in, then follow its specific instructions to link your ISIN list to their data feed using the custom formulas provided by the add-in.
Convert ISIN to Ticker Symbol Before Searching
If you prefer not to use an add-in, you can manually find the ticker symbol for your ISIN and use that in Excel's native Stocks feature.
Need a Lightweight Alternative for Financial Spreadsheets?
If you are managing large financial datasets and need a fast, reliable, and completely free spreadsheet solution, try WPS Office. It provides high compatibility with Microsoft Excel formats while offering a seamless and user-friendly experience for all your data management needs.
Frequently Asked Questions
Why doesn't Excel Stocks recognize my mutual fund ISIN?
Excel's Stocks data type is powered by Refinitiv and is optimized to search by company names and exchange ticker symbols. It does not currently have a built-in mechanism to parse and map International Securities Identification Numbers (ISIN).
Can I use native Excel formulas to convert an ISIN to a ticker?
Excel does not have a native function for this conversion. You would need to use an external data provider or a specialized add-in, which provides custom formulas to pull ticker data based on an ISIN.
Are there free add-ins for ISIN lookups in Excel?
While there are some basic financial add-ins available for free, reliable ISIN lookups for global mutual funds and ETFs typically require access to premium databases like Bloomberg or Morningstar, which usually necessitate a paid subscription.
How do I ensure Excel finds the exact mutual fund class?
Because fund classes often have very similar names, the best native method is to input the exact exchange ticker symbol along with the exchange prefix (e.g., 'XNAS:TICKER') instead of relying on the fund's text name.
