Change From 52-Week High
Calculates the absolute dollar change between current price and 52-week high. Usually negative.
Syntax
=ChangeFrom52_weekHigh(Symbol)Returns
number
Dollar change from 52-week high
Examples
=ChangeFrom52_weekHigh("AAPL")When to Use
- Measuring price pullback
- Resistance distance analysis
When NOT to Use
- Percentage-based analysis
Excel Templates Using Change From 52-Week High
These ready-made MarketXLS templates call ChangeFrom52_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:
- 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
- Change Week To Date
- Change Week To Date In Percent
- Change Year To Date
See ChangeFrom52_weekHigh used in a complete workbook: Airline Earnings Tracker Excel: Q2 2026 Summer Travel Demand Watchlist
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?