Volume (Quarter End)
Returns the trading volume for a stock or ETF on the last trading day of the specified quarter. Quarter-end days often see elevated volume due to portfolio rebalancing and window dressing.
Validation
- Quarter must be 1-4
Syntax
=Volume_QuarterEnd(Symbol, Year, Quarter)Examples
=Volume_QuarterEnd("AAPL", 2025, 4)=Volume_QuarterEnd("SPY", 2024, 1)=Volume_QuarterEnd(A1, B1, C1)When to Use
- Analyzing quarter-end rebalancing activity
- Comparing volume patterns across quarter-ends
- Liquidity analysis on specific dates
When NOT to Use
\
Common Issues & FAQ
Volume seems unusually high on quarter-end dates.?
This is normal — institutional investors often rebalance portfolios at quarter-end, leading to higher-than-average volume.
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?