Fifty Two Week Change

Returns the percentage price change over the past 52 weeks (one year) for a stock. This is useful for measuring annual performance.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ

Return Value

Returns a decimal representing the percent change (e.g., 0.25 = 25% gain, -0.10 = 10% loss).

Examples

=FiftyTwoWeekChange("AAPL")
Apple's 52-week change
=FiftyTwoWeekChange("MSFT")
Microsoft's 52-week change
=FiftyTwoWeekChange("SPY")
S&P 500 ETF 52-week change
=FiftyTwoWeekChange(A1)*100
Convert to percentage display

When to Use

  • Measuring annual stock performance
  • Comparing year-over-year returns
  • Building performance dashboards
  • Screening for stocks with strong/weak annual performance

When NOT to Use

Scenario Use Instead
YTD performance ChangePercentYTD()
3-month return StockReturnThreeMonths()
6-month return StockReturnSixMonths()

Common Issues & FAQ

Q: Is the value a percentage or decimal? A: It's a decimal. Multiply by 100 to display as a percentage.

Q: How is this different from StockReturnOneYear? A: They should provide similar values. FiftyTwoWeekChange uses key stats data while StockReturnOneYear calculates from price history.

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 Fifty Two Week Change and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions