DIVIDENDDATA_BATCH
What It Does
Retrieves batch dividend data for multiple stock symbols at once. This function efficiently fetches dividend information across several tickers, supporting both latest values and full history.
Why It's Useful
When you're managing a dividend portfolio with multiple positions, you don't want to write a separate formula for each stock. DIVIDENDDATA_BATCH lets you pull yields, payouts, and dates for your entire portfolio in a single formula — perfect for building dividend watchlists and portfolio trackers.
Syntax
=DIVIDENDDATA_BATCH(symbols, metric, showHeaders)
Parameters
Parameter | Required | Default | Description |
symbols | Yes | - | Comma-separated stock tickers (e.g., "MSFT,KMB,O") |
metric | No | "fwd_payout" | Metric(s) to retrieve - can be comma-separated |
showHeaders | No | TRUE | Include header row and symbol column |
Available Metrics
Metric | Description |
all | Get all the latest dividend metrics for the provided tickers |
history | Get the dividend history of all provided tickers |
fwd_payout | Forward annual payout |
adjdividend | Most recent declared adjusted dividend |
dividend | Most recent declared dividend |
record_date / recorddate | Most recent record date |
declaration_date / declarationdate | Most recent declaration date |
payment_date / paymentdate | Most recent payment date |
yield | Dividend yield |
frequency | Payment frequency |
Examples
Get forward payouts and yields for multiple stocks:
=DIVIDENDDATA_BATCH("MSFT,AAPL", "fwd_payout,yield", TRUE)Output: Table with symbols, forward payouts, and yields
Get all dividend data for a REIT portfolio:
=DIVIDENDDATA_BATCH("O,MAIN,STAG,NNN", "all")Output: Complete dividend data including yields, payouts, frequencies, dates, and growth rates
Get combined dividend history:
=DIVIDENDDATA_BATCH("MSFT,KMB", "history")Output: Flat historical dividend table for all symbols
Compare ex-dividend dates for tech giants:
=DIVIDENDDATA_BATCH("AAPL,MSFT,GOOGL", "ex_div_date,payment_date,dividend")Output: Table with upcoming dividend dates and amounts
Build a dividend portfolio tracker:
=DIVIDENDDATA_BATCH("JNJ,PG,KO,PEP,MCD", "fwd_payout,yield,frequency", TRUE)Output: Complete dividend overview for your portfolio