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).
Syntax
=FiftyTwoWeekChange(Symbol)Examples
=FiftyTwoWeekChange("AAPL")=FiftyTwoWeekChange("MSFT")=FiftyTwoWeekChange("SPY")=FiftyTwoWeekChange(A1)*100When 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
Is the value a percentage or decimal?
It's a decimal. Multiply by 100 to display as a percentage.
How is this different from StockReturnOneYear?
They should provide similar values. FiftyTwoWeekChange uses key stats data while StockReturnOneYear calculates from price history.
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
- Gamma
- Get Data
- High Price Between 2 Dates In History
- Highest Price in X Minutes
- Initial Claims
- Kurtosis
- Last Trade Size
- Last Trade Time
See FiftyTwoWeekChange used in a complete workbook: Memory Chip Stocks Screener Excel: AI Memory & HBM Demand Dashboard (June 2026)
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?