52-Week High
Returns the highest trading price over the past 52 weeks (1 year).
Syntax
=FiftyTwo_weekHigh(Symbol)Examples
=FiftyTwo_weekHigh("AAPL")=FiftyTwo_weekHigh(A1)When to Use
- Resistance level analysis
- Momentum screening
- Technical analysis
When NOT to Use
- Intraday high analysis
Excel Templates Using 52-Week High
These ready-made MarketXLS templates call FiftyTwo_weekHigh() 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?