Why Excel Stocks Data Cannot Find Certain Companies or Tickers
Question details
The user is unable to retrieve financial information for specific companies or ticker symbols using the built-in Excel Stocks data type.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Using the Stocks data type in Excel to track financial data and market information for specific companies.
- Observed behavior
- Excel fails to find or retrieve stock information for certain companies, such as BITA, SOGO, CLDR, AYR, and RARX.
Ensure you have a stable internet connection and an active Microsoft 365 subscription, as the Stocks data type requires online access to function properly.
Verify Ticker Availability in Microsoft's Data Sources
Excel relies on third-party financial data providers, meaning only supported companies can be retrieved.
Excel does not maintain its own internal database of global stock markets. Instead, the Stocks data type fetches information from Microsoft's third-party financial data providers, such as Refinitiv.
If a specific company or ticker symbol is not indexed by these providers, Excel will not be able to locate or retrieve its financial data.
Sometimes a company is listed under a different ticker symbol or on a different stock exchange. Try typing the company's full legal name instead of just the ticker symbol, then convert it to the Stocks data type to see if Excel finds a match.
Review Microsoft's official documentation regarding the sources of stock and financial data. This will help you verify if your required exchange or specific data provider is officially supported by the Excel ecosystem.
Manage Your Financial Data Seamlessly with WPS Office
While Excel's built-in Stocks feature relies on specific third-party providers that may lack certain tickers, you can still manage comprehensive financial portfolios using WPS Spreadsheet. Import custom financial CSVs, pull data directly from alternative web sources, and process complex stock formulas entirely for free.
- 1. Download and install WPS Office: Visit the official WPS website to download the free office suite and install it on your device.
- 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and create a new blank workbook or open your existing financial tracking document.
- 3. Import custom financial data: Use the Data tab to import CSV files or external web data containing the exact stock tickers and prices you need.
Frequently Asked Questions
Why does Excel show a #FIELD! error for my stock data?
This usually happens when a specific data field (like P/E ratio or 52-week high) you are trying to extract is not provided by the third-party financial source for that particular stock.
Can I manually add a missing stock to Excel's data type?
No, you cannot manually inject a new company into the built-in Stocks data type. However, you can manually input the pricing data or import it from an alternative web source using Power Query.
Are cryptocurrency tickers supported in Excel Stocks?
Yes, Excel supports some major cryptocurrencies, but availability is still strictly limited to what Microsoft's data providers actively supply and track.
