MarketXLS

Stream High Price

Streams the real-time session high price for stocks and ETFs. This represents the highest price the security has traded at during the current trading session.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ
Indices ^SYMBOL ^SPX, ^VIX
Options OCC Symbol AAPL240315C00170000

Notes

  • Data streams automatically update in Excel
  • High resets at market open each day
  • Use for OHLC (Open, High, Low, Close) data collection

Syntax

=QM_Stream_High(Symbol)
Excel Desktop (Windows)

Returns

number

Real-time streaming session high price

Examples

=QM_Stream_High("AAPL")
Stream session high for Apple
=QM_Stream_High("MSFT")
Stream session high for Microsoft
=QM_Stream_High("SPY")
Stream session high for SPY ETF
=QM_Stream_High(A1)
Symbol from cell reference
=QM_Stream_High("AAPL")-QM_Stream_Low("AAPL")
Calculate daily range

When to Use

  • Tracking intraday price range
  • Building OHLC displays
  • Identifying breakout levels
  • Setting price alerts

When NOT to Use

Scenario Use Instead
Need 52-week high 52WeekHigh()
Need historical high High_Historical()
Need on-demand high QM_High()
Need annual high indicator QM_Stream_IsAnnualHigh()

Common Issues & FAQ

Why does the high equal the open price?

Early in the trading session, the high may equal the open until a higher price is traded.

How do I calculate the daily range?

Use =QM_Stream_High("AAPL")-QM_Stream_Low("AAPL").

Why am I getting #N/A?

Check that symbol format is correct.

Excel Templates Using Stream High Price

These ready-made MarketXLS templates call QM_Stream_High() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Price Quotes (Streaming) formulas you can use in the same worksheet:

See QM_Stream_High used in a complete workbook: Real Time Futures Prices in Excel: Live Streaming Data with MarketXLS 2025

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 Stream High Price and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions