'%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)
Fix NYSE RDDT Ticker Missing in Excel Stocks Data Type
Question details
The user is unable to retrieve financial data for the NYSE ticker RDDT using the built-in Stocks data type in Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to track a recently listed stock (RDDT) using the automated Stocks data type in a financial spreadsheet.
- Observed behavior
- The RDDT ticker is not recognized, and Excel fails to populate the associated stock information or delayed prices.
Ensure your device is connected to the internet and that you have an active Microsoft 365 subscription, as the Stocks data type requires a continuous online connection to retrieve external financial data.
Monitor External Data Provider Updates
Excel relies on external providers for stock data, so recently listed stocks may experience a delay before becoming fully available in the system.
Microsoft Excel does not generate its own stock market data. Instead, stock information and delayed prices are exclusively supplied by Refinitiv. The availability of a specific ticker depends entirely on how the exchange reports the activity and when Refinitiv updates their databases.
For recently listed stocks like RDDT, it is common to experience synchronization delays across different financial platforms.
Verify if other platforms like Yahoo Finance are showing delayed or fully propagated price information for the NYSE RDDT ticker to confirm market availability.
Open your spreadsheet, navigate to the 'Data' tab on the top ribbon, and click 'Refresh All'. Do this periodically over a few days to see if the ticker has been added to the Refinitiv feed.
Submit a Support Ticket via Microsoft 365 Admin Center
If the ticker remains unavailable for an extended period, administrators can request Microsoft to investigate the missing data feed.
Try WPS Office for Seamless Spreadsheet Management
While Excel's stock data relies heavily on specific external providers, WPS Office offers a free, lightweight, and highly compatible alternative for all your spreadsheet, document, and presentation needs. Enjoy a familiar interface without the heavy subscription fees.
- 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
- 2. Install the Software: Run the downloaded file and follow the simple on-screen instructions to complete the installation.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly with full formatting and formula compatibility.
Frequently Asked Questions
Why do newly listed stocks not appear in Excel immediately?
Excel relies on external financial data providers, primarily Refinitiv, to supply stock information. Newly listed stocks often experience a delay while the exchanges and data providers synchronize their reporting feeds.
How often is the Excel Stocks data type updated?
Price information and company data are updated continuously when you click 'Refresh All' in the Data tab, though market prices are typically delayed by about 15 minutes depending on the specific exchange's rules.
Can I manually add a missing stock ticker to Excel?
No, you cannot manually add a missing ticker to the built-in Stocks data type. You must wait for Refinitiv to add the ticker to their database or use a manual web query to pull the data from another financial website.
Are there workarounds if the Stocks data type fails to find a ticker?
Yes, you can use the 'From Web' feature under the Data tab to import stock prices from a reliable financial website like Yahoo Finance or Google Finance as a temporary workaround until the ticker is officially supported.
