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 |
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
Q: What is the maximum weeks allowed? A: There is no strict limit, but very long periods may have reduced data availability.
Q: Does this include the current week? A: Yes, the current incomplete week is typically included.
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?