DIVIDENDDATA.DIVIDENDS_BATCH
What It Does
Retrieves batch dividend data for multiple stocks at once. Efficient for fetching dividend info across several tickers.
Why It's Useful
Build dividend watchlists and portfolio trackers without writing separate formulas for each stock.
Syntax
=DIVIDENDDATA.DIVIDENDS_BATCH(symbols, [metric], [showHeaders])
Parameters
symbols (required): Comma-separated tickers
metric (default: fwd_payout): all, history, fwd_payout, yield, frequency, etc.
showHeaders (default: TRUE): Include headers
Examples
=DIVIDENDDATA.DIVIDENDS_BATCH("JNJ,PG,KO,PEP,MCD", "fwd_payout,yield", TRUE)=DIVIDENDDATA.DIVIDENDS_BATCH("O,MAIN,STAG", "all")