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)Returns
array
5-minute interval intraday price data
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
| Scenario | Use Instead |
|---|---|
| Need daily data | QM_GetHistory() |
| Need 15-minute bars | QM_GetIntradayDataFifteenMinutes() |
| Need 1-hour bars | QM_GetIntradayDataOneHour() |
| Need auto-updating | QM_GetIntradayDataFiveMinutesDynamic() |
| Need 1-minute bars | QM_GetIntradayDataOneMinutes() |
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.
Related Formulas
More MarketXLS Price History formulas you can use in the same worksheet:
- IVRank1Year
- Low Price (Month End)
- Low Price (Quarter End)
- Low Price (Year End)
- Low Price In X Number Of Days
- Low Price In X Number Of Weeks
- Mid Historical
- Oneyearclose
See QM_GetIntradayDataFiveMinutes used in a complete workbook: GOOGLEFINANCE Alternative: Why Financial Advisors and Traders Need More Than Free Data
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?