Today's Volume
Returns the total number of shares traded during the current trading day.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Indices | ^SYMBOL | ^SPX, ^VIX |
Notes
- Volume updates throughout the trading day
- Data is typically delayed 15 minutes
- Returns "NA" if data is unavailable
- For options, returns contract volume
Syntax
=Volume(Symbol)Returns
number
Number of shares traded today
Examples
When to Use
- Monitoring trading activity
- Identifying unusual volume
- Volume-based analysis and indicators
- Building market dashboards
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Average volume | AverageDailyVolume() |
| Historical volume | Volume_Historical() |
| Real-time streaming volume | QM_Stream_Volume() |
| Dollar volume | Calculate with price |
Common Issues & FAQ
Why is the volume so large?
Volume is reported in shares. For large-cap stocks, millions of shares trade daily.
How do I display volume in millions?
Use =Volume("AAPL")/1000000 to convert to millions.
How do I compare to average volume?
Use =Volume("AAPL")/AverageDailyVolume("AAPL") to get volume relative to average.
How do I format volume with commas?
Use Excel's number formatting or =TEXT(Volume("AAPL"),"#,##0").
Excel Templates Using Today's Volume
These ready-made MarketXLS templates call Volume() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Price Quotes 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?