2,236 answered market questions

WITH entry AS (
    SELECT avgIf(option_close, ticker = 'O:SPY260618C00720000') AS call0,
           avgIf(option_close, ticker = 'O:SPY260618P00720000') AS put0,
           avg(underlying_close) AS spy0
    FROM global_markets.options_greeks
    WHERE ticker IN ('O:SPY260618C00720000', 'O:SPY260618P00720000')
      AND date = '2026-05-01'
      AND implied_volatility > 0.02
)
SELECT g.date AS date,
       round(avg(g.underlying_close) - any(entry.spy0) + any(entry.call0)
             - avgIf(g.option_close, g.ticker = 'O:SPY260618C00720000'), 2) AS covered_call_pl,
       round(any(entry.put0)
             - avgIf(g.option_close, g.ticker = 'O:SPY260618P00720000'), 2) AS cash_secured_put_pl
FROM global_markets.options_greeks g, entry
WHERE g.ticker IN ('O:SPY260618C00720000', 'O:SPY260618P00720000')
  AND g.date BETWEEN '2026-05-01' AND '2026-06-15'
  AND g.implied_volatility > 0.02
GROUP BY g.date
HAVING countIf(g.ticker = 'O:SPY260618C00720000') > 0
   AND countIf(g.ticker = 'O:SPY260618P00720000') > 0
ORDER BY g.date