Fifty Two Week High
Returns the highest 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 high for resistance levels
- Stocks near 52-week highs may indicate strength
- Used in calculating distance from high for screening
Syntax
=FiftyTwoWeekHigh(Symbol)Examples
=FiftyTwoWeekHigh("AAPL")=FiftyTwoWeekHigh("MSFT")=Last("AAPL")/FiftyTwoWeekHigh("AAPL")=FiftyTwoWeekHigh(A1)When to Use
- Finding resistance levels
- Calculating distance from 52-week high
- Screening for stocks near annual highs
- Building price range analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need 52-week low | FiftyTwoWeekLow() |
| Need both high and low | FiftyTwo__weekRange() |
| Need custom period | x_week_high() |
Common Issues & FAQ
How recent is the 52-week high 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 High
These ready-made MarketXLS templates call FiftyTwoWeekHigh() 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?