📖 FORMULA GLOSSARY

Stock Data Formulas for Excel & Google Sheets

Every DIVIDENDDATA function, explained with live examples. Google Sheets uses underscore (_). Excel uses dot (.). Everything else is identical.

DIVIDENDDATA_DIVIDENDS

Dividend yield, history, ex-dates, payout frequency

7 formulas →
DIVIDENDDATA_RATIOS

P/E, payout ratio, debt/equity, ROIC, ROE and more

10 formulas →
DIVIDENDDATA_METRICS

Revenue, EPS, free cash flow, EBITDA, net income

9 formulas →
DIVIDENDDATA_GROWTH

Revenue growth, EPS growth, dividend growth CAGR

6 formulas →
DIVIDENDDATA_STATEMENT

Full income statement, balance sheet, cash flow

6 formulas →
DIVIDENDDATA_QUOTE

Live price, volume, 52-week high/low, price history

7 formulas →

Popular Pages

GOOGLEFINANCE Alternative →How to Get Dividend Yield →How to Get P/E Ratio →How to Get Payout Ratio →

Use This Formula Free

↓ Install Google Sheets Add-on↓ Install Excel Add-in

Free plan · No credit card · Both platforms live