'%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 Outdated Refinitiv Stock Data in Microsoft Excel
Question details
Users are experiencing outdated or missing stock data for specific tickers (such as CFG PR H) provided by Refinitiv and need a way to report and fix this issue.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to pull real-time or updated stock information for recently listed tickers using the Excel Stock data type.
- Observed behavior
- The stock data provided by Refinitiv is outdated or completely missing for specific newly listed NYSE/XNYS tickers.
Ensure your Microsoft 365 subscription is active and that your Excel application is updated to the latest version, as connected data types require an active internet connection and current software to sync properly.
Report Missing Data via the Excel Feedback Portal
Because Microsoft relies on a third-party provider (Refinitiv) for stock data, the most effective way to correct missing or outdated tickers is by reporting it directly to Microsoft.
Excel retrieves its financial and stock information through a partnership with Refinitiv. When a newly listed ticker is missing or outdated, Microsoft must escalate the issue to Refinitiv's database managers. Submitting structured feedback is the official channel to trigger this update.
Launch your Microsoft Excel application and open any new or existing workbook.
Click on the 'Help' tab located in the top ribbon menu of the Excel interface.
Select 'Feedback' or 'Send Feedback' from the available menu options to open the feedback pane.
Choose 'Report a problem' or 'I have a suggestion'. Detail the specific outdated ticker (e.g., CFG PR H) and explicitly note that the Refinitiv stock data needs to be updated for this listing.
Submit your report, copy the generated feedback link, and share it with other affected users on community forums. Additional upvotes significantly increase the issue's visibility with Microsoft.
Try WPS Office for Your Spreadsheet Needs
If you are experiencing limitations or delays with third-party data integrations in Microsoft Excel, consider WPS Office as a fast, lightweight, and completely free alternative. WPS Spreadsheet offers comprehensive data analysis tools, familiar financial formulas, and seamless compatibility with all your existing workbooks.
- 1. Download and Install: Visit the official WPS website to download the free installation package for your operating system.
- 2. Launch WPS Spreadsheet: Open WPS Office and select the Spreadsheet module to start a new document or import existing files.
- 3. Manage Financial Data: Open your existing Excel workbooks seamlessly and use advanced formulas to track and analyze your financial data.
Frequently Asked Questions
Where does Excel get its stock and financial data?
Microsoft Excel sources its financial and stock data, including historical quotes and real-time pricing, through a direct data partnership with Refinitiv.
Why is my stock data not refreshing in Excel?
Stock data may fail to refresh if you have a weak internet connection, an expired Microsoft 365 subscription, or if the third-party data provider has not yet added the newly listed ticker symbol to their database.
Can I manually update a stock ticker's price in Excel?
You cannot manually overwrite the connected Stock data type field without breaking its automatic link. However, as a temporary workaround, you can manually type the current price in a separate, unlinked adjacent cell until the data provider fixes the issue.
How long does it take for Refinitiv to update missing tickers?
The timeline varies significantly. Updating missing or newly listed tickers depends on the volume of user feedback submitted to Microsoft and the routine data syncing schedule between Microsoft and Refinitiv.
