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

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

Q: How do I calculate the daily range? A: Use =QM_High("AAPL")-QM_Low("AAPL").

Q: Why does the high equal the open early in the session? A: Until a higher price is traded, the high will equal the opening price.

Q: Why am I getting #N/A? A: Check that symbol format is correct.

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?

Related Functions