Batching

Batching lets you pass a range of ticker symbols into a single SF call instead of writing one formula per cell. A batched call counts as 1 data call per 10 symbols, rounded up: 10 symbols count as 1 call, 11 symbols count as 2, and 500 symbols count as 50. Blank and duplicate symbols are removed before counting, so repeated tickers do not add calls.

Batch limits by plan

The number of symbols you can include in a single batched call depends on your plan:

Quote, profile, historical, and Financial Score metrics support batching across symbols. Financial Score is not available on Basic; see Financial Score Batch for its batch limits. Ratios TTM uses a separate, lower batch limit because the returned datasets are large. See Ratios TTM Batch for those limits.

Functions that return time-series arrays, such as SF_TIMESERIES and SF_TECHNICAL, cannot be batched across symbols in a single call.

Examples

Real-time prices for a watchlist

Return the current price for every ticker in A1:A100:

=SF(A1:A100, "quote", "price")

Multiple real-time metrics for a list of symbols

Return price, volume, market cap, and P/E for every ticker in A2:A502:

=SF(A2:A502, "quote", "price&volume&marketCap&pe")

Historical closing prices on a single date

Return the closing price for every ticker in A2:A502 on September 30, 2020:

=SF(A2:A502, "historical", "close", "2020-09-30")

Ratios TTM batching

TTM (trailing-twelve-month) ratios support batching but use separate plan limits because the datasets are large when you combine all metrics or chain many ratios. See Ratios TTM Batch for the limits and syntax.

What is not batchable

Time-series and technical functions cannot be batched across symbols in a single call. See Batch symbols to reduce formula calls for a full list of batchable data types and how to structure batched formulas.

Related limits

For daily data call limits and platform-specific quotas, see Limits. For ways to reduce your quota usage, see Performance Tips.