How to Export Dividend History and ETF Data (Yield, Holdings, Expense Ratio)
Yahoo Finance shows dividend history and ETF fund data one ticker at a time, with no bulk export option. If you are comparing dividend stocks or ETFs for an income portfolio, this tool pulls the full ex-dividend date and amount history plus fund-level data (expense ratio, yield, top holdings, sector weightings) for any list of tickers as structured data.
In short: Comparing dividend consistency and yield across multiple tickers by hand means opening dozens of Yahoo Finance pages and copying numbers one by one. This tool automates it — you get structured, ready-to-use data instead of copying it by hand.
What the data shows: In this sample of 4 income tickers, JEPI's options-income strategy yields 8.11% annually — more than 7x SCHD's 3.30% — but carries a higher 0.35% expense ratio than SCHD's 0.06%, illustrating the yield-vs-cost tradeoff that matters most when screening for an income portfolio.
Sample data
| Ticker | Type | TTM Dividend | Yield | Expense Ratio | Data Range |
|---|---|---|---|---|---|
| SCHD | ETF | $1.05 | 3.30% | 0.06% | 2011–2026 |
| VOO | ETF | $7.34 | 1.07% | 0.03% | 2010–2026 |
| KO | Stock | $2.08 | 2.50% | — | 1970–2026 |
| JEPI | ETF | $4.57 | 8.11% | 0.35% | 2020–2026 |
What each field means
| Field | Description |
|---|---|
symbol | Stock or ETF ticker symbol |
dividends | Full history of ex-dividend dates and per-share amounts |
dividendCount, firstDividendDate, lastDividendDate | How many payments are on record and the date range covered |
latestDividend, ttmDividend | Most recent payment and trailing-twelve-month total |
dividendStats | Forward/trailing dividend rate and yield, payout ratio, next ex-dividend date |
etf | For ETFs only: category, expense ratio, yield, 1/3/5-year returns, top 10 holdings, and sector weightings |
How to use it
- Open the tool on Apify (link below).
- Fill in the search form — no code required.
- Run it and wait for it to finish (usually seconds).
- Download your results as JSON, CSV, or Excel.
Frequently asked questions
Do I need to know how to code?
No. You list the ticker symbols you want and download the results as JSON, CSV, or Excel.
Is this real-time data?
Yes, every run fetches current data directly from Yahoo Finance at the time you run it.
Does it work for both stocks and ETFs?
Yes. Individual stocks return dividend history and dividend stats; ETFs additionally return fund-level data like holdings and sector weightings.