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
Examples
=QM_GetIntradayDataFourHourDynamic("AAPL")=QM_GetIntradayDataFourHourDynamic("SPY", 10)=QM_GetIntradayDataFourHourDynamic(A1, B1, C1)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
Q: Why use 4-hour bars? A: 4-hour bars provide smoothest intraday data with minimal noise. Good for long-term trend analysis.
Q: How many bars per day? A: Only about 2 complete 4-hour bars per trading day (6.5 hours).
Q: Is this the best for day trading? A: No, use smaller intervals (5-min, 15-min) for day trading. 4-hour is for position/swing trading.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?