Options Volume Leaders
Returns a list of options with the highest absolute trading volume. Shows the most actively traded options contracts.
Notes
- Shows most liquid options
- High volume = more liquidity
- Updates end-of-day
- Returns tabular data
Syntax
=opt_OptionsVolumeLeaders(NumberOfRecords, Country, InstrumentType)Examples
=opt_OptionsVolumeLeaders(20, "US", "All")When to Use
Finding liquid options, identifying most active contracts
When NOT to Use
| Need volume change | opt_OptionsChangeInVolumeLeaders() |
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 Volume Leaders
These ready-made MarketXLS templates call opt_OptionsVolumeLeaders() 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:
- Put Interest (Specific Expiry)
- QM Get Option Chain Active Dynamic
- QM Get Option Chain At The Money Dynamic
- QM Get Option Chain Dynamic
- QM Get Option Chain In The Money Dynamic
- QM Get Option Chain Monthlies Dynamic
- QM Get Option Chain Near Term Dynamic
- QM Get Option Chain Out Of The Money Dynamic
See opt_OptionsVolumeLeaders used in a complete workbook: MCP Options Order Flow Server: Read Options Flow in Claude and Excel (2026)
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?