Buy-and-hold SPY vs the covered call, per-share value over 7 weeks

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-07-16, from Covered Calls: Income on Your Shares.

Rows × columns

31 × 3

Period covered

2026-05-01 to 2026-06-15

Computed

2026-07-16

Completeness

No missing values

Source

US exchange, SIP and OPRA market data

Licence

Strasmore terms · free, no signup

Formats

JSON · CSV · the SQL below

What each column holds

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on 2026-07-16, and the query below is what returned them.

WITH prem AS (
  SELECT avg(option_close) AS p
  FROM global_markets.options_greeks
  WHERE ticker = 'O:SPY260618C00740000' AND date = '2026-05-01' AND implied_volatility > 0.02
)
SELECT g.date,
       round(avg(g.underlying_close), 2) AS buy_hold,
       round(avg(g.underlying_close) + any(prem.p) - avg(g.option_close), 2) AS covered_call
FROM global_markets.options_greeks g, prem
WHERE g.ticker = 'O:SPY260618C00740000' AND g.date BETWEEN '2026-05-01' AND '2026-06-17' AND g.implied_volatility > 0.02
GROUP BY g.date ORDER BY g.date