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 call as 1 data call per 10 symbols, rounded up, rather than one call per symbol.
Example: real-time prices for a watchlist.
=SF(A1:A100, "quote", "price")Example: real-time price, volume, market cap, and P/E for a list of symbols.
=SF(A2:A502, "quote", "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
Quote and profile metrics are fully batchable. TTM ratios and Financial Score are also batchable with plan-dependent limits. Annual and quarterly ratios are not batchable; each symbol requires its own call. For Financial Score batching, see Financial Score Batch.
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, "quote", "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.