Percent Change From 52-Week High
Calculates the percentage change between current price and 52-week high. Usually negative.
Syntax
=PercentChangeFrom52_weekHigh(Symbol)Returns
number
Percent change from 52-week high
Examples
=PercentChangeFrom52_weekHigh("AAPL")When to Use
- Relative pullback analysis
- Screening for stocks near highs
When NOT to Use
- Absolute dollar change needed
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
- Percent Change From 52-Week Low
- Pitrioski FScore
- Price At Minute
- Price At Minute
- Price Change From Minute
- Price Change From Minute
- Price Change Percent From Minute
- Price Change Percent X Minutes Ago
See PercentChangeFrom52_weekHigh used in a complete workbook: Portfolio Stress Test Excel: Complete Market Downturn Analysis Framework for 2026
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?