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

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

Q: Are these trading days or calendar days? A: These are typically trading days (business days when market is open).

Q: Does this include today? A: Yes, the current day's low is typically included if market has traded.

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 In X Number Of Days and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions