Function Problems

Why Excel STOCKHISTORY Does Not Show Intraday Stock Data

Chanuka GeekiyanageChanuka Geekiyanage Oct 21, 2026 869 views

Question details

Users need to know why the STOCKHISTORY function in Excel does not return live intraday data during open market hours.

Why Excel STOCKHISTORY Does Not Show Intraday Stock Data
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.
Before you start

Ensure you have a stable internet connection and an active Microsoft 365 subscription, as connected financial data functions require cloud access to function.

Solution 1Recommended

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.

1
Check the interval parameter

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.

2
Verify the exchange limitations

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.

3
Refresh data connections

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.

Verify Function Parameters and Provider Limitations
Data Provider Delays: Most free or standard financial data feeds provided in spreadsheet software are subject to a 15 to 20-minute delay and are not intended for high-frequency live trading.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS website to download WPS Office for free and follow the simple installation instructions.
  2. 2. Open Your Financial Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx financial tracking files with perfect compatibility.
  3. 3. Analyze and Calculate: Use over 400 built-in formulas and robust charting tools to analyze your historical financial data seamlessly.
Fully compatible with Microsoft Excel (.xlsx) formatsLightweight and incredibly fast for handling large financial datasetsFree built-in templates for stock tracking and financial planningFamiliar user interface ensuring zero learning curve
microsoft office alternative - wps office

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.