Intraday History 4 Hour Intervals
Returns intraday price data aggregated into 4-hour bars using QuoteMedia's data service.
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 |
Output Columns
| Column | Description |
|---|---|
| DateTime | Bar timestamp |
| Open | Opening price for the 4-hour period |
| High | High price for the 4-hour period |
| Low | Low price for the 4-hour period |
| Close | Closing price for the 4-hour period |
| Volume | Volume for the 4-hour period |
Notes
- Each bar represents 4 hours of trading
- Only ~2 bars per trading day
- Very smooth data, minimal noise
Examples
=QM_GetIntradayDataFourHour("AAPL")=QM_GetIntradayDataFourHour("SPY")=QM_GetIntradayDataFourHour("TSLA")Symbol from cell reference
When to Use
- Very long-term intraday view
- Position/swing trading analysis
- When smaller intervals are too noisy
- Multi-day pattern analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need daily data | QM_GetHistory() |
| Need 1-hour bars | QM_GetIntradayDataOneHour() |
| Need finer detail | Smaller interval functions |
| Need auto-updating | QM_GetIntradayDataFourHourDynamic() |
Common Issues & FAQ
Q: Why so few bars? A: Regular market day (6.5 hours) produces less than 2 complete 4-hour bars. This timeframe is for very smooth data.
Q: When would I use 4-hour bars? A: For longer-term swing trading analysis or when smaller intervals produce too much noise.
Q: Is this similar to daily data? A: It's between 1-hour and daily. Use daily data for end-of-day analysis.
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?