Fifty Two Week Low
Returns the lowest trading price over the past 52 weeks (one year) for a stock.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Technical Analysis Use
- Compare current price to 52-week low for support levels
- Stocks near 52-week lows may indicate weakness or value
- Used in calculating distance from low for screening
Syntax
=FiftyTwoWeekLow(Symbol)Returns
number
52-week low price
Examples
=FiftyTwoWeekLow("AAPL")=FiftyTwoWeekLow("MSFT")=Last("AAPL")/FiftyTwoWeekLow("AAPL")=FiftyTwoWeekLow(A1)When to Use
- Finding support levels
- Calculating distance from 52-week low
- Screening for stocks near annual lows
- Value investing analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need 52-week high | FiftyTwoWeekHigh() |
| Need both high and low | FiftyTwo__weekRange() |
| Need custom period | x_week_low() |
Common Issues & FAQ
How recent is the 52-week low data?
The data is typically updated daily with end-of-day prices.
Does this include after-hours trading?
Generally, this reflects regular trading hours only.
Excel Templates Using Fifty Two Week Low
These ready-made MarketXLS templates call FiftyTwoWeekLow() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
- Gamma
- Get Data
- High Price Between 2 Dates In History
- Highest Price in X Minutes
- Initial Claims
- Kurtosis
- Last Trade Size
- Last Trade Time
See FiftyTwoWeekLow used in a complete workbook: Excel Stock Tracker: Build a Professional Portfolio Dashboard in Your Spreadsheet
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?