Low Price (Quarter End)
Returns the intraday low price for a stock or ETF on the last trading day of the specified quarter. This is the daily low on that single day, not the quarter's overall low.
Validation
- Quarter must be 1-4
Syntax
=Low_QuarterEnd(Symbol, Year, Quarter)Examples
=Low_QuarterEnd("AAPL", 2025, 4)=Low_QuarterEnd("MSFT", 2024, 1)Daily range:
=High_QuarterEnd("AAPL",2025,4)-Low_QuarterEnd("AAPL",2025,4)When to Use
- Quarter-end intraday volatility analysis
- Calculating daily range on quarter-end days
- Complete OHLCV at quarter-end
When NOT to Use
\
Common Issues & FAQ
This isn't the quarter's lowest price?
Correct — it's the daily low on the quarter's last trading day only.
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?