Data Import & Export

Fix Missing or Incomplete STOCKHISTORY Data in Excel

Steve KSteve K Nov 10, 2026 870 views

Question details

The user is experiencing issues where the Excel STOCKHISTORY function fails to return recent weekly data, showing incomplete historical results.

How to Fix Missing or Incomplete STOCKHISTORY Data in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Pulling stock market data using the STOCKHISTORY function for business analysis or personal portfolio tracking.
Observed behavior
The function stops returning recent weekly data, stopping at a specific past date, while daily or monthly results might still populate, indicating an unreliable external data feed.
Before you start

Ensure you have a stable internet connection and are signed into your Microsoft 365 account, as the STOCKHISTORY function relies entirely on Microsoft's external market-data providers to fetch historical information.

Solution 1Recommended

Force a Data Refresh and Verify Workbook Settings

Triggering a manual calculation and verifying your workbook settings can resolve temporary syncing issues with the external data provider.

Because STOCKHISTORY pulls data from a cloud service, local caching issues or interrupted internet connections can cause the formula to return partial results. Forcing a refresh makes Excel query the server again.

1
Force a recalculation

Press F9 on your keyboard or navigate to the Formulas tab on the ribbon and click "Calculate Now" to force Excel to fetch the latest data from the provider.

2
Verify the ticker symbol

Ensure the stock ticker and exchange prefix (e.g., XNAS:MSFT) are formatted correctly and are currently supported by the financial data provider.

3
Check regional settings

Go to your Windows Settings > Time & Language > Region to ensure your date and time formats align with the stock exchange's local time zone, which can affect data retrieval boundaries.

4
Test in a new workbook

Open a completely blank Excel workbook and enter a simple STOCKHISTORY formula to check if the data issue is isolated to a corrupted file or cache in your current workbook.

Force a Data Refresh and Verify Workbook Settings
Data Provider Delays: Temporary outages or delayed weekly updates are often caused by the third-party data service. If refreshing does not work, you may need to wait a few hours for the external feed to recover.
Free Microsoft Office alternative

Try WPS Office for Reliable Data Analysis

If you are experiencing persistent issues with Excel's external data feeds or subscription requirements, consider switching to WPS Office. It is a lightweight, free alternative that offers robust spreadsheet tools, powerful data analysis functions, and seamless compatibility with your existing workbooks.

  1. 1. Download and install: Visit the official WPS Office website to download the free suite and follow the installation wizard.
  2. 2. Open WPS Spreadsheet: Launch WPS Office and click on 'Spreadsheet' from the main dashboard.
  3. 3. Import your data: Open your existing Excel files or import downloaded CSV market data to continue your financial analysis without interruption.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight installation with incredibly fast startup timesComprehensive data analysis, pivot tables, and charting toolsFamiliar user interface with zero learning curve for Excel users
microsoft office alternative - wps office

Frequently Asked Questions

Why does the STOCKHISTORY function return a #BUSY! error?

A #BUSY! error indicates that Excel is currently retrieving the data from the external financial data provider. Wait a few moments for the data to populate. If it persists, check your internet connection or press F9 to force a recalculation.

Are there limitations to the historical data provided by STOCKHISTORY?

Yes, STOCKHISTORY only supports data for instruments covered by Microsoft's third-party financial data provider. Additionally, historical data might not include certain pre-market or after-hours trading, and specific weekly intervals may occasionally experience publishing delays.

How can I pull stock data if STOCKHISTORY is completely down?

If Microsoft's data service experiences a prolonged outage, you can manually download historical stock data as a CSV file from financial websites like Yahoo Finance or Google Finance, and import that data directly into your spreadsheet using the 'Get Data' feature.

Does STOCKHISTORY require a Microsoft 365 subscription?

Yes, the STOCKHISTORY function is a premium connected feature that requires an active Microsoft 365 subscription. It is not available in standalone desktop versions of Excel such as Office 2019 or Office 2021.