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
Syntax
=QM_GetIntradayDataFiveMinutesDynamic(Symbol, [RecordCount])Parameters
symbolstringRequired
Stock ticker symbol
recordCountnumber
Number of bars to return (0 for all)
Returns
array
Dynamically updating 5-minute interval intraday price data
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
| Scenario | Use Instead |
|---|---|
| Don't need live updates | QM_GetIntradayDataFiveMinutes() |
| Need daily data | QM_GetHistory() |
| Need 1-hour bars | QM_GetIntradayDataOneHourDynamic() |
| Need 15-minute bars | QM_GetIntradayDataFifteenMinutesDynamic() |
Common Issues & FAQ
My spreadsheet is slow. What can I do?
Use the RecordCount parameter to limit data. Instead of all bars, request only what you need (e.g., last 50 bars).
How often does it update?
Updates occur automatically during market hours, typically every few seconds.
Can I use this for multiple symbols?
Yes, but each dynamic function uses resources. Limit usage for better performance.
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?