DIVIDENDDATA_QUOTE_BATCH
What It Does
Retrieves batch quote data for multiple stocks at once. Efficiently fetch prices, changes, and volumes across multiple tickers in a single formula.
Why It's Useful
Perfect for building stock watchlists and portfolio trackers. Instead of writing separate formulas for each stock, pull all your portfolio quotes in one formula. Great for monitoring prices and identifying stocks trading at interesting levels.
Syntax
=DIVIDENDDATA_QUOTE_BATCH(symbols, metrics, showHeaders)
Parameters
Parameter | Required | Default | Description |
symbols | Yes | - | Comma-separated tickers (e.g., "AAPL,MSFT") |
metrics | No | "all" | Comma-separated metrics or "all" |
showHeaders | No | TRUE | Include headers and symbol column |
Available Metrics
Metric | Description |
all | All quote metrics |
price | Current prices |
change | Price changes |
volume | Trading volumes |
priceAvg50 | 50-day moving averages |
priceAvg200 | 200-day moving averages |
Examples
Build a watchlist with prices and changes:
=DIVIDENDDATA_QUOTE_BATCH("AAPL,MSFT,GOOGL,AMZN,META", "price,change")Output: Table with Symbol, Price, Change for all stocks
Get full quotes for portfolio:
=DIVIDENDDATA_QUOTE_BATCH("MSFT,KMB,O,JNJ,PG", "all", TRUE)Output: Complete quote data for all symbols
Monitor moving averages for dividend stocks:
=DIVIDENDDATA_QUOTE_BATCH("JNJ,PG,KO,PEP", "price,priceAvg50,priceAvg200")Output: Prices with 50 and 200-day moving averages
Track daily changes:
=DIVIDENDDATA_QUOTE_BATCH("VZ,T,TMUS", "price,change,volume")Output: Price, change, and volume for telecom stocks