Use Cases – Google Sheet-based Short Puts and Calls Screener

Use Case #1: Use “Dashboard” tab to quickly scan cash secured puts or naked puts option contracts with the highest ROC

You can utilize the “Dashboard” tab to screen for the Top 100 option contracts that match your filter criteria with the highest ROC. For illustration, the following filters were used:

  • Sector: Technology
  • Strike price greater than $50
  • Monthly only
  • Annual return of greater than 12%
  • Avoid stocks with earnings in the next 30-day

Top 3 option contracts that fit the above criteria:

  1. ENPH 120p 10/20/2023 | ROC=3.6% | Premium collected: $4.35
  2. NVDA 455p 10/20/2023 | ROC=3.1% | Premium collected: $14.20
  3. TTD 75p 10/20/2023 | ROC=2.9% | Premium collected: $2.16

Use Case #2: Use “Dashboard” tab to filter for option contracts include or exclude specific tickers and then sort by certain metric (eg ROC)

You can also utilize the “Dashboard” tab to quickly filter to include or exclude specific tickers and sort by specific metric such as highest ROC or highest % out-of-money. This is beneficial for someone who wants trade conservatively and still meet desired RoC. For illustration, the following filters were used:

  • Tickers included: AAPL, NVDA, GOOGL
  • Strike price greater than $50
  • Monthly only
  • Avoid stocks with earnings in the next 30-day

Top 3 option contracts that fit the above criteria:

  1. NVDA 420p 10/20/2023 | ROC=1.4% | Premium collected: $5.80 | %OTM = 13%
  2. NVDA 425p 10/20/2023 | ROC=1.6% | Premium collected: $6.65 | %OTM = 12%
  3. NVDA 430p 10/20/2023 | ROC=1.8% | Premium collected: $7.60 | %OTM = 11%

Use Case #3: Use “Dashboard” tab to filter for covered call or naked call option contracts for specific tickers and then sort by certain metric (eg %OTM)

You can utilize the “Dashboard” tab to quickly filter to include or exclude specific tickers and sort by specific metric such as highest % out-of-money. For illustration, the following filters were used:

  • Tickers included: AAPL, NVDA, GOOGL
  • Monthly only
  • Avoid stocks with earnings in the next 30-day

Top 3 option contracts that fit the above criteria:

  1. NVDA 575p 10/20/2023 | ROC=1.4% | Premium collected: $5.42 | %OTM = 19% | Delta = 0.15
  2. NVDA 570p 10/20/2023 | ROC=1.6% | Premium collected: $6.02 | %OTM = 18% | Delta = 0.17
  3. NVDA 565p 10/20/2023 | ROC=1.8% | Premium collected: $6.68 | %OTM = 16% | Delta = 0.18

Use Case #4: Raw option contracts are provided if “Dashboard” does not fulfill your need

  • Use “Sell_Put” tab to see ALL cash secured puts or naked puts
  • Use “Sell_Call” tab to see ALL covered calls or naked calls

For most of the time, “Dashboard” should get you what you need. However, if you need to see ALL option contracts, the data is provided in “Sell_Put” and “Sell_Call” tab as well. These tabs contain a lot more filters than the “Dashboard” tab

  • Tickers included: AAPL, ABBV, ABNB
  • Avoid stocks with earnings in the next 30-day