MarketXLS
← Back to Templates

Unusual Options Activity Scanner

Created by MarketXLSLast updated: 2026-10-19

Description

Unusual Options Activity Scanner thumbnail

Uncover the potency of cutting-edge options trading analytics with MarketXLS in this enlightening video. Take a deep dive into innovative, user-influenced features tailored to decipher vital trading metrics and propel better, data-backed trading decisions. Glean the market for unconventional options, volume, and open interest. Delve into unique option opportunities and scan utilizing the underlying ticker of your preference.

Template Screenshots

Unusual Options Activity Scanner screenshot 1

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
How does MarketXLS work?
▶
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found

Excel Functions Used in This Template

ƒ(x)
Total Volume (Options)=opt_TotalVolumeOptions()
ƒ(x)
Next Expiry Date=ExpirationNext()
ƒ(x)
Volume Ratio=opt_PutCallVolRatio()
ƒ(x)
OI Ratio (Options)=opt_PutCallOIRatio()
ƒ(x)
Average Volume (Options)=opt_VolumeOptionsAverage()
ƒ(x)
Total Open Interest=opt_TotalOpenInterestOptions()
ƒ(x)
Next Strike Price=StrikeNext()
ƒ(x)
OI Ratio (Specific Expiry) (Options)=opt_PutCallOIRatioHistorical()