Dividend data, directly in a cell.
Next payout, trailing dividends, and a twelve-month forecast. No API key in your spreadsheet. The demo key uses a 25-ticker monthly cap. Paid quotas are still in early access.
Demo workbookDividend model
A
B
C
1
Ticker
Shares
Capiaro
2
MSFT
20
$0.83 · 12 Sep
fx
=DIVIDENDNEXT(A2)Income, by formula
- DIVIDENDNEXT
- Next regular amount plus ex-date and pay date.
- DIVIDENDTTM
- Trailing or annualized dividend per share.
- DIVIDENDFORECAST
- Projected next-12-month income from ticker and share arrays.
Formula reference
See the demo key, request format, and Apps Script setup in the Sheets documentation.
Read Sheets documentationSheets beta
Get the demo workbook and an invite when the paid beta opens.