除息日如何影响期权？看涨期权何时提前行权

SELECT
    toString(ex_dividend_date) AS ex_date,
    round(cash_amount, 3) AS dividend_usd
FROM global_markets.stocks_dividends
WHERE ticker = 'SPY'
  AND ex_dividend_date BETWEEN '2025-01-01' AND '2026-06-30'
ORDER BY ex_dividend_date

SELECT date,
    round(anyIf(delta, position(ticker, 'C00740') > 0), 3) AS call_delta,
    round(anyIf(delta, position(ticker, 'P00740') > 0), 3) AS put_delta
FROM global_markets.options_greeks
WHERE ticker IN ('O:SPY260717C00740000', 'O:SPY260717P00740000')
  AND date BETWEEN '2026-06-11' AND '2026-06-24'
  AND implied_volatility > 0.02
GROUP BY date
ORDER BY date

SELECT
    multiIf(dte <= 9, '3 to 9 days', dte <= 16, '10 to 16 days', '17 to 45 days') AS days_to_expiry,
    count() AS contracts,
    round(median(time_value), 2) AS median_time_value,
    round(100.0 * countIf(time_value < 1.904) / count(), 0) AS pct_below_dividend
FROM (
    SELECT option_close - greatest(underlying_close - strike_price, 0) AS time_value,
           (expiration_date - toDate('2026-06-17')) AS dte
    FROM global_markets.options_greeks
    WHERE date = '2026-06-17'
      AND option_type = 'C'
      AND underlying_symbol = 'SPY'
      AND underlying_close - strike_price >= 25
      AND expiration_date > toDate('2026-06-17')
      AND expiration_date <= toDate('2026-08-01')
      AND implied_volatility > 0.02
)
GROUP BY days_to_expiry
ORDER BY min(dte)

WITH divs AS (
    SELECT ticker, max(cash_amount) AS dividend
    FROM global_markets.stocks_dividends
    WHERE ex_dividend_date = toDate('2026-06-30') AND cash_amount > 0
    GROUP BY ticker
)
SELECT count(DISTINCT g.underlying_symbol) AS underlyings_measured,
       count() AS itm_calls_measured,
       countIf(g.option_close - (g.underlying_close - g.strike_price) < d.dividend) AS exercise_optimal,
       round(100.0 * countIf(g.option_close - (g.underlying_close - g.strike_price) < d.dividend) / count(), 1) AS pct_optimal
FROM global_markets.options_greeks g
INNER JOIN divs d ON g.underlying_symbol = d.ticker
WHERE g.date = toDate('2026-06-29')
  AND g.option_type = 'C'
  AND g.underlying_close - g.strike_price > 0
  AND g.expiration_date > toDate('2026-06-30')
  AND g.implied_volatility > 0.02 AND g.iv_converged

WITH divs AS (
    SELECT ticker, max(cash_amount) AS dividend
    FROM global_markets.stocks_dividends
    WHERE ex_dividend_date = toDate('2026-06-30') AND cash_amount > 0
    GROUP BY ticker
)
SELECT g.underlying_symbol AS ticker,
       round(any(d.dividend), 2) AS dividend,
       count() AS itm_calls,
       countIf(g.option_close - (g.underlying_close - g.strike_price) < d.dividend) AS exercise_optimal
FROM global_markets.options_greeks g
INNER JOIN divs d ON g.underlying_symbol = d.ticker
WHERE g.date = toDate('2026-06-29') AND g.option_type = 'C'
  AND g.underlying_close - g.strike_price > 0
  AND g.expiration_date > toDate('2026-06-30')
  AND g.implied_volatility > 0.02 AND g.iv_converged
GROUP BY g.underlying_symbol
HAVING exercise_optimal > 0
ORDER BY exercise_optimal DESC
LIMIT 10