SheetsFinance Docs
HomeSymbol SearchPricing
DocumentationGuides
Formula Patterns
Get a single value from a multi-row functionBatch symbols to reduce formula callsStack limited date ranges with VSTACKUse LET and ARRAYFORMULA with SheetsFinanceGet a single RSI value in one cellChart price data with SPARKLINEScreen stocks by sector and financial metricsBuild a market-cap index with the Stock Screener
Custom Ratio Calculations
Compare a stock to sector and industry PECalculate forward P/E from estimatesBuild enterprise value from componentsCalculate forward dividend yieldCalculate MACD lines from EMAsCalculate yearly or end-of-year returnsCalculate CAGR from underlying metrics
All Collections

Formula Patterns

Learn reusable patterns that combine the power of SheetsFinance functions with native Google Sheets and Excel formulas.

Get a single value from a multi-row function

Batch symbols to reduce formula calls

Stack limited date ranges with VSTACK

Use LET and ARRAYFORMULA with SheetsFinance

Get a single RSI value in one cell

Chart price data with SPARKLINE

Screen stocks by sector and financial metrics

Build a market-cap index with the Stock Screener

SupportDiscord