High Price In X Number Of Days
Returns the highest trading price over a custom number of trading days for a stock. This allows precise daily 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 |
| Days | Number of trading days to look back | 20, 60, 90 |
Examples
=x_day_high("AAPL", 20)=x_day_high("MSFT", 60)=x_day_high("SPY", 90)=x_day_high(A1, B1)When to Use
- Short-term breakout analysis
- Day-based resistance levels
- Custom technical indicators
- Donchian channel calculations
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need weeks, not days | x_week_high() |
| Need low instead | x_day_low() |
| Need specific dates | custom_dates_high() |
Common Issues & FAQ
Q: Are these trading days or calendar days? A: These are typically trading days (business days when market is open).
Q: Does this include today? A: Yes, the current day's high is typically included if market has traded.
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?