Percent Change From 52-Week Low

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

Syntax

=PercentChangeFrom52_weekLow(Symbol)
Excel Desktop (Windows)

Returns

number

Percent change from 52-week low

Examples

=PercentChangeFrom52_weekLow("AAPL")
=PercentChangeFrom52_weekLow(A1)

When to Use

  • Relative performance analysis
  • Price recovery measurement

When NOT to Use

  • Absolute dollar change needed

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
MarketXLS Excel Add-in Tutorial - How to Use Percent Change From 52-Week Low and Other Financial Formulas
▶
How does MarketXLS work?