MarketXLS

Intraday History 4 Hour Intervals (Dynamic)

Returns intraday price data in 4-hour intervals that automatically updates.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ

Parameters

Parameter Type Required Description
Symbol String Yes Stock ticker symbol
RecordCount Number No Number of bars to return
SortingOrder String No Sort order for results

Notes

  • Data auto-updates during market hours
  • Very coarse timeframe - only ~2 bars per day
  • Least resource-intensive dynamic intraday option

Syntax

=mxls.QM_GetIntradayDataFourHourDynamic(Symbol, [RecordCount], [SortingOrder])
Excel Online (Mac & Windows)

Parameters

symbolstringRequired

Stock ticker symbol

recordCountnumber

Number of bars to return

sortingOrderstring

Sort order for results

Returns

array

Dynamically updating 4-hour interval intraday price data

Examples

=mxls.QM_GetIntradayDataFourHourDynamic("AAPL")
All AAPL 4-hour bars
=mxls.QM_GetIntradayDataFourHourDynamic("SPY", 10)
Last 10 4-hour bars
=mxls.QM_GetIntradayDataFourHourDynamic(A1, B1, C1)
Parameters from cells

When to Use

  • Very long-term intraday monitoring
  • Low-resource dynamic data
  • Position trading dashboards
  • Multi-day trend analysis

When NOT to Use

Scenario Use Instead
Don't need live updates QM_GetIntradayDataFourHour()
Need daily data QM_GetHistory()
Need 1-hour bars QM_GetIntradayDataOneHourDynamic()
Need finer detail Smaller interval Dynamic functions

Common Issues & FAQ

Why use 4-hour bars?

4-hour bars provide smoothest intraday data with minimal noise. Good for long-term trend analysis.

How many bars per day?

Only about 2 complete 4-hour bars per trading day (6.5 hours).

Is this the best for day trading?

No, use smaller intervals (5-min, 15-min) for day trading. 4-hour is for position/swing trading.

Related Formulas

More MarketXLS Price History formulas you can use in the same worksheet:

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Intraday History 4 Hour Intervals (Dynamic) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions