'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Get Stock Quotes in Excel Using an ISIN
Question details
The user wants to retrieve live or historical stock quotes in Excel using International Securities Identification Numbers (ISINs) rather than standard ticker symbols.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Importing financial market data directly into spreadsheets using ISINs obtained from bank statements or investment portfolios.
- Observed behavior
- Excel's native stock features rely heavily on ticker symbols, making it difficult to pull data directly using ISINs without a mapping service or a compatible add-in.
Ensure you have a stable internet connection and verify that your version of Excel supports third-party Office Add-ins, as you will likely need a market-data add-in to process ISIN lookups.
Use an Excel Market-Data Add-in for ISIN Searches
The most reliable way to get stock data using ISINs is by installing a dedicated financial add-in from the Microsoft store that natively supports ISIN lookups.
By default, Excel prefers standard ticker symbols. Financial add-ins bridge this gap by querying databases like Yahoo Finance that can map ISINs to actual market quotes.
Open your Excel workbook, navigate to the 'Insert' tab on the top ribbon, and click on 'Get Add-ins' to browse the Office Add-ins store.
Type 'Stock Connector' or 'Stock Quotes' into the search bar and press Enter. Click 'Add' next to a compatible market-data add-in.
Open the newly installed add-in from the ribbon or sidebar. Use its search field to paste your ISIN, select the correct security from the results, and insert the quote data into your desired cell.
Convert ISIN to Ticker via Yahoo Finance URL
If you cannot use an add-in, you can use a formula to generate a Yahoo Finance URL to manually convert your ISIN into a standard ticker symbol.
Manage Your Financial Portfolios Seamlessly with WPS Office
If you find Microsoft Excel's stock data limitations and add-in restrictions frustrating, consider managing your financial data with WPS Office. It provides a highly compatible, lightweight, and free environment for running advanced financial tracking spreadsheets without the steep learning curve.
Frequently Asked Questions
Why doesn't Excel's built-in Stocks feature recognize my ISIN?
Excel's native Stocks data type is primarily designed to recognize standard ticker symbols and company names. An ISIN (International Securities Identification Number) is often used by banks but typically requires mapping via a third-party add-in to be recognized as a stock quote.
Can I use WEBSERVICE and FILTERXML functions to scrape stock quotes using an ISIN?
While it is technically possible, using WEBSERVICE and FILTERXML is highly unreliable. Website HTML structures (like Yahoo Finance) change frequently, which easily breaks these formulas, and these functions may not be supported across all platforms.
What should I do if my stock quote add-in asks for a license?
Many third-party Excel add-ins use the Yahoo Finance API and limit free users to a specific number of queries (e.g., 50 quotes). To pull larger datasets, you will need to apply for an API key or purchase a premium license from the add-in provider.
