Intraday History 5 Minute Intervals (Dynamic)
Returns intraday price data in 5-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
- RecordCount limits data for better performance
Examples
=QM_GetIntradayDataFiveMinutesDynamic("AAPL")=QM_GetIntradayDataFiveMinutesDynamic("SPY", 50)=QM_GetIntradayDataFiveMinutesDynamic("TSLA", 100)=QM_GetIntradayDataFiveMinutesDynamic(A1, B1)When to Use
- Live trading dashboards
- Real-time monitoring
- Auto-updating charts
- Active day trading
When NOT to Use
Common Issues & FAQ
Q: My spreadsheet is slow. What can I do? A: Use the RecordCount parameter to limit data. Instead of all bars, request only what you need (e.g., last 50 bars).
Q: How often does it update? A: Updates occur automatically during market hours, typically every few seconds.
Q: Can I use this for multiple symbols? A: Yes, but each dynamic function uses resources. Limit usage for better performance.
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?