Fix Excel Refinitiv Stock Data Missing New Exchange Tickers
Question details
Users are unable to retrieve data for newly listed stock symbols using the built-in Stock Data type.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to track newly listed stock tickers (e.g., XNAS:AVBP, XNAS:CGON, BATS:FBTC) using the automated Stock data type feature.
- Observed behavior
- Excel fails to recognize the new exchange tickers, returning errors instead of financial data, even though alternative platforms recognize them immediately.
Verify that your internet connection is active and that your Microsoft 365 subscription is fully licensed, as the Stocks data type relies on an active online service connection.
Use the Exchange-Qualified Ticker Format
Ensure you are using the precise exchange prefix, which helps the data provider correctly identify newly listed assets.
Sometimes newly added stocks share tickers with other assets globally or are highly specific to an exchange. Formatting the ticker properly forces Excel to search the exact exchange database.
Click the cell containing the unrecognized stock symbol in your worksheet.
Modify the ticker to include the specific exchange code. For example, instead of typing 'AVBP', type 'XNAS:AVBP' or 'BATS:FBTC'.
Highlight the modified cell, navigate to the Data tab on the ribbon, and click 'Stocks' to re-evaluate the symbol.
Allow Time for Refinitiv Database Synchronization
Newly listed exchange symbols experience a propagation delay in the Refinitiv backend database.
Import External CSV Data as a Workaround
If you need immediate access to new tickers, manually import the data from alternative financial sources.
Manage Financial Data with WPS Office Spreadsheet
If you are frustrated by delays in Microsoft Excel's Refinitiv stock data updates, consider switching to WPS Office. It provides a lightweight, fast, and completely free alternative for managing complex financial spreadsheets without compromising functionality.
- 1. Download WPS Office: Visit the official WPS website and download the free software suite.
- 2. Open your financial workbook: Launch WPS Spreadsheets and open your existing .xlsx stock portfolio file.
- 3. Analyze your data: Use the built-in financial functions to track, manipulate, and analyze your investments seamlessly.
Frequently Asked Questions
How long does it take for Refinitiv to add new stock tickers to Excel?
It can take anywhere from a few days to several weeks for newly listed companies, SPACs, or ETFs to fully propagate into the Excel Refinitiv database.
Why do missing stock symbols show a #FIELD! error?
The #FIELD! error occurs because Excel is attempting to pull specific data fields (like price, volume, or market cap) for a ticker that the connected Refinitiv database does not yet recognize.
Can I contact Refinitiv support directly for Excel data issues?
Usually, Refinitiv will direct you back to Microsoft, as individual Excel users are not direct Refinitiv enterprise customers. You should submit a request through Excel's Help > Feedback menu to report missing symbols.
