Change From 52-Week High
Calculates the absolute dollar change between current price and 52-week high. Usually negative.
Syntax
=ChangeFrom52_weekHigh(Symbol)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.
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?