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 ScreenerCalculate high, low, and average prices over a custom periodRefresh formulas from mobile Google Sheets and ExcelControl quota usage with focused refreshesSort and filter SheetsFinance data without reloading formulasScale large values with custom number formats
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

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

SupportDiscord