w8ben_gap
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-30, from us-dividend-tax-for-indian-investors.
| ticker | gross_usd_per_100sh | net_treaty_25pct_usd | net_default_30pct_usd | annual_gap_usd |
|---|---|---|---|---|
| CVX | 705 | 528.75 | 493.5 | 35.25 |
| ABBV | 683 | 512.25 | 478.1 | 34.15 |
| JNJ | 528 | 396 | 369.6 | 26.4 |
| PG | 429.06 | 321.79 | 300.34 | 21.45 |
| MSFT | 364 | 273 | 254.8 | 18.2 |
| KO | 210 | 157.5 | 147 | 10.5 |
- Rows × columns
- 6 × 5
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
ticker |
text | 6 distinct values (ABBV, CVX, JNJ…) | |
gross_usd_per_100sh |
number | 210 to 705 | US dollars |
net_treaty_25pct_usd |
number | 157.5 to 528.75 | US dollars |
net_default_30pct_usd |
number | 147 to 493.5 | US dollars |
annual_gap_usd |
number | 10.5 to 35.25 | 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 , 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
ticker,
round(gross_dps * 100, 2) AS gross_usd_per_100sh,
round(gross_dps * 100 * 0.75, 2) AS net_treaty_25pct_usd,
round(gross_dps * 100 * 0.70, 2) AS net_default_30pct_usd,
round(gross_dps * 100 * 0.05, 2) AS annual_gap_usd
FROM
(
SELECT
ticker,
sum(amount) AS gross_dps
FROM
(
SELECT
ticker,
any(toFloat64(cash_amount)) AS amount,
any(ex_dividend_date) AS ex_date
FROM global_markets.stocks_dividends
WHERE ticker IN ('JNJ', 'KO', 'PG', 'MSFT', 'ABBV', 'CVX')
AND ex_dividend_date <= today()
AND ex_dividend_date > today() - 420
GROUP BY ticker, id
ORDER BY ex_date DESC
LIMIT 4 BY ticker
)
GROUP BY ticker
)
ORDER BY gross_usd_per_100sh DESC
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.