Batching

Batching lets you pass a range of ticker symbols into a single SF call instead of writing one formula per cell. The entire call counts as one function call against your daily data limit.

Batch limits by plan

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

Real-time, company info, and historical metrics support batching across symbols. 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, "realTime", "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, "realTime", "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.