52-Week Low
Returns the lowest trading price over the past 52 weeks (1 year).
Syntax
=FiftyTwo_weekLow(Symbol)Examples
=FiftyTwo_weekLow("AAPL")=FiftyTwo_weekLow(A1)When to Use
- Support level analysis
- Value investing screens
- Technical analysis
When NOT to Use
- Intraday low analysis
Excel Templates Using 52-Week Low
These ready-made MarketXLS templates call FiftyTwo_weekLow() 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?