STRASMORE/EXPLORE 2,173 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,173 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Covered Calls: Income on Your Shares
The same covered call at entry, the SPY peak, the dip, and the final sessiontable · 2026-07-16 · 4×5 Buy-and-hold SPY vs the covered call, per-share value over 7 weeksseries · 2026-07-16 · 31×3Preview: a 16-point series, ending higher. The $740 call you sold, daily value over its 7-week lifeseries · 2026-07-16 · 31×2Preview: a 16-point series, ending higher.
Buying and Selling Call Options
One SPY $740 call, daily close over its 7-week lifeseries · 2026-07-16 · 31×2Preview: a 16-point series, ending higher. The same call at four exits: price, multiple of premium, and P&L per contracttable · 2026-07-16 · 4×5 SPY vs the call, both indexed to 100 on May 1series · 2026-07-16 · 31×3Preview: a 16-point series, ending higher.
The same covered call at entry, the SPY peak, the dip, and the final session

The same covered call at entry, the SPY peak, the dip, and the final session

most recentas of table 4×5read in context →
The same covered call at entry, the SPY peak, the dip, and the final session — 4 rows by 5 columns, computed from US exchange, SIP and OPRA data.
stagespy_pricecall_valuemoneynesscovered_value
1. Sold the call (May 1)7207.22below 740 strike720
2. SPY peak (Jun 2)759.6323.5above 740 strike743.35
3. SPY dip (Jun 10)722.883.17below 740 strike726.93
4. Final session (Jun 15)753.9115.41above 740 strike745.72
the exact SQL behind every number 
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 multiIf(g.date = '2026-05-01', '1. Sold the call (May 1)',
               g.date = '2026-06-02', '2. SPY peak (Jun 2)',
               g.date = '2026-06-10', '3. SPY dip (Jun 10)', '4. Final session (Jun 15)') AS stage,
       round(avg(g.underlying_close), 2) AS spy_price,
       round(avg(g.option_close), 2) AS call_value,
       if(avg(g.underlying_close) > 740, 'above 740 strike', 'below 740 strike') AS moneyness,
       round(avg(g.underlying_close) + any(prem.p) - avg(g.option_close), 2) AS covered_value
FROM global_markets.options_greeks g, prem
WHERE g.ticker = 'O:SPY260618C00740000'
  AND g.date IN ('2026-05-01', '2026-06-02', '2026-06-10', '2026-06-15')
  AND g.implied_volatility > 0.02
GROUP BY g.date ORDER BY g.date
More from this analysisCovered Calls: Income on Your Shares
Buy-and-hold SPY vs the covered call, per-share value over 7 weeks series 31×3 → The $740 call you sold, daily value over its 7-week life series 31×2 → Three years of total return, split into price change and distributions: July 2023 to June 2026 table 8×7 → Both positions at four moments: entry, three weeks in, the SPY high, and the June dip table 4×5 → See all 2,173 queries →
$