Options Change in OI Leaders
Identifies stocks with the largest percentage change in options open interest. This indicates where new positions are being opened or closed.
Parameters
| Parameter | Required | Description |
|---|---|---|
| NumberOfRecords | Yes | Number of results to return |
| Country | No | Country filter (default: US) |
| InstrumentType | No | All, Stock, or ETF (default: All) |
What This Measures
- Percentage change in open interest
- Identifies new position building
- Shows where commitment is increasing/decreasing
OI vs Volume
| Metric | Meaning |
|---|---|
| High Volume + OI Increase | New positions being opened |
| High Volume + OI Decrease | Positions being closed |
| OI Change | Net new commitment to the market |
Notes
- OI updates overnight, not intraday
- Increasing OI = new money entering market
- Decreasing OI = positions being closed
Examples
Top 10 OI change leaders
=opt_OptionsChangeInOILeaders(5, "US", "Stock")=opt_OptionsChangeInOILeaders(5, "US", "ETF")Top 20 results
When to Use
- Find where new positions are being built
- Identify commitment to specific strikes/expirations
- Screen for building momentum
- Monitor institutional positioning
- Track options market conviction
When NOT to Use
Common Issues & FAQ
Q: How is this different from volume change? A: Volume is trading activity. OI change shows net new positions. High volume with no OI change means positions are just changing hands.
Q: When does OI update? A: Open interest updates overnight and reflects the previous day's close.
Q: What does large OI increase indicate? A: Large OI increases suggest new money and conviction entering the market at those strikes.
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?