52 Week Range
Returns the 52-week (one year) trading range for a stock, displayed as a formatted string showing the lowest and highest prices reached during the past year.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Return Format
Returns a string in the format: "low_price - high_price"
Example: "124.17 - 199.62"
Syntax
=FiftyTwo__weekRange(Symbol)Returns
string
52-week price range in format 'low - high'
Examples
=FiftyTwo__weekRange("AAPL")=FiftyTwo__weekRange("MSFT")=FiftyTwo__weekRange("SPY")=FiftyTwo__weekRange(A1)When to Use
- Displaying complete price range in reports
- Quick overview of annual trading range
- Dashboard displays showing volatility context
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need just 52-week high | FiftyTwoWeekHigh() |
| Need just 52-week low | FiftyTwoWeekLow() |
| Need values for calculations | FiftyTwoWeekHigh() and FiftyTwoWeekLow() |
Common Issues & FAQ
Can I use this for calculations?
No, this returns a formatted string. Use FiftyTwoWeekHigh() and FiftyTwoWeekLow() for numeric values.
Why does it have double underscores in the name?
The function name uses double underscores for technical reasons. The behavior is the same as expected.
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
- 52-Week High
- 52-Week Low
- Add Symbols
- Average Price Between 2 Dates In History
- Bid Size
- Change From 52-Week High
- Change From 52-Week Low
- Change Month To Date
See FiftyTwo__weekRange used in a complete workbook: Fed Pause Sector Rotation Model Excel: Build a Q2 2026 Sector Dashboard in MarketXLS
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?