Why Excel STOCKHISTORY Does Not Show Today's Stock Price
Question details
The user is trying to retrieve the current day's stock price using the STOCKHISTORY function, but it only returns historical data up to the previous trading day.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Tracking live or same-day stock market data and building financial tracking models in a spreadsheet.
- Observed behavior
- The STOCKHISTORY function fails to include the current trading day's price, whereas real-time functions like STOCKPRICE successfully display updated intraday prices.
Ensure you have an active internet connection and that your Office subscription supports linked Data Types, as fetching live financial data requires cloud connectivity.
Use Live Stock Data Types for Today's Price
Since STOCKHISTORY is designed specifically for completed past trading days, you should use Excel's built-in Stock Data Types for real-time or current day quotes.
The STOCKHISTORY function relies on finalized historical data feeds. These feeds are typically published by market data providers at the end of the trading day or the following morning. To get real-time or intraday stock prices, you must use tools designed for live quote feeds rather than historical logs.
Click on a blank cell in your spreadsheet and type the stock ticker symbol you want to track (e.g., MSFT or AAPL).
Select the cell containing the ticker symbol, navigate to the 'Data' tab on the top ribbon, and click on 'Stocks' within the Data Types gallery.
Click the small 'Insert Data' icon that appears to the upper right of the selected cell, and choose 'Price' from the dropdown menu to display the current trading day's value.

Experience Seamless Financial Tracking with WPS Office
While live stock data feeds and linked Data Types are specific to Microsoft 365 subscriptions, WPS Office offers a completely free, highly compatible alternative for your broader financial modeling, data analysis, and spreadsheet needs.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and easily open your existing .xlsx financial tracking files.
- 3. Analyze Your Data: Utilize WPS Spreadsheets' extensive library of formulas and intuitive charting tools to analyze your portfolio.

Frequently Asked Questions
When does the STOCKHISTORY function update with yesterday's data?
STOCKHISTORY typically updates the previous day's closing price the following morning. The exact timing depends on when the market data provider publishes the completed and finalized historical record for that exchange.
Why does the STOCKPRICE function work for today but not STOCKHISTORY?
The STOCKPRICE function utilizes a separate, real-time quote feed that is explicitly designed for intraday updates. Conversely, STOCKHISTORY strictly queries historical databases that only store fully closed and verified daily trading sessions.
Is there a way to force STOCKHISTORY to show today's price?
No, STOCKHISTORY cannot be forced to show the current day's price before the historical record is officially published. You must combine it with real-time data functions or linked Data Types to see today's value.




