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

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