Intraday History 1 Hour Intervals (Dynamic)
Returns intraday price data in 1-hour intervals that automatically updates. Ideal for position trading dashboards.
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 (0 = all available) |
Output Columns
| Column | Description |
|---|---|
| DateTime | Bar timestamp |
| Open | Opening price |
| High | High price |
| Low | Low price |
| Close | Closing price |
| Volume | Volume |
Notes
- Data auto-updates during market hours
- Less resource-intensive than smaller intervals
- Good for position trading dashboards
Syntax
=QM_GetIntradayDataOneHourDynamic(Symbol, [RecordCount])Parameters
symbolstringRequired
Stock ticker symbol
recordCountnumber
Number of bars to return (0 for all)
Returns
array
Dynamically updating 1-hour interval intraday price data
Examples
=QM_GetIntradayDataOneHourDynamic("AAPL")=QM_GetIntradayDataOneHourDynamic("SPY", 20)=QM_GetIntradayDataOneHourDynamic("TSLA", 50)=QM_GetIntradayDataOneHourDynamic(A1, B1)When to Use
- Position trading dashboards
- Longer-term intraday monitoring
- Auto-updating hourly charts
- Less resource-intensive live data
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Don't need live updates | QM_GetIntradayDataOneHour() |
| Need daily data | QM_GetHistory() |
| Need 5-minute bars | QM_GetIntradayDataFiveMinutesDynamic() |
| Need 15-minute bars | QM_GetIntradayDataFifteenMinutesDynamic() |
Common Issues & FAQ
My spreadsheet is slow. What can I do?
1-hour bars use less resources than smaller intervals. If still slow, use RecordCount to limit data.
How often does it update?
Updates occur hourly with new bar data, but the current bar updates continuously.
Can I get more history?
Use RecordCount parameter. Setting to 0 returns all available data.
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
▶
How does MarketXLS work?