Intraday History 15 Minute Intervals (Dynamic)
Returns intraday price data in 15-minute intervals that automatically updates. Ideal for live 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
- Uses more resources than static version
- Good balance for swing trading dashboards
Syntax
=QM_GetIntradayDataFifteenMinutesDynamic(Symbol, [RecordCount])Parameters
symbolstringRequired
Stock ticker symbol
recordCountnumber
Number of bars to return (0 for all)
Returns
array
Dynamically updating 15-minute interval intraday price data
Examples
All AAPL 15-min bars
=QM_GetIntradayDataFifteenMinutesDynamic("SPY", 30)=QM_GetIntradayDataFifteenMinutesDynamic("TSLA", 50)Parameters from cells
When to Use
- Swing trading dashboards
- Real-time monitoring (less frequent updates)
- Auto-updating 15-min charts
- Active trading with moderate refresh
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Don't need live updates | QM_GetIntradayDataFifteenMinutes() |
| Need daily data | QM_GetHistory() |
| Need 5-minute bars | QM_GetIntradayDataFiveMinutesDynamic() |
| Need 1-hour bars | QM_GetIntradayDataOneHourDynamic() |
Common Issues & FAQ
My spreadsheet is slow. What can I do?
Use the RecordCount parameter to limit data. 15-minute bars produce less data than 5-minute, but still limit if needed.
How often does it update?
Updates occur automatically during market hours. New bars appear every 15 minutes.
Which interval should I choose?
15-minute is a good middle ground - less noisy than 5-min but more detail than 1-hour.
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?