Projected dividend income by month, next twelve months

Name: Projected dividend income by month, next twelve months
Creator: Strasmore
Published: 2026-10-08
License: https://www.strasmore.com/terms/

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-10-08, from Build a Dividend Income Tracker With SQL.

as of 2026-10-08 series 13×4read in context →

Projected dividend income by month, next twelve months — 13 rows by 4 columns, computed 2026-10-08 from US exchange, SIP and OPRA data.
month	month_name	projected_income	payment_count
2026-10	Oct 2026	40.72	1
2026-11	Nov 2026	106.04	2
2026-12	Dec 2026	335.32	5
2027-01	Jan 2027	40.72	1
2027-02	Feb 2027	106.04	2
2027-03	Mar 2027	229.32	4
2027-04	Apr 2027	146.72	2
2027-05	May 2027	106.04	2
2027-06	Jun 2027	229.32	4
2027-07	Jul 2027	146.72	2
2027-08	Aug 2027	106.04	2
2027-09	Sep 2027	229.32	4
2027-10	Oct 2027	106	1

Rows × columns: 13 × 4
Computed: 2026-10-08
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

Column definitions for Projected dividend income by month, next twelve months, derived from the stored result.
Column	Type	Range	Notes
`month`	text	13 distinct values (2026-10, 2026-11, 2026-12…)
`month_name`	text	13 distinct values (Apr 2027, Aug 2027, Dec 2026…)
`projected_income`	number	40.72 to 335.32
`payment_count`	number	1 to 5	count

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-10-08, and the query below is what returned them.

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 holdings AS
(
    SELECT
        tupleElement(h, 1) AS ticker,
        tupleElement(h, 2) AS shares
    FROM
    (
        SELECT arrayJoin([
            ('KO',   200.0),
            ('PG',    60.0),
            ('JNJ',   50.0),
            ('MSFT',  40.0),
            ('XOM',   80.0),
            ('O',    150.0)
        ]) AS h
    )
),
declared AS
(
    SELECT
        ticker,
        argMax(cash_amount, ex_dividend_date) AS cash_per_payment
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('KO', 'PG', 'JNJ', 'MSFT', 'XOM', 'O')
      AND currency = 'USD'
      AND frequency IN (1, 2, 4, 12)
      AND ex_dividend_date >= today() - 400
      AND ex_dividend_date <= today() + 120
    GROUP BY ticker
),
paid AS
(
    SELECT
        ticker,
        pay_date
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('KO', 'PG', 'JNJ', 'MSFT', 'XOM', 'O')
      AND frequency IN (1, 2, 4, 12)
      AND pay_date >= today() - 365
      AND pay_date <  today()
    GROUP BY ticker, pay_date
)
SELECT
    formatDateTime(toStartOfMonth(addYears(p.pay_date, 1)), '%Y-%m') AS month,
    formatDateTime(toStartOfMonth(addYears(p.pay_date, 1)), '%b %Y') AS month_name,
    round(sum(toFloat64(d.cash_per_payment) * h.shares), 2)          AS projected_income,
    count()                                                          AS payment_count
FROM paid AS p
INNER JOIN holdings AS h ON h.ticker = p.ticker
INNER JOIN declared AS d ON d.ticker = p.ticker
GROUP BY month, month_name
ORDER BY month

SQL to run

WITH holdings AS
(
    SELECT
        tupleElement(h, 1) AS ticker,
        tupleElement(h, 2) AS shares
    FROM
    (
        SELECT arrayJoin([
            ('KO',   200.0),
            ('PG',    60.0),
            ('JNJ',   50.0),
            ('MSFT',  40.0),
            ('XOM',   80.0),
            ('O',    150.0)
        ]) AS h
    )
),
declared AS
(
    SELECT
        ticker,
        argMax(cash_amount, ex_dividend_date) AS cash_per_payment
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('KO', 'PG', 'JNJ', 'MSFT', 'XOM', 'O')
      AND currency = 'USD'
      AND frequency IN (1, 2, 4, 12)
      AND ex_dividend_date >= today() - 400
      AND ex_dividend_date <= today() + 120
    GROUP BY ticker
),
paid AS
(
    SELECT
        ticker,
        pay_date
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('KO', 'PG', 'JNJ', 'MSFT', 'XOM', 'O')
      AND frequency IN (1, 2, 4, 12)
      AND pay_date >= today() - 365
      AND pay_date <  today()
    GROUP BY ticker, pay_date
)
SELECT
    formatDateTime(toStartOfMonth(addYears(p.pay_date, 1)), '%Y-%m') AS month,
    formatDateTime(toStartOfMonth(addYears(p.pay_date, 1)), '%b %Y') AS month_name,
    round(sum(toFloat64(d.cash_per_payment) * h.shares), 2)          AS projected_income,
    count()                                                          AS payment_count
FROM paid AS p
INNER JOIN holdings AS h ON h.ticker = p.ticker
INNER JOIN declared AS d ON d.ticker = p.ticker
GROUP BY month, month_name
ORDER BY month

⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent

More from this analysisBuild a Dividend Income Tracker With SQL

Yield on cost against current yield, per position ranking 6×3 → Annual dividend income per position, with a running portfolio total ranking 6×3 → Latest declared dividend per share for each sample holding table 6×5 → What the sample list paid per calendar year, share counts held fixed ranking 5×3 → Weekly peak-to-trough drawdown of the blended portfolio series 53×4 → Conagra (CAG): price, quarterly dividend, and yield, month-end 2023-07 to 2026-06 series 36×5 → See all 3,214 queries →