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)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.
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?