Sheets

Dividend data, directly in a cell.

Your income, in a cell. Three formulas, in the spreadsheet you already use.

Demo workbook

Dividend model

Ticker

Capiaro

MSFT

$0.83 · 12 Sep

fx=DIVIDENDNEXT(A2)

Formulas

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.

Demo API key

Use the sample data.

ds_live_demo_sheets_key_0001

POST /api/sheets with header x-api-key

{"formula":"DIVIDENDNEXT","ticker":"MSFT"}
{"formula":"DIVIDENDTTM","ticker":"VYM"}
{"formula":"DIVIDENDFORECAST","tickers":["AAPL","SCHD"],"shares":[10,50]}

Apps Script sources live in sheets-addon/. Free plan: 25 refreshed tickers / month. Pro: 500.

Early access

Sheets beta

Get the demo workbook and an invite when the paid beta opens.