52-Week Low
Returns the lowest trading price over the past 52 weeks (1 year).
Syntax
=FiftyTwo_weekLow(Symbol)Returns
number
52-week low price
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.
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
- Add Symbols
- Average Price Between 2 Dates In History
- Bid Size
- Change From 52-Week High
- Change Month To Date
- Change Month To Date In Percent
- Change Quarter To Date
- Change Quarter To Date In Percent
See FiftyTwo_weekLow used in a complete workbook: Google Sheets Stock Price: How to Get Real-Time Stock Quotes Beyond GOOGLEFINANCE
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?