MarketXLS

Low Price In X Number Of Weeks

Returns the lowest trading price over a custom number of weeks for a stock. This allows flexible 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
Weeks Number of weeks to look back 4, 12, 26

Syntax

=x_week_low(Symbol, Weeks)
Excel Desktop (Windows)

Parameters

symbolstringRequired
weeksnumberRequired

Returns

number

Lowest price in specified number of weeks

Examples

=x_week_low("AAPL", 4)
4-week low for Apple
=x_week_low("MSFT", 12)
12-week low for Microsoft
=x_week_low("SPY", 26)
26-week (6 month) low for SPY
=x_week_low(A1, B1)
Symbol and weeks from cells

When to Use

  • Custom period support analysis
  • Flexible support level identification
  • Building custom technical indicators
  • Non-standard lookback periods

When NOT to Use

Scenario Use Instead
Need 52-week low FiftyTwoWeekLow()
Need days, not weeks x_day_low()
Need high instead x_week_high()

Common Issues & FAQ

What is the maximum weeks allowed?

There is no strict limit, but very long periods may have reduced data availability.

Does this include the current week?

Yes, the current incomplete week is typically included.

Related Formulas

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

Related Functions