Fix STOCKHISTORY Not Updating and TODAY Showing Old Date in Excel
Question details
The user needs to resolve an issue where the STOCKHISTORY function stops updating and the TODAY function returns an outdated date.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Using the STOCKHISTORY and TODAY functions to track current and historical stock market data.
- Observed behavior
- The STOCKHISTORY function stops pulling new data, and the TODAY function is stuck on an old date instead of showing the current system date.
Ensure your computer's system date and time are correct, as Excel relies on the operating system's clock for date-related functions.
Enable Automatic Workbook Calculation
Switch the calculation mode from manual to automatic so functions like TODAY() and STOCKHISTORY refresh automatically.
When workbook calculation is set to manual, volatile functions like TODAY() will not update until you force a recalculation. This causes dependent functions like STOCKHISTORY to return outdated market data.
Open your Excel workbook, click on the 'File' tab in the top-left corner, and select 'Options' at the bottom of the menu.
In the Excel Options dialog box, click on 'Formulas' in the left-hand pane.
Under the 'Calculation options' section, select the 'Automatic' radio button for Workbook Calculation.
Click 'OK' to save the changes. Enter =TODAY() in a blank cell formatted as a date to verify it now returns the current date.

Verify Formula References for the End Date
Ensure that the STOCKHISTORY formula uses a dynamic date reference rather than a hardcoded past date.
Try WPS Office for Seamless Spreadsheet Management
If you are experiencing persistent calculation issues or formula errors in Microsoft Excel, consider switching to WPS Office. It is a free, lightweight, and highly compatible alternative that handles complex formulas and data analysis with ease.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open Your Workbook: Launch WPS Spreadsheet and click 'Open' to select your existing Excel workbook.
- 3. Resume Your Work: Continue working with your formulas and data seamlessly in a familiar, highly compatible interface.

Frequently Asked Questions
Why does STOCKHISTORY not show today's stock price?
Historical market data typically becomes available only after the trading day ends. STOCKHISTORY is designed to pull historical closing prices, not real-time intraday data.
How do I force Excel to recalculate formulas manually?
If you prefer to keep your workbook calculation set to Manual, you can force Excel to recalculate all formulas by pressing the F9 key on your keyboard.
Does STOCKHISTORY update automatically when I open the workbook?
Yes, if automatic calculation is enabled and the formula uses a volatile function like TODAY() for its date arguments, STOCKHISTORY will refresh its data when the workbook is opened.




