acilis_duzeltmesi

Name: acilis_duzeltmesi
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 ranking 8×4read in context →

acilis_duzeltmesi — 8 rows by 4 columns, computed 2026-09-22 from US exchange, SIP and OPRA data.
ticker	olay_sayisi	temettu_orani_pct	acilis_degisim_pct
XOM	23	0.958	-0.843
PEP	23	0.797	-0.659
KO	23	0.735	-0.739
JNJ	23	0.685	-0.594
PG	23	0.637	-0.304
HD	23	0.621	-0.146
MSFT	23	0.207	-0.148
AAPL	23	0.129	0.183

Rows × columns: 8 × 4
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 acilis_duzeltmesi, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	8 distinct values (AAPL, HD, JNJ…)
`olay_sayisi`	number	every row is 23
`temettu_orani_pct`	number	0.129 to 0.958	percent
`acilis_degisim_pct`	number	-0.843 to 0.183	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-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
gunluk AS (
    SELECT
        ticker,
        date,
        toFloat64(any(open))  AS acilis,
        toFloat64(any(close)) AS kapanis
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('AAPL','MSFT','KO','JNJ','PG','XOM','HD','PEP')
      AND date >= '2021-01-01'
    GROUP BY ticker, date
),
onceki AS (
    SELECT
        ticker,
        date,
        acilis,
        lagInFrame(kapanis) OVER (PARTITION BY ticker ORDER BY date
                                  ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS onceki_kapanis
    FROM gunluk
),
temettuler AS (
    SELECT
        ticker,
        ex_dividend_date,
        max(toFloat64(cash_amount)) AS tutar
    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 >= '2021-01-01'
    GROUP BY ticker, ex_dividend_date
)
SELECT
    o.ticker                                               AS ticker,
    count()                                                AS olay_sayisi,
    round(avg(t.tutar / o.onceki_kapanis * 100), 3)        AS temettu_orani_pct,
    round(avg((o.acilis / o.onceki_kapanis - 1) * 100), 3) AS acilis_degisim_pct
FROM onceki AS o
INNER JOIN temettuler AS t ON t.ticker = o.ticker AND t.ex_dividend_date = o.date
WHERE o.onceki_kapanis > 0
GROUP BY o.ticker
HAVING count() >= 4
ORDER BY temettu_orani_pct DESC

SQL to run

WITH
gunluk AS (
    SELECT
        ticker,
        date,
        toFloat64(any(open))  AS acilis,
        toFloat64(any(close)) AS kapanis
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('AAPL','MSFT','KO','JNJ','PG','XOM','HD','PEP')
      AND date >= '2021-01-01'
    GROUP BY ticker, date
),
onceki AS (
    SELECT
        ticker,
        date,
        acilis,
        lagInFrame(kapanis) OVER (PARTITION BY ticker ORDER BY date
                                  ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS onceki_kapanis
    FROM gunluk
),
temettuler AS (
    SELECT
        ticker,
        ex_dividend_date,
        max(toFloat64(cash_amount)) AS tutar
    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 >= '2021-01-01'
    GROUP BY ticker, ex_dividend_date
)
SELECT
    o.ticker                                               AS ticker,
    count()                                                AS olay_sayisi,
    round(avg(t.tutar / o.onceki_kapanis * 100), 3)        AS temettu_orani_pct,
    round(avg((o.acilis / o.onceki_kapanis - 1) * 100), 3) AS acilis_degisim_pct
FROM onceki AS o
INNER JOIN temettuler AS t ON t.ticker = o.ticker AND t.ex_dividend_date = o.date
WHERE o.onceki_kapanis > 0
GROUP BY o.ticker
HAVING count() >= 4
ORDER BY temettu_orani_pct DESC

⌘/Ctrl + Enter