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"
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
Q: Can I use this for calculations?
A: No, this returns a formatted string. Use FiftyTwoWeekHigh() and FiftyTwoWeekLow() for numeric values.
Q: Why does it have double underscores in the name? A: 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?