Intraday History 1 Hour Intervals
Returns intraday price data aggregated into 1-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 hour |
| High | High price for the hour |
| Low | Low price for the hour |
| Close | Closing price for the hour |
| Volume | Volume for the hour |
Notes
- Each bar represents 1 hour of trading
- Regular trading day has ~7 hourly bars
- Least granular intraday data, least noise
Syntax
=QM_GetIntradayDataOneHour(Symbol)Returns
array
1-hour interval intraday price data
Examples
=QM_GetIntradayDataOneHour("AAPL")=QM_GetIntradayDataOneHour("SPY")=QM_GetIntradayDataOneHour("MSFT")Symbol from cell reference
When to Use
- Longer-term intraday analysis
- Position trading
- Hourly trend analysis
- When 5/15-min is too noisy
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need daily data | QM_GetHistory() |
| Need 5-minute bars | QM_GetIntradayDataFiveMinutes() |
| Need 15-minute bars | QM_GetIntradayDataFifteenMinutes() |
| Need auto-updating | QM_GetIntradayDataOneHourDynamic() |
Common Issues & FAQ
How many hourly bars are in a trading day?
Regular market hours (9:30 AM - 4:00 PM ET) produce approximately 7 hourly bars.
Why is the data not updating?
This is a static function. Use QM_GetIntradayDataOneHourDynamic() for auto-updating data.
Is this too coarse for day trading?
Possibly. Consider 5-minute or 15-minute bars for active day 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
▶
How does MarketXLS work?