MarketXLS

Low Price In X Number Of Days

Returns the lowest trading price over a custom number of trading days for a stock. This allows precise daily lookback periods for support analysis.

Supported Symbol Formats

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

Parameters

Parameter Description Example
Symbol Stock ticker AAPL
Days Number of trading days to look back 20, 60, 90

Syntax

=x_day_low(Symbol, Days)
Excel Desktop (Windows)

Parameters

symbolstringRequired
daysnumberRequired

Returns

number

Lowest price in specified number of days

Examples

=x_day_low("AAPL", 20)
20-day low for Apple
=x_day_low("MSFT", 60)
60-day low for Microsoft
=x_day_low("SPY", 90)
90-day low for SPY
=x_day_low(A1, B1)
Symbol and days from cells

When to Use

  • Short-term support analysis
  • Day-based support levels
  • Custom technical indicators
  • Donchian channel calculations

When NOT to Use

Scenario Use Instead
Need weeks, not days x_week_low()
Need high instead x_day_high()
Need specific dates custom_dates_low()

Common Issues & FAQ

Are these trading days or calendar days?

These are typically trading days (business days when market is open).

Does this include today?

Yes, the current day's low is typically included if market has traded.

Related Formulas

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

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
MarketXLS Excel Add-in Tutorial - How to Use Low Price In X Number Of Days and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions