High Price (On Demand)

Gets today's session high price on-demand (snapshot) from QuoteMedia. This is the highest price traded during the current session.

Supported Symbol Formats

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

Notes

Returns a snapshot (does not auto-update)
Resets at market open each day
Useful for OHLC data collection

Syntax

=QM_High(Symbol)

Excel Desktop (Windows)

Returns

number

Session high price (on-demand snapshot)

Examples

=QM_High("AAPL")

High price for Apple

=QM_High("MSFT")

High price for Microsoft

=QM_High("SPY")

High price for SPY ETF

=QM_High(A1)

Symbol from cell reference

When to Use

Static OHLC reports
Daily range analysis
When streaming is not needed
Snapshot reports

When NOT to Use

Scenario	Use Instead
Need streaming high	`QM_Stream_High()`
Need historical high	`High_Historical()`
Need 52-week high	`52WeekHigh()`

Common Issues & FAQ

How do I calculate the daily range?

Use =QM_High("AAPL")-QM_Low("AAPL").

Why does the high equal the open early in the session?

Until a higher price is traded, the high will equal the opening price.

Why am I getting #N/A?

Check that symbol format is correct.

Related Formulas

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

See QM_High used in a complete workbook: Option Price in Excel: Pull Live Options Data, Greeks & Pricing Models Into Your Spreadsheet

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 High Price (On Demand) and Other Financial Formulas

▶

How does MarketXLS work?