MarketXLS

Low Price Between 2 Dates In History

Returns the lowest value of a specified price field between two dates. By default, it uses closing prices.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ

Parameters

Parameter Description Default
Symbol Stock ticker Required
StartDate Start of range Required
EndDate End of range Required
DataField Price field "close"

DataField Options

  • close - Closing prices (default)
  • high - Daily high prices
  • low - Daily low prices
  • open - Opening prices

Syntax

=custom_dates_low(Symbol, StartDate, EndDate, [DataField])
Excel Desktop (Windows)

Parameters

symbolstringRequired
dataFieldstringRequired

close, high, low, volume

startDatedateRequired
endDatedateRequired

Returns

number

Lowest value of specified field between dates

Examples

=custom_dates_low("AAPL", DATE(2024,1,1), DATE(2024,3,31))
Q1 low close
=custom_dates_low("AAPL", DATE(2024,1,1), DATE(2024,3,31), "low")
Q1 lowest low
=custom_dates_low("MSFT", DATE(2024,6,1), DATE(2024,8,31))
Summer low
=custom_dates_low(A1, B1, C1, "close")
From cells

When to Use

  • Analyzing price troughs in custom periods
  • Quarterly or monthly low analysis
  • Event-based price studies
  • Custom date range support levels

When NOT to Use

Scenario Use Instead
Need 52-week low FiftyTwoWeekLow()
Need X-week low x_week_low()
Need high instead custom_dates_high()

Common Issues & FAQ

What if dates are reversed (end before start)?

The function may return incorrect results. Ensure start date is before end date.

What DataField options are available?

Use "close" (default), "high", "low", or "open".

Related Formulas

More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:

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 Between 2 Dates In History and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions