Fix Excel Displaying Wrong Stock Price for Roche Holding
Question details
Users are experiencing inaccurate pricing data when using Excel's linked stock data type for Roche Holding Ltd (XSWX:RO).
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Tracking stock portfolios and fetching live financial data using Excel's linked Stock data types.
- Observed behavior
- Excel displays an inaccurate price of approximately CHF 375.60 instead of the actual market price of CHF 300 for the ticker XSWX:RO.
Ensure your internet connection is active and manually click 'Refresh All' on the Data tab to confirm Excel is not just displaying cached, outdated market data.
Report the Incorrect Market Data to Microsoft
Since the stock data is pulled from third-party market providers, reporting the error prompts Microsoft to investigate and correct the backend data source feed.
Excel's linked data types rely on external financial market data providers. When a specific stock like Roche Holding Ltd (XSWX:RO) displays an incorrect value consistently, it is a backend data feed issue rather than a local software bug. Reporting the issue directly from the data card is the fastest way to flag it for correction.
Click on the cell containing the incorrect Roche Holding stock data (XSWX:RO) in your worksheet.
Right-click the cell, hover over 'Data Type' in the context menu, and select 'Show Card' to view the detailed financial metrics.
Scroll to the bottom of the data card and click the 'Provide Feedback' or flag icon.
Describe the discrepancy in the feedback form, mentioning the actual market price versus the displayed price, and submit it to Microsoft.
Import Stock Prices Manually Using Web Query
Use Excel's 'From Web' feature to pull correct stock prices from a reliable financial website as a temporary workaround.
Manage Financial Data Seamlessly with WPS Office
While external backend data feed errors in Excel can disrupt your portfolio tracking, WPS Office provides a robust, lightweight, and completely free alternative for managing complex financial spreadsheets. Enjoy a familiar interface and excellent compatibility without subscription fees.
Frequently Asked Questions
Why do Excel linked data types show wrong stock prices?
Excel pulls stock data from third-party financial exchanges and providers. Discrepancies usually occur due to backend data feed errors from the provider, delays in data transmission, or incorrect ticker mapping.
How often do Excel stock data types update?
Stock prices in Excel are not strictly real-time. Depending on the exchange and the specific data provider, prices are typically delayed by 15 to 20 minutes.
Can I manually override the stock price in an Excel linked data type?
You cannot directly edit the pulled value inside a cell formatted as a linked data type. However, you can extract the data into an adjacent cell using formulas and then apply manual adjustments to that new cell if necessary.
