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)Examples
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.
Excel Templates Using Low Price In X Number Of Days
These ready-made MarketXLS templates call x_day_low() in their worksheet formulas. Open one to see the function working inside a complete model.
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?