rutas_fiscales
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-16, from us-dividend-tax-for-spanish-investors.
| ticker | pagos_12m | bruto_100_acciones_usd | caja_broker_espanol_usd | caja_broker_extranjero_usd | neto_tras_irpf_usd |
|---|---|---|---|---|---|
| O | 12 | 324.5 | 223.42 | 275.83 | 262.85 |
| CAT | 4 | 616 | 424.12 | 523.6 | 498.96 |
| MSFT | 4 | 364 | 250.61 | 309.4 | 294.84 |
| PFE | 4 | 172 | 118.42 | 146.2 | 139.32 |
- Rows × columns
- 4 × 6
- 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 | 4 distinct values (CAT, MSFT, O…) | |
pagos_12m |
number | 4 to 12 | |
bruto_100_acciones_usd |
number | 172 to 616 | US dollars |
caja_broker_espanol_usd |
number | 118.42 to 424.12 | US dollars |
caja_broker_extranjero_usd |
number | 146.2 to 523.6 | US dollars |
neto_tras_irpf_usd |
number | 139.32 to 498.96 | 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,
count() AS pagos_12m,
round(sum(cash) * 100, 2) AS bruto_100_acciones_usd,
round(sum(cash) * 100 * 0.6885, 2) AS caja_broker_espanol_usd,
round(sum(cash) * 100 * 0.85, 2) AS caja_broker_extranjero_usd,
round(sum(cash) * 100 * 0.81, 2) AS neto_tras_irpf_usd
FROM
(
SELECT
ticker,
max(toFloat64(cash_amount)) AS cash
FROM global_markets.stocks_dividends
WHERE ticker IN ('CAT', 'MSFT', 'O', 'PFE')
AND ex_dividend_date > today() - 365
AND ex_dividend_date <= today()
GROUP BY ticker, ex_dividend_date, id
)
GROUP BY ticker
ORDER BY pagos_12m DESC, bruto_100_acciones_usd DESC
Trabaja con estos datos en tu asistente de IA
Se abre listo para consultar, con los datos de esta página. Gratis, sin cuenta.