Use Cases – Google Sheet-based Short Credit Spreads and Iron Condors Screener

Use Case #1: Use “Dashboard” tab to scan for Top 100 credit spreads

For example, if we want to see options contracts with the highest return, “Dashboard” provides this. For illustration, the following filters were used:

  • Put Credit Spread/Bull Put Spread
  • Sector: Technology
  • Strike Width / Wing < $10
  • Monthly only
  • Probability of Profit (POP) % > 50%
  • Avoid stocks with earnings in the next 30-day

Top 3 option contracts that fit the above criteria:

  1. NVDA 475/470p 10/20/2023 | Strike Width = 5 | Max ROC = 58.7% | Premium collected: $1.85
  2. U 36/35p 10/20/2023 | Strike Width = 1 | Max ROC = 56.3% | Premium collected: $0.36
  3. U 36/34p 10/20/2023 | Strike Width = 2 | Max ROC = 55% | Premium collected: $0.71

Use Case #2: Use “Dashboard” tab to filter for iron condor to sell with specific delta requirement

For illustration, the following filters were used:

  • Weekly (< 21 days)
  • Short legs (both put and call) less than 0.25

Top 3 option contracts that fit the above criteria:

  1. AI 28/27/36/37 | 10/20/2023 | Strike Width=1 | Premium collected: $0.38 | POP% = 62%
  2. AI 28/27/37/38 | 10/20/2023 | Strike Width=1 | Premium collected: $0.34 | POP% = 66%
  3. AI 28/25/36/39 | 10/20/2023 | Strike Width=3 | Premium collected: $0.97 | POP% = 67.7%

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

  • Use “PCS” tab to see ALL put credit spreads or bull put spreads
  • Use “CCS” tab to see ALL call credit spreads or bear call spreads
  • Use “IC” tab to see ALL iron condors

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 the tabs listed as well. These tabs contain a lot more filters than the “Dashboard” tab