Intraday History 1 Minute Intervals (Dynamic)
Returns intraday price data in 1-minute intervals that automatically updates. This is the finest granularity available with dynamic updates.
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 to return |
| SortingOrder | String | No | Sort order for results |
Notes
- Most granular dynamic data available
- Very resource-intensive
- Use RecordCount to limit data
- Best for scalping dashboards
Syntax
=mxls.QM_GetIntradayDataOneMinutesDynamic(Symbol, [RecordCount], [SortingOrder])Examples
=mxls.QM_GetIntradayDataOneMinutesDynamic("AAPL", 60)=mxls.QM_GetIntradayDataOneMinutesDynamic("SPY", 100)=mxls.QM_GetIntradayDataOneMinutesDynamic(A1, B1, C1)When to Use
- Scalping dashboards
- High-frequency monitoring
- Micro price analysis
- Real-time tick-like data
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Don't need live updates | QM_GetIntradayDataOneMinutes() |
| Too resource-intensive | QM_GetIntradayDataFiveMinutesDynamic() |
| Need daily data | QM_GetHistory() |
| Need smoother data | Larger interval Dynamic functions |
Common Issues & FAQ
My spreadsheet is very slow. What can I do?
1-minute dynamic data is very resource-intensive. Use RecordCount to limit data (e.g., 60 bars = 1 hour). Consider 5-minute bars instead.
How much data is generated?
~390 bars per trading day. Use RecordCount to limit.
Is this necessary for day trading?
Usually 5-minute bars are sufficient. Only use 1-minute for scalping or precise timing.
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?