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 priceslow- Daily low pricesopen- Opening prices
Syntax
=custom_dates_low(Symbol, StartDate, EndDate, [DataField])Examples
=custom_dates_low("AAPL", DATE(2024,1,1), DATE(2024,3,31))=custom_dates_low("AAPL", DATE(2024,1,1), DATE(2024,3,31), "low")=custom_dates_low("MSFT", DATE(2024,6,1), DATE(2024,8,31))=custom_dates_low(A1, B1, C1, "close")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".
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?