Payers across their own share split: the raw change against the split-adjusted change

Name: Payers across their own share split: the raw change against the split-adjusted change
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 Dividend Increases & Cuts This Week.

as of 2026-10-08 series 9×7read in context →

Payers across their own share split: the raw change against the split-adjusted change — 9 rows by 7 columns, computed 2026-10-08 from US exchange, SIP and OPRA data.
ticker	split_ratio	executed_date	before_split_usd	after_split_usd	apparent_pct	adjusted_pct
NVDA	10-for-1	2024-06-10	0.04	0.01	-75	150
WMT	3-for-1	2024-02-26	0.57	0.2075	-63.6	9.2
AVGO	10-for-1	2024-07-15	5.25	0.53	-89.9	1
BKNG	25-for-1	2026-04-06	10.5	0.42	-96	0
CTAS	4-for-1	2024-09-12	1.56	0.39	-75	0
ETR	2-for-1	2024-12-13	1.2	0.6	-50	0
FAST	2-for-1	2025-05-22	0.44	0.22	-50	0
LRCX	10-for-1	2024-10-03	2.3	0.23	-90	0
ODFL	2-for-1	2024-03-28	0.52	0.26	-50	0

Rows × columns: 9 × 7
Period covered: 2024-02-26 to 2026-04-06
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 Payers across their own share split: the raw change against the split-adjusted change, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	9 distinct values (AVGO, BKNG, CTAS…)
`split_ratio`	text	5 distinct values (10-for-1, 2-for-1, 25-for-1…)
`executed_date`	date	2024-02-26 to 2026-04-06
`before_split_usd`	number	0.04 to 10.5	US dollars
`after_split_usd`	number	0.01 to 0.6	US dollars
`apparent_pct`	number	-96 to -50	percent
`adjusted_pct`	number	0 to 150	percent

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 sp AS (
    SELECT ticker,
           max(execution_date) AS exec_date,
           argMax(split_to / split_from, execution_date) AS ratio
    FROM global_markets.stocks_splits
    WHERE adjustment_type = 'forward_split'
      AND split_from > 0
      AND split_to >= split_from * 2
      AND modulo(split_to, split_from) = 0
      AND ticker IN ('NVDA', 'AVGO', 'WMT', 'LRCX', 'CTAS', 'ETR', 'FAST', 'ODFL', 'BKNG')
      AND execution_date >= today() - 1500
      AND execution_date <= today() - 90
    GROUP BY ticker
),
divs AS (
    SELECT ticker, ex_dividend_date, argMax(cash_amount, declaration_date) AS amt
    FROM global_markets.stocks_dividends
    WHERE distribution_type = 'recurring'
      AND cash_amount > 0
      AND currency = 'USD'
      AND ticker IN ('NVDA', 'AVGO', 'WMT', 'LRCX', 'CTAS', 'ETR', 'FAST', 'ODFL', 'BKNG')
    GROUP BY ticker, ex_dividend_date
)
SELECT sp.ticker AS ticker,
       concat(toString(toUInt32(round(sp.ratio))), '-for-1') AS split_ratio,
       toString(sp.exec_date) AS executed_date,
       round(argMaxIf(d.amt, d.ex_dividend_date, d.ex_dividend_date < sp.exec_date), 4) AS before_split_usd,
       round(argMinIf(d.amt, d.ex_dividend_date, d.ex_dividend_date >= sp.exec_date), 4) AS after_split_usd,
       round(100 * (argMinIf(d.amt, d.ex_dividend_date, d.ex_dividend_date >= sp.exec_date)
                    / argMaxIf(d.amt, d.ex_dividend_date, d.ex_dividend_date < sp.exec_date) - 1), 1) AS apparent_pct,
       round(100 * (argMinIf(d.amt, d.ex_dividend_date, d.ex_dividend_date >= sp.exec_date) * sp.ratio
                    / argMaxIf(d.amt, d.ex_dividend_date, d.ex_dividend_date < sp.exec_date) - 1), 1) AS adjusted_pct
FROM sp
INNER JOIN divs d ON d.ticker = sp.ticker
GROUP BY sp.ticker, sp.ratio, sp.exec_date
HAVING countIf(d.ex_dividend_date < sp.exec_date) > 0
   AND countIf(d.ex_dividend_date >= sp.exec_date) > 0
ORDER BY adjusted_pct DESC, sp.ticker

SQL to run

WITH sp AS (
    SELECT ticker,
           max(execution_date) AS exec_date,
           argMax(split_to / split_from, execution_date) AS ratio
    FROM global_markets.stocks_splits
    WHERE adjustment_type = 'forward_split'
      AND split_from > 0
      AND split_to >= split_from * 2
      AND modulo(split_to, split_from) = 0
      AND ticker IN ('NVDA', 'AVGO', 'WMT', 'LRCX', 'CTAS', 'ETR', 'FAST', 'ODFL', 'BKNG')
      AND execution_date >= today() - 1500
      AND execution_date <= today() - 90
    GROUP BY ticker
),
divs AS (
    SELECT ticker, ex_dividend_date, argMax(cash_amount, declaration_date) AS amt
    FROM global_markets.stocks_dividends
    WHERE distribution_type = 'recurring'
      AND cash_amount > 0
      AND currency = 'USD'
      AND ticker IN ('NVDA', 'AVGO', 'WMT', 'LRCX', 'CTAS', 'ETR', 'FAST', 'ODFL', 'BKNG')
    GROUP BY ticker, ex_dividend_date
)
SELECT sp.ticker AS ticker,
       concat(toString(toUInt32(round(sp.ratio))), '-for-1') AS split_ratio,
       toString(sp.exec_date) AS executed_date,
       round(argMaxIf(d.amt, d.ex_dividend_date, d.ex_dividend_date < sp.exec_date), 4) AS before_split_usd,
       round(argMinIf(d.amt, d.ex_dividend_date, d.ex_dividend_date >= sp.exec_date), 4) AS after_split_usd,
       round(100 * (argMinIf(d.amt, d.ex_dividend_date, d.ex_dividend_date >= sp.exec_date)
                    / argMaxIf(d.amt, d.ex_dividend_date, d.ex_dividend_date < sp.exec_date) - 1), 1) AS apparent_pct,
       round(100 * (argMinIf(d.amt, d.ex_dividend_date, d.ex_dividend_date >= sp.exec_date) * sp.ratio
                    / argMaxIf(d.amt, d.ex_dividend_date, d.ex_dividend_date < sp.exec_date) - 1), 1) AS adjusted_pct
FROM sp
INNER JOIN divs d ON d.ticker = sp.ticker
GROUP BY sp.ticker, sp.ratio, sp.exec_date
HAVING countIf(d.ex_dividend_date < sp.exec_date) > 0
   AND countIf(d.ex_dividend_date >= sp.exec_date) > 0
ORDER BY adjusted_pct DESC, sp.ticker

⌘/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 analysisDividend Increases & Cuts This Week

Increases against cuts, by week of declaration (complete weeks only) series 26×4 → Dividend cuts declared in the last 90 days, the deepest 14 first (one week is too thin for a table) series 14×6 → Dividend increases declared in the last 7 days, largest companies first (capped at 12 rows) series 7×8 → Increases, cuts and the typical raise this calendar year, by company size (bands use today's market value) table 4×6 → Dividend cuts at major US companies, ranked by the size of the drop (last 6 years) ranking 14×4 → AT&T's annual dividend per share, before and after its 2022 reset ranking 8×2 → See all 3,256 queries →