# Google Sheets Dividend Sync

Live dividend data in the sheet you already use.

## Formulas

- `=DIVIDENDNEXT("MSFT")` — next regular amount, ex-date, and pay date
- `=DIVIDENDTTM("VYM")` — trailing or annualized dividend per share
- `=DIVIDENDFORECAST(A2:A10, B2:B10)` — projected next-12-month income

Data is cached and delayed. Market-data API keys stay on the server.

## Quotas

- Free: 25 refreshed tickers / month
- Pro: 500 tickers / month

## Links

- Setup: https://www.capiaro.com/sheets
- Demo workbook: https://www.capiaro.com/sheets/template