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.
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 Low
- Change Month To Date
- Change Month To Date In Percent
- Change Quarter To Date
- Change Quarter To Date In Percent
See FiftyTwo_weekHigh 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?