Calculation Issues

Fix STOCKHISTORY Not Updating and TODAY Showing Old Date in Excel

Phi Hung VoPhi Hung Vo Nov 10, 2026 869 views

Question details

The user needs to resolve an issue where the STOCKHISTORY function stops updating and the TODAY function returns an outdated date.

How to Fix STOCKHISTORY Not Updating and TODAY Showing an Old 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.
Before you start

Ensure your computer's system date and time are correct, as Excel relies on the operating system's clock for date-related functions.

Solution 1Recommended

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.

1
Open Excel Options

Open your Excel workbook, click on the 'File' tab in the top-left corner, and select 'Options' at the bottom of the menu.

2
Navigate to Formulas

In the Excel Options dialog box, click on 'Formulas' in the left-hand pane.

3
Set to Automatic

Under the 'Calculation options' section, select the 'Automatic' radio button for Workbook Calculation.

4
Apply Changes

Click 'OK' to save the changes. Enter =TODAY() in a blank cell formatted as a date to verify it now returns the current date.

Enable Automatic Workbook Calculation
Calculation Refreshed: Once set to Automatic, the TODAY() function will update immediately, which should also trigger STOCKHISTORY to pull the latest available data.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
  2. 2. Open Your Workbook: Launch WPS Spreadsheet and click 'Open' to select your existing Excel workbook.
  3. 3. Resume Your Work: Continue working with your formulas and data seamlessly in a familiar, highly compatible interface.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Lightweight application that opens large datasets quickly without lagging.Familiar user interface with a comprehensive built-in formula library.Free to use with powerful data analysis and visualization tools.
microsoft office alternative - wps office

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.