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)Parameters
SymbolstringRequired
Stock or ETF ticker symbol
YearintegerRequired
The year (e.g., 2025)
QuarterintegerRequired
Quarter number: 1-4
Returns
number
Trading volume on the last trading day of the specified 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.
Related Formulas
More MarketXLS Price History formulas you can use in the same worksheet:
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?