Intraday History 15 Minute Intervals
Returns intraday price data aggregated into 15-minute 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 15-min period |
| High | High price for the 15-min period |
| Low | Low price for the 15-min period |
| Close | Closing price for the 15-min period |
| Volume | Volume for the 15-min period |
Notes
- Each bar represents 15 minutes of trading
- Good balance between detail and noise reduction
- Popular timeframe for swing traders
Syntax
=QM_GetIntradayDataFifteenMinutes(Symbol)Returns
array
15-minute interval intraday price data
Examples
=QM_GetIntradayDataFifteenMinutes("AAPL")=QM_GetIntradayDataFifteenMinutes("SPY")=QM_GetIntradayDataFifteenMinutes("MSFT")Symbol from cell reference
When to Use
- Swing trading analysis
- Medium-term intraday analysis
- Building 15-minute charts
- Less noisy than 5-minute data
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need daily data | QM_GetHistory() |
| Need 5-minute bars | QM_GetIntradayDataFiveMinutes() |
| Need 1-hour bars | QM_GetIntradayDataOneHour() |
| Need auto-updating | QM_GetIntradayDataFifteenMinutesDynamic() |
Common Issues & FAQ
How many 15-minute bars are in a trading day?
Regular market hours (6.5 hours) produce 26 fifteen-minute bars per day.
Why is the data not updating?
This is a static function. Use QM_GetIntradayDataFifteenMinutesDynamic() for auto-updating data.
What timeframe of data is returned?
Typically returns current/recent trading day 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?