Why Excel STOCKHISTORY Does Not Show Intraday Stock Data
Question details
Users need to know why the STOCKHISTORY function in Excel does not return live intraday data during open market hours.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to retrieve real-time or intraday stock prices using the STOCKHISTORY function while the stock market is currently open.
- Observed behavior
- The function returns data from the latest completed trading session instead of live, minute-by-minute intraday prices.
Ensure you have a stable internet connection and an active Microsoft 365 subscription, as connected financial data functions require cloud access to function.
Verify Function Parameters and Provider Limitations
Check if your formula parameters and the specific stock exchange support the frequency of data you are trying to retrieve.
The STOCKHISTORY function is primarily designed to retrieve historical end-of-day data. Even with the Stock data type, third-party data providers may not support live streaming for all exchanges, resulting in a minimum 15-minute delay or end-of-day synchronization.
Double-click the cell containing your STOCKHISTORY formula. Look at the 'interval' argument (the fifth parameter). It accepts 0 (Daily), 1 (Weekly), or 2 (Monthly). It does not have a built-in parameter for intraday (hourly or minute) intervals.
Identify the stock exchange for your ticker symbol. Visit Microsoft's official financial data sources page to see if your specific market provides real-time updates or if it is restricted to end-of-day synchronization.
Navigate to the 'Data' tab on the Excel ribbon and click 'Refresh All' to ensure you have the most recently synchronized data snapshot from the provider.

Submit a Reproducible Sample Workbook to Microsoft
If the data appears completely incorrect or stopped updating entirely for a supported exchange, report the synchronization issue directly to Microsoft.
Manage Your Financial Data Efficiently with WPS Office
While advanced connected data functions like STOCKHISTORY are tied to Microsoft's specific third-party providers and limitations, you can handle complex financial tracking, data analysis, and budget planning effortlessly using WPS Office. It provides a lightweight, free alternative with absolute format compatibility.
- 1. Download and Install: Visit the official WPS website to download WPS Office for free and follow the simple installation instructions.
- 2. Open Your Financial Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx financial tracking files with perfect compatibility.
- 3. Analyze and Calculate: Use over 400 built-in formulas and robust charting tools to analyze your historical financial data seamlessly.

Frequently Asked Questions
Does STOCKHISTORY support real-time intraday intervals?
No. The STOCKHISTORY function's smallest time interval parameter is 'Daily' (represented by 0). It is designed to pull historical closing data, not minute-by-minute intraday prices.
Why is my Excel stock data delayed by 15 minutes?
Financial data in Excel is sourced from third-party providers like Refinitiv. According to market rules, standard data feeds for most major exchanges are delayed by 15 to 20 minutes unless you pay for a dedicated real-time streaming service, which is not included in standard Microsoft 365.
Is the STOCKHISTORY function available in Excel 2019 or 2016?
No. The STOCKHISTORY function is a dynamic array function exclusive to Microsoft 365 subscribers and Excel for the Web. It is not available in older standalone versions of Excel.




