temettu_takvimi

Name: temettu_takvimi
Creator: Strasmore
Published: 2026-09-22
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-09-22, from ex-dividend-date-for-turkish-investors.

as of 2026-09-22 table 8×7read in context →

temettu_takvimi — 8 rows by 7 columns, computed 2026-09-22 from US exchange, SIP and OPRA data.
ticker	temettusuz_islem_gunu	kayit_gunu	odeme_gunu	temettu_usd	ex_odeme_gun_delta
AAPL	10 Ağu	10 Ağu	13 Ağu	0.27	3
XOM	17 Ağu	17 Ağu	10 Eyl	1.03	24
MSFT	20 Ağu	20 Ağu	10 Eyl	0.91	21
JNJ	25 Ağu	25 Ağu	8 Eyl	1.34	14
HD	3 Eyl	3 Eyl	17 Eyl	2.33	14
PEP	4 Eyl	4 Eyl	30 Eyl	1.48	26
KO	15 Eyl	15 Eyl	1 Eki	0.53	16
MSFT	19 Kas	19 Kas	10 Ara	0.98	21

Rows × columns: 8 × 7
Computed: 2026-09-22
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 temettu_takvimi, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	7 distinct values (AAPL, HD, JNJ…)
`temettusuz_islem_gunu`	text	8 distinct values (10 Ağu, 15 Eyl, 17 Ağu…)
`kayit_gunu`	text	8 distinct values (10 Ağu, 15 Eyl, 17 Ağu…)
`odeme_gunu`	text	7 distinct values (1 Eki, 10 Ara, 10 Eyl…)
`temettu_usd`	number	0.27 to 2.33	US dollars
`ex_kayit_gun_delta`	number	every row is 0
`ex_odeme_gun_delta`	number	3 to 26

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-09-22, 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 ['Oca','Şub','Mar','Nis','May','Haz','Tem','Ağu','Eyl','Eki','Kas','Ara'] AS ay
SELECT
    ticker,
    concat(toString(toDayOfMonth(ex_dividend_date)), ' ',
           arrayElement(ay, toMonth(ex_dividend_date)))              AS temettusuz_islem_gunu,
    concat(toString(toDayOfMonth(any(record_date))), ' ',
           arrayElement(ay, toMonth(any(record_date))))              AS kayit_gunu,
    concat(toString(toDayOfMonth(any(pay_date))), ' ',
           arrayElement(ay, toMonth(any(pay_date))))                 AS odeme_gunu,
    round(any(toFloat64(cash_amount)), 4)                            AS temettu_usd,
    dateDiff('day', ex_dividend_date, any(record_date))              AS ex_kayit_gun_delta,
    dateDiff('day', ex_dividend_date, any(pay_date))                 AS ex_odeme_gun_delta
FROM global_markets.stocks_dividends
WHERE ticker IN ('AAPL','MSFT','KO','JNJ','PG','XOM','HD','PEP')
  AND currency = 'USD'
  AND cash_amount > 0
  AND ex_dividend_date >= today() - 45
  AND ex_dividend_date <= today() + 75
GROUP BY ticker, ex_dividend_date
ORDER BY ex_dividend_date, ticker

SQL to run

WITH ['Oca','Şub','Mar','Nis','May','Haz','Tem','Ağu','Eyl','Eki','Kas','Ara'] AS ay
SELECT
    ticker,
    concat(toString(toDayOfMonth(ex_dividend_date)), ' ',
           arrayElement(ay, toMonth(ex_dividend_date)))              AS temettusuz_islem_gunu,
    concat(toString(toDayOfMonth(any(record_date))), ' ',
           arrayElement(ay, toMonth(any(record_date))))              AS kayit_gunu,
    concat(toString(toDayOfMonth(any(pay_date))), ' ',
           arrayElement(ay, toMonth(any(pay_date))))                 AS odeme_gunu,
    round(any(toFloat64(cash_amount)), 4)                            AS temettu_usd,
    dateDiff('day', ex_dividend_date, any(record_date))              AS ex_kayit_gun_delta,
    dateDiff('day', ex_dividend_date, any(pay_date))                 AS ex_odeme_gun_delta
FROM global_markets.stocks_dividends
WHERE ticker IN ('AAPL','MSFT','KO','JNJ','PG','XOM','HD','PEP')
  AND currency = 'USD'
  AND cash_amount > 0
  AND ex_dividend_date >= today() - 45
  AND ex_dividend_date <= today() + 75
GROUP BY ticker, ex_dividend_date
ORDER BY ex_dividend_date, ticker

⌘/Ctrl + Enter