Batch symbols to reduce formula calls

Pass a range of tickers into one SF call instead of writing one formula per cell. Batching conserves quota and refreshes faster.

How batching works

SF accepts a range such as A1:A100 as the first argument. SheetsFinance returns one row per symbol and counts the entire call as a single function call rather than one hundred.

Example: real-time prices for a watchlist.

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

Example: real-time price, volume, market cap, and P/E for a list of symbols.

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

Example: historical closing prices for a list of symbols on a single date.

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

What is batchable

Real-time and company info metrics are fully batchable. TTM ratios are also batchable with plan-dependent limits. Annual and quarterly ratios are not batchable; each symbol requires its own call.

Batching with multiple metrics

You can combine batching with chaining to output and control more data with a single function call. Chain metrics with & like so:

=SF(A1:A100, "realTime", "price&volume&eps&pe")

When batching is not the right tool

Functions that return time-series arrays, such as SF_TIMESERIES and SF_TECHNICAL, cannot be batched across symbols in a single call. Use one call per symbol for those.

What is next

Read Performance Tips for more ways to keep large sheets fast.