Intraday History 5 Minute Intervals
Returns intraday price data aggregated into 5-minute bars using QuoteMedia's data service.
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 |
Output Columns
| Column | Description |
|---|---|
| DateTime | Bar timestamp |
| Open | Opening price for the 5-min period |
| High | High price for the 5-min period |
| Low | Low price for the 5-min period |
| Close | Closing price for the 5-min period |
| Volume | Volume for the 5-min period |
Notes
- Data is for current/recent trading day
- Each bar represents 5 minutes of trading
- Useful for short-term analysis and day trading
Syntax
=QM_GetIntradayDataFiveMinutes(Symbol)Examples
=QM_GetIntradayDataFiveMinutes("AAPL")=QM_GetIntradayDataFiveMinutes("SPY")=QM_GetIntradayDataFiveMinutes("TSLA")Symbol from cell reference
When to Use
- Day trading analysis
- Short-term technical analysis
- Building intraday charts
- Monitoring price action
When NOT to Use
Common Issues & FAQ
How much intraday data is available?
Typically current trading day data. For multiple days of intraday data, use the Dynamic version with RecordCount parameter.
Why is the data not updating?
This is a static function. Use QM_GetIntradayDataFiveMinutesDynamic() for auto-updating data.
What are market hours for the data?
Data covers regular market hours (9:30 AM - 4:00 PM ET). Pre/post market data may or may not be included.
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?