Average Daily Volume
Returns the average daily trading volume, typically calculated over the past 365 days. This is a key measure of a stock's liquidity.
Uses of Average Daily Volume
| Use Case | Application |
|---|---|
| Liquidity assessment | Higher ADV = easier to trade large positions |
| Position sizing | Limit orders to small percentage of ADV |
| Volume analysis | Compare current volume to ADV |
| Stock screening | Filter for liquid stocks |
Volume Ratios
| Ratio | Meaning |
|---|---|
| Current Vol / ADV > 2 | Unusually high volume |
| Current Vol / ADV < 0.5 | Unusually low volume |
| Current Vol / ADV ~ 1 | Normal volume |
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
Examples
=AverageDailyVolume("AAPL")=AverageDailyVolume("MSFT")=AverageDailyVolume("SPY")=AverageDailyVolume("TSLA")=AverageDailyVolume(A1)When to Use
- Assess stock liquidity before trading
- Set position size limits
- Compare today's volume to normal levels
- Screen for liquid stocks
- Calculate volume ratios
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current day's volume | Volume() function |
| Need volume-weighted momentum | MoneyFlowIndex() |
| Need volume over specific period | Historical data functions |
| Need volume moving average | Custom calculation |
Common Issues & FAQ
Q: Why is Average Daily Volume returning "NA"? A: Check that:
- The symbol is valid and actively traded
- The stock has sufficient trading history (at least 1 year)
- Volume data is available for the symbol
Q: What time period is used? A: Average Daily Volume typically uses the past 365 days of trading data.
Q: How do I compare current volume to average? A: Divide today's volume by ADV:
- Volume / ADV > 1.5 = above average
- Volume / ADV < 0.5 = below average
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?