Trailing yield and payout ratio at the latest stored Microsoft close

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.

SELECT
    toString(p.day)                                                             AS price_date,
    concat(formatDateTime(p.day, '%b'), ' ',
           toString(toDayOfMonth(p.day)), ', ',
           toString(toYear(p.day)))                                             AS price_date_label,
    round(p.close, 2)                                                           AS close_price,
    round(d.trailing_dividends, 2)                                              AS trailing_12m_dividends,
    round(d.trailing_dividends / p.close * 100, 2)                              AS trailing_yield_pct,
    round(r.eps, 2)                                                             AS earnings_per_share,
    round(d.trailing_dividends / r.eps * 100, 1)                                AS payout_ratio_pct
FROM
(
    SELECT
        max(toDate(date))                   AS day,
        argMax(toFloat64(close), date)      AS close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'MSFT'
      AND date >= today() - 30
) AS p
CROSS JOIN
(
    SELECT sum(toFloat64(dividend)) AS trailing_dividends
    FROM
    (
        SELECT
            ex_dividend_date,
            any(cash_amount) AS dividend
        FROM global_markets.stocks_dividends
        WHERE ticker = 'MSFT'
          AND ex_dividend_date >  today() - 365
          AND ex_dividend_date <= today()
        GROUP BY ex_dividend_date
    )
) AS d
CROSS JOIN
(
    SELECT argMax(toFloat64(earnings_per_share), date) AS eps
    FROM global_markets.stocks_ratios
    WHERE ticker = 'MSFT'
      AND date >= today() - 120
) AS r