Historical Volume On A Day In Past
Returns the trading volume (number of shares traded) for a stock on a specific historical date.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Parameters
| Parameter | Description | Example |
|---|---|---|
| Symbol | Stock ticker | AAPL |
| OnDate | Date to retrieve volume | DATE(2024,1,15) |
Date Format
Use Excel DATE function: DATE(2024,1,15) for January 15, 2024
Syntax
=Volume_Historical(Symbol, OnDate)Examples
=Volume_Historical("AAPL", DATE(2024,1,15))=Volume_Historical("MSFT", DATE(2024,6,1))=Volume_Historical("SPY", A1)=Volume_Historical(B1, C1)When to Use
- Analyzing trading activity on specific dates
- Studying volume patterns around events
- Comparing historical volume levels
- Building volume-based studies
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current volume | Volume() |
| Need average volume | AverageDailyVolume() |
| Need historical price | Close_Historical() |
Common Issues & FAQ
What if the market was closed on that date?
Returns NA or an error if no trading occurred on that date.
What date format should I use?
Use Excel DATE function like DATE(2024,1,15) for best compatibility.
Excel Templates Using Historical Volume On A Day In Past
These ready-made MarketXLS templates call Volume_Historical() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Price History formulas you can use in the same worksheet:
- Intraday History 1 Hour Intervals
- Intraday History 1 Hour Intervals (Dynamic)
- Intraday History 1 Minute Intervals
- Intraday History 1 Minute Intervals (Dynamic)
- Intraday History 15 Minute Intervals
- Intraday History 15 Minute Intervals (Dynamic)
- Intraday History 4 Hour Intervals
- Intraday History 4 Hour Intervals (Dynamic)
See Volume_Historical used in a complete workbook: Excel Stock Price on a Specific Date: How to Get Historical Prices With Formulas
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?