📖 Function Index
latestDividend()
Get the most recent dividend payment
lastDividendDate()
Date of the last dividend payment
ytdDividend()
Year-to-date dividend total
trailingAnnualDividend()
Last 12 months dividend total
forwardAnnualDividend()
Projected next 12 months
trailingDividendYield()
Yield based on trailing dividends
latestDividendYield()
Yield based on latest payment
dividendGrowthTrend()
Historical dividend growth rate
nextEstimatedDividendDate()
Estimated next payment date
estimatedNextDividend()
Estimated next payment amount
Latest Dividend
Returns the most recent dividend payment amount for a given stock symbol.
Examples
Most recent quarterly dividend payment
Latest dividend per share
Last Dividend Date
Returns the payment date of the most recent dividend as a Google Sheets date value.
Examples
Date can be formatted using Google Sheets date formatting
Human-readable date format
Year-to-Date Dividend
Returns the total dividend payments received from January 1st of the current year to today.
Examples
Total dividends paid so far this year
YTD dividend income from 100 shares of Home Depot
Trailing Annual Dividend
Returns the total dividend payments over the last 12 months, providing a current view of annual dividend income.
Examples
Total dividends paid in the last 12 months
Where B2 contains your share count for AT&T
Forward Annual Dividend
Projects the next 12 months of dividend payments based on the latest payment and estimated frequency.
Examples
Projected annual dividend based on latest quarterly payment
Difference shows expected dividend growth
Trailing Dividend Yield
Calculates the dividend yield based on trailing 12-month dividends and current stock price.
Examples
6.34% yield as decimal (format as percentage in Sheets)
Formatted as a readable percentage
Latest Dividend Yield
Calculates yield by annualizing the most recent dividend payment based on estimated frequency.
Examples
Yield based on most recent dividend payment
Positive difference suggests recent dividend increase
Dividend Growth Trend
Analyzes historical dividend payments to calculate the average year-over-year growth rate.
Examples
8.75% average annual dividend growth
3M's historical dividend growth rate
Next Estimated Dividend Date
Predicts the next dividend payment date based on historical payment patterns and intervals.
Examples
Estimated next dividend payment date
Number of days until next estimated PepsiCo dividend
Estimated Next Dividend
Predicts the amount of the next dividend payment using growth trends and historical patterns.
Examples
Estimated next quarterly dividend payment
3.5% expected growth from last payment
💡 Pro Tips & Best Practices
🎯 Function Accuracy
Trailing functions use actual historical data and are most accurate. Forward and estimated functions are projections based on patterns.
⚡ Performance
Functions are cached to improve speed. Data refreshes automatically but you can force refresh by editing and re-entering a formula.
📊 Formatting
Use TEXT() function or cell formatting to display yields as percentages and dates in your preferred format.
🔄 Updates
Dividend data comes from Yahoo Finance. New payments typically appear within 1-2 business days of the payment date.
🌍 Coverage
Functions work with most US stocks, ETFs, and many international securities. Use the official ticker symbol for best results.
🛡️ Error Handling
If a function returns 0 or appears blank, the security may not pay dividends or the ticker may be incorrect.
📊 Dashboard Examples
Portfolio Income Tracker
| Symbol | Shares | Annual Income |
| AAPL | 100 | =trailingAnnualDividend("AAPL")*B2 |
| MSFT | 50 | =trailingAnnualDividend("MSFT")*B3 |
| Total | =SUM(C2:C3) |
Dividend Growth Analysis
| Stock | Growth Rate | Quality |
| JNJ | =dividendGrowthTrend("JNJ") | =IF(B2>0.05,"High","Moderate") |
| KO | =dividendGrowthTrend("KO") | =IF(B3>0.05,"High","Moderate") |
Ready to supercharge your dividend analysis?
Install Dividend Toolkit and start using these powerful functions in your Google Sheets today.