Low Price (On Demand)

Gets today's session low price on-demand (snapshot) from QuoteMedia. This is the lowest 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_Low(Symbol)

Excel Desktop (Windows)

Examples

=QM_Low("AAPL")

Low price for Apple

=QM_Low("MSFT")

Low price for Microsoft

=QM_Low("SPY")

Low price for SPY ETF

=QM_Low(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 low	`QM_Stream_Low()`
Need historical low	`Low_Historical()`
Need 52-week low	`52WeekLow()`

Common Issues & FAQ

How do I calculate the daily range?

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

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

Until a lower price is traded, the low 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_Low 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 Low Price (On Demand) and Other Financial Formulas

▶

How does MarketXLS work?