Volume vs Open Interest: Read Options Flow, Then Scan for Unusual Activity in Excel

Volume vs open interest in options: what each number tells you, the effect of high option volume, strategies using the most liquid options, and scanning for the most active options in Excel.

  1. 1
    Volume vs Open Interest: What You Need to Know to Trade Options

    Option volume counts contracts traded today; open interest counts contracts still open at the end of the day. What each tells you and how to use them together.

  2. 2
    Understanding Open Interest in Options Trading

    Open interest is the number of option contracts still open at the end of the day. How it differs from volume, what changes in it signal, and how to use it.

  3. 3
    Exploring the Impact of High Option Volumes

    High option volume usually means tighter bid/ask spreads and easier fills, and unusual volume can flag news or positioning. How to read and track it.

  4. 4
    5 Successful Options Strategies Using the Most Liquid Options

    Five option strategies (bull call spread, bear put spread, iron condor, long call butterfly, protective collar) and how to check option liquidity first.

  5. 5
    Get to Know the QQQQ Options

    QQQQ was the old ticker of the Nasdaq-100 ETF, now QQQ. How QQQ options work: calls, puts, pricing, Greeks, implied volatility and risk.

  6. 6
    How to Find the Most Active Options (MarketXLS Option Scanner)

    Find the most active options on your stock list in Excel with the MarketXLS Options Scanner (sort by contract volume) or =QM_GetOptionChainActive.

  7. 7
    Option Scanner

    Use the MarketXLS Option Scanner to pull option chains for up to 50 stocks, filter by volume, spread, IV, delta and expiry, and send the results to Excel.

  8. 8
    Gain a Trading Edge with an Option Scanner

    An option scanner filters option contracts across many stocks by expiry, volume, open interest, IV, and premium. What it screens for and how the MarketXLS Option Scanner works.

Put this to work in your spreadsheet