Options Change in Volume Leaders
Returns a list of options with the largest increase in trading volume compared to their average. Useful for identifying unusual activity and potential smart money movements.
Parameters
- numberOfRecords: How many results to return
- country: Market (e.g., "US")
- instrumentType: Filter by type
Notes
- Identifies unusual volume spikes
- May indicate pending news or institutional activity
- Updates end-of-day
- Returns tabular data
Syntax
=opt_OptionsChangeInVolumeLeaders(NumberOfRecords, Country, InstrumentType)Examples
=opt_OptionsChangeInVolumeLeaders(20, "US", "All")When to Use
Unusual options activity screening, smart money tracking, volume spike detection
When NOT to Use
| Need absolute volume | opt_OptionsVolumeLeaders() |
| Need volume/OI ratio | opt_UnusualStockOptionsActivity() |
Common Issues & FAQ
Why am I getting "NA"?
Check that:
- The symbol is valid
- You have proper data access
- Parameters are in correct format
Is this function Excel-only?
Some functions may not have API endpoints and only work in Excel.
Excel Templates Using Options Change in Volume Leaders
These ready-made MarketXLS templates call opt_OptionsChangeInVolumeLeaders() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Options 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?