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
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
Common Issues & FAQ
Q: My spreadsheet is slow. What can I do? A: Use the RecordCount parameter to limit data. 15-minute bars produce less data than 5-minute, but still limit if needed.
Q: How often does it update? A: Updates occur automatically during market hours. New bars appear every 15 minutes.
Q: Which interval should I choose? A: 15-minute is a good middle ground - less noisy than 5-min but more detail than 1-hour.
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?