MarketXLS

Historical Low Price

Returns the lowest traded price for a stock on a specific historical date. This represents the intraday low for that trading session.

Parameters

Parameter Type Required Description
Symbol string Yes Stock ticker symbol
OnDate date Yes The historical date

Date Format

The date can be provided as:

  • Excel DATE function: DATE(2024,1,15)
  • Cell reference containing a date
  • Date serial number

Supported Symbol Formats

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

Notes

  • Returns "NA" if market was closed (weekend, holiday)
  • Represents the lowest price reached during trading hours

Syntax

=Low_Historical(Symbol, OnDate)
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

onDatedateRequired

The date for which to retrieve the low price

Returns

number

Lowest price on the specified date

Examples

=Low_Historical("AAPL",DATE(2024,1,15))
Apple low on Jan 15, 2024
=Low_Historical("TSLA",DATE(2024,1,2))
Tesla low on Jan 2, 2024
=Low_Historical("SPY",DATE(2023,12,29))
SPY low on Dec 29, 2023
=Low_Historical("AAPL",A1)
Date from cell reference
=Low_Historical(B1,A1)
Symbol and date from cells

When to Use

  • Analyzing historical volatility (high-low range)
  • Building candlestick charts
  • Identifying support levels
  • Backtesting trading strategies

When NOT to Use

Scenario Use Instead
Need current day's low Low()
Need 52-week low x_week_low()
Need opening price Open_Historical()
Need closing price Close_Historical()

Common Issues & FAQ

Why am I getting "NA"?

The market was likely closed on that date (weekend, holiday) or the date is before the stock was listed.

How do I calculate the daily range?

Use: =High_Historical("AAPL",DATE(2024,1,15))-Low_Historical("AAPL",DATE(2024,1,15))

How do I format the date?

Use Excel's DATE function: DATE(year,month,day) - e.g., DATE(2024,1,15) for January 15, 2024.

Excel Templates Using Historical Low Price

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

Related Formulas

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

See Low_Historical used in a complete workbook: Bloomberg Alternative: The Best Excel-Native Financial Data Platform in 2026

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

Related Functions