Total Volume (Options)
Returns the total options trading volume for an underlying stock. Can be filtered by option type (calls/puts), expiration date, and strike price.
Parameters
| Parameter | Required | Default | Description |
|---|---|---|---|
| Underlying | Yes | - | Stock ticker symbol |
| OptionType | No | all | 'all', 'call', or 'put' |
| ExpirationDate | No | all | Specific date or 'all' |
| Strike | No | all | Specific strike or blank |
Understanding Options Volume
- Volume = contracts traded today
- High volume indicates active trading interest
- Compare call vs put volume for sentiment
- Use with open interest for complete picture
Notes
- Returns today's cumulative volume
- Data is typically 15-20 minutes delayed
- Combine filters to narrow focus
Examples
=opt_TotalVolumeOptions("AAPL")=opt_TotalVolumeOptions("AAPL", "call")=opt_TotalVolumeOptions("AAPL", "put")=opt_TotalVolumeOptions("SPY", "all", "2024-01-19")=opt_TotalVolumeOptions("TSLA", "call", "all", 250)=opt_TotalVolumeOptions(A1, B1, C1, D1)When to Use
- Measuring options market activity
- Comparing call vs put activity
- Identifying unusual options volume
- Analyzing volume by expiration
- Options flow analysis
When NOT to Use
Common Issues & FAQ
Q: Why is volume so different from open interest? A: Volume = contracts traded today. Open interest = total outstanding. Volume resets daily; OI accumulates.
Q: How do I get put/call ratio from volume?
A: Divide put volume by call volume, or use opt_PutCallVolRatio() directly.
Q: Is the data real-time? A: Options volume data is typically delayed 15-20 minutes during market hours.
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?