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
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
Q: What if the market was closed on that date? A: Returns NA or an error if no trading occurred on that date.
Q: What date format should I use? A: Use Excel DATE function like DATE(2024,1,15) for best compatibility.
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?