MarketXLS

Change From 52-Week Low

Calculates the absolute dollar change between current price and 52-week low.

Syntax

=ChangeFrom52_weekLow(Symbol)
Excel Desktop (Windows)

Returns

number

Dollar change from 52-week low

Examples

=ChangeFrom52_weekLow("AAPL")
=ChangeFrom52_weekLow(A1)

When to Use

  • Measuring price recovery
  • Support distance analysis

When NOT to Use

  • Percentage-based analysis

Excel Templates Using Change From 52-Week Low

These ready-made MarketXLS templates call ChangeFrom52_weekLow() 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:

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Change From 52-Week Low and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions