forward_yield

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH
(
    SELECT max(toFloat64(cash_amount)) * 4
    FROM global_markets.stocks_dividends
    WHERE ticker = 'IBM'
      AND ex_dividend_date BETWEEN today() - 120 AND today()
) AS annual_dividend
SELECT
    toString(max(date))                                              AS session_date,
    formatDateTime(max(date), '%d.%m.%Y')                            AS session_label,
    round(argMax(toFloat64(close), date), 2)                         AS close_usd,
    round(annual_dividend, 2)                                        AS annual_dividend_usd,
    round(annual_dividend / argMax(toFloat64(close), date) * 100, 2) AS forward_yield_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'IBM'
  AND date >= toStartOfMonth(today() - 365)
  AND date <= today()
GROUP BY toStartOfMonth(date)
ORDER BY max(date)