versements_ko

Name: versements_ko
Creator: Strasmore
Published: 2026-10-03
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-03, from us-dividend-tax-for-french-investors.

as of 2026-10-03 series 16×6read in context →

versements_ko — 16 rows by 6 columns, computed 2026-10-03 from US exchange, SIP and OPRA data.
ex_date	detachement_fr	brut_usd	apres_retenue_us_usd	net_pfu_usd	net_sans_w8ben_usd
2022-11-30	30/11/2022	0.44	0.374	0.2983	0.2323
2023-03-16	16/03/2023	0.46	0.391	0.3119	0.2429
2023-06-15	15/06/2023	0.46	0.391	0.3119	0.2429
2023-09-14	14/09/2023	0.46	0.391	0.3119	0.2429
2023-11-30	30/11/2023	0.46	0.391	0.3119	0.2429
2024-03-14	14/03/2024	0.485	0.4122	0.3288	0.2561
2024-06-14	14/06/2024	0.485	0.4122	0.3288	0.2561
2024-09-13	13/09/2024	0.485	0.4122	0.3288	0.2561
2024-11-29	29/11/2024	0.485	0.4122	0.3288	0.2561
2025-03-14	14/03/2025	0.51	0.4335	0.3458	0.2693
2025-06-13	13/06/2025	0.51	0.4335	0.3458	0.2693
2025-09-15	15/09/2025	0.51	0.4335	0.3458	0.2693
2025-12-01	01/12/2025	0.51	0.4335	0.3458	0.2693
2026-03-13	13/03/2026	0.53	0.4505	0.3593	0.2798
2026-06-15	15/06/2026	0.53	0.4505	0.3593	0.2798
2026-09-15	15/09/2026	0.53	0.4505	0.3593	0.2798

Rows × columns: 16 × 6
Period covered: 2022-11-30 to 2026-09-15
Computed: 2026-10-03
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 versements_ko, derived from the stored result.
Column	Type	Range	Notes
`ex_date`	date	2022-11-30 to 2026-09-15
`detachement_fr`	text	16 distinct values (01/12/2025, 13/03/2026, 13/06/2025…)
`brut_usd`	number	0.44 to 0.53	US dollars
`apres_retenue_us_usd`	number	0.374 to 0.4505	US dollars
`net_pfu_usd`	number	0.2983 to 0.3593	US dollars
`net_sans_w8ben_usd`	number	0.2323 to 0.2798	US dollars

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-03, 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.

SELECT
    toString(ex_dividend_date)                   AS ex_date,
    formatDateTime(ex_dividend_date, '%d/%m/%Y') AS detachement_fr,
    round(montant, 4)                            AS brut_usd,
    round(montant * 0.85, 4)                     AS apres_retenue_us_usd,
    round(montant * 0.678, 4)                    AS net_pfu_usd,
    round(montant * 0.528, 4)                    AS net_sans_w8ben_usd
FROM
(
    SELECT
        ex_dividend_date,
        max(toFloat64(cash_amount)) AS montant
    FROM global_markets.stocks_dividends
    WHERE ticker = 'KO'
      AND currency = 'USD'
      AND ex_dividend_date <= today()
    GROUP BY ex_dividend_date
    ORDER BY ex_dividend_date DESC
    LIMIT 16
)
ORDER BY ex_date

SQL to run

⌘/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