Volume Average Custom Dates
Calculates the average trading volume between two specific dates.
Syntax
=VolumeAverageCustomDates(Symbol, StartDate, EndDate)Parameters
symbolstringRequired
startDatedateRequired
endDatedateRequired
Returns
number
Average trading volume between two dates
Examples
=VolumeAverageCustomDates("AAPL", DATE(2022,1,1), DATE(2023,1,1))=VolumeAverageCustomDates("AAPL", A1, B1)When to Use
- Custom period volume analysis
- Event-specific volume analysis
When NOT to Use
- Standard period analysis (use predefined periods)
Common Issues & FAQ
- Start date must be before end date
Related Formulas
More MarketXLS Technical Indicators 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?