Current Day's High
Returns the highest price at which the security has traded during the current trading day.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Indices | ^SYMBOL | ^SPX, ^VIX |
Notes
- Updates throughout the trading day as new highs are reached
- Data is typically delayed 15 minutes
- Returns "NA" if data is unavailable
Examples
When to Use
- Monitoring intraday price range
- Setting profit targets
- Calculating daily trading range
- Building intraday dashboards
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Historical daily high | High_Historical() |
| 52-week high | FiftyTwoWeekHigh() |
| Real-time streaming high | QM_Stream_High() |
| Multi-day high | Custom calculation |
Common Issues & FAQ
Q: Why is the high lower than the current price? A: This shouldn't happen with current data. The current price may have updated while the high hasn't refreshed yet.
Q: How do I calculate today's range?
A: Use =DaysHigh("AAPL")-DaysLow("AAPL") for the day's trading range.
Q: How do I get historical daily highs?
A: Use High_Historical() with a specific date parameter.
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?