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
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
Common Issues & FAQ
Q: My spreadsheet is slow. What can I do? A: 1-hour bars use less resources than smaller intervals. If still slow, use RecordCount to limit data.
Q: How often does it update? A: Updates occur hourly with new bar data, but the current bar updates continuously.
Q: Can I get more history? A: Use RecordCount parameter. Setting to 0 returns all available data.
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?