High Price In X Number Of Weeks
Returns the highest trading price over a custom number of weeks for a stock. This allows flexible lookback periods for technical analysis.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Parameters
| Parameter | Description | Example |
|---|---|---|
| Symbol | Stock ticker | AAPL |
| Weeks | Number of weeks to look back | 4, 12, 26 |
Syntax
=x_week_high(Symbol, Weeks)Parameters
symbolstringRequired
weeksnumberRequired
Returns
number
Highest price in specified number of weeks
Examples
=x_week_high("AAPL", 4)=x_week_high("MSFT", 12)=x_week_high("SPY", 26)=x_week_high(A1, B1)When to Use
- Custom period breakout analysis
- Flexible resistance level identification
- Building custom technical indicators
- Non-standard lookback periods
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need 52-week high | FiftyTwoWeekHigh() |
| Need days, not weeks | x_day_high() |
| Need low instead | x_week_low() |
Common Issues & FAQ
What is the maximum weeks allowed?
There is no strict limit, but very long periods may have reduced data availability.
Does this include the current week?
Yes, the current incomplete week is typically included.
Related Formulas
More MarketXLS Price History formulas you can use in the same worksheet:
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?