SheetsFinance Docs

Home Symbol Search Pricing

Documentation Guides

Formula Patterns

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 Calculate high, low, and average prices over a custom period Refresh formulas from mobile Google Sheets and Excel Control quota usage with focused refreshes Sort and filter SheetsFinance data without reloading formulas Scale large values with custom number formats

Custom Ratio Calculations

Compare a stock to sector and industry PE Calculate forward P/E from estimates Build enterprise value from components Calculate forward dividend yield Calculate MACD lines from EMAs Calculate yearly or end-of-year returns Calculate CAGR from underlying metrics Calculate WACC from fundamental values Get an intraday historical price at a specific time

Legacy Functions

All Collections

Legacy Functions

Options Basic

Support Discord