Current Day's Low
Returns the lowest 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 lows are reached
- Data is typically delayed 15 minutes
- Returns "NA" if data is unavailable
Syntax
=DaysLow(Symbol)Examples
When to Use
- Monitoring intraday price range
- Setting stop-loss levels
- Calculating daily trading range
- Building intraday dashboards
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Historical daily low | Low_Historical() |
| 52-week low | FiftyTwoWeekLow() |
| Real-time streaming low | QM_Stream_Low() |
| Multi-day low | Custom calculation |
Common Issues & FAQ
Why is the low higher than the current price?
This shouldn't happen with current data. The current price may have updated while the low hasn't refreshed yet.
How do I calculate today's range?
Use =DaysHigh("AAPL")-DaysLow("AAPL") for the day's trading range.
How do I get historical daily lows?
Use Low_Historical() with a specific date parameter.
Excel Templates Using Current Day's Low
These ready-made MarketXLS templates call DaysLow() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Price Quotes formulas you can use in the same worksheet:
- Expiry Date (On Demand)
- Get a Value from QuoteMedia
- High Price (On Demand)
- Last Price (On Demand)
- Last Trade Date
- Last Trade DateTime (On Demand)
- Low Price (On Demand)
- Open Interest (On Demand)
See DaysLow used in a complete workbook: Bloomberg Alternative: The Best Excel-Native Financial Data Platform in 2026
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?