Video Overview
This episode demonstrates how to obtain and organize historical dividend data for SPY, QQQ, and Apple. In Yahoo Finance, the speaker selects the maximum date range and dividend-only records, downloads each file, sorts the dates, and adds quarterly payments into annual totals. Because the three securities began paying regular dividends in different years, incomplete years are removed and the data are aligned to a shared period before three curves are drawn in a spreadsheet. The video then compares dividend growth by looking at the slopes. A linear chart, a logarithmic chart, the starting date, and the cleaning method can produce different visual impressions, so this page records the method and the speaker's observation without treating the chart as a return forecast.
Key Takeaways
- The video uses Yahoo Finance Historical Data with the maximum range and Dividend Only settings to download dividend records for SPY, QQQ, and AAPL.
- Quarterly payments are sorted by date and added into annual totals, while incomplete years are removed before comparison.
- The securities have dividend histories of different lengths, so the video aligns a shared period before drawing the three curves.
- Curve slope offers a visual comparison, but scale, logarithmic treatment, and the selected period can materially change how growth appears.
Chapters
About 00:00:00 · Dividend Growth and Expected Return
The opening continues the simplified dividend-yield-plus-growth framework and asks how SPY and QQQ dividend growth compare.
About 00:02:00 · Downloading SPY Dividend History
The speaker selects the longest Yahoo Finance range, displays dividends only, downloads the file, and organizes it by year.
About 00:04:30 · Organizing QQQ and a Shared Period
Because early QQQ payments are less consistent, the comparison begins with more complete quarterly data and aligns it with SPY.
About 00:07:00 · Adding Apple Dividend Data
The AAPL series is downloaded, its interruption and later resumption are handled, and the usable years are added to the chart.
About 00:10:00 · Comparing Curves and Method Limits
The closing compares the three curves while leaving the selected period, chart scale, and growth-rate calculation open for further checking.
Related Topics
SPY, QQQ, AAPL, dividend growth, Yahoo Finance, historical dividend data, spreadsheets, data visualization
This page was prepared with AI from selected portions of the video's audio to help readers understand the main topics. It may omit secondary material or contain transcription errors; the original video remains authoritative.
