Intraday History 15 Minute Intervals

Returns intraday price data aggregated into 15-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 15-min period
High High price for the 15-min period
Low Low price for the 15-min period
Close Closing price for the 15-min period
Volume Volume for the 15-min period

Notes

  • Each bar represents 15 minutes of trading
  • Good balance between detail and noise reduction
  • Popular timeframe for swing traders

Examples

=QM_GetIntradayDataFifteenMinutes("AAPL")
Apple 15-min bars
=QM_GetIntradayDataFifteenMinutes("SPY")
SPY 15-min bars
=QM_GetIntradayDataFifteenMinutes("MSFT")
Microsoft 15-min bars
=QM_GetIntradayDataFifteenMinutes(A1)
Symbol from cell reference

When to Use

  • Swing trading analysis
  • Medium-term intraday analysis
  • Building 15-minute charts
  • Less noisy than 5-minute data

When NOT to Use

Scenario Use Instead
Need daily data QM_GetHistory()
Need 5-minute bars QM_GetIntradayDataFiveMinutes()
Need 1-hour bars QM_GetIntradayDataOneHour()
Need auto-updating QM_GetIntradayDataFifteenMinutesDynamic()

Common Issues & FAQ

Q: How many 15-minute bars are in a trading day? A: Regular market hours (6.5 hours) produce 26 fifteen-minute bars per day.

Q: Why is the data not updating? A: This is a static function. Use QM_GetIntradayDataFifteenMinutesDynamic() for auto-updating data.

Q: What timeframe of data is returned? A: Typically returns current/recent trading day data.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Intraday History 15 Minute Intervals and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions