Dividend Data

Dividend Data is the lightning-fast gateway to institutional-grade stock market intelligence, built directly into the spreadsheets you already use. It eliminates the tedious, error-prone manual work of copying, pasting, and updating stock data. Designed specifically for dividend and fundamental investors, the tool provides instant, live access to over 30 years of historical data for more than 80,000 global tickers. You get dividends, yields, payout ratios, growth rates, complete financial statements, key ratios, price history, and over 100 essential metrics through simple, custom formulas. Just type a formula like =DIVIDENDDATA_DIVIDENDS("MSFT") and the data populates your cell in under a second. No API keys to manage, no coding required, and no more broken links. Its robust free tier offers 2,500 monthly credits with no trial expiration, making professional analysis accessible to everyone. Built by a dividend investor for dividend investors, it delivers the depth and reliability of expensive terminals without the prohibitive cost, supercharging your research and portfolio tracking directly within Google Sheets and Microsoft Excel.

Instant Spreadsheet Integration

Access a vast financial database directly in your cells with 16+ custom functions. Simply type intuitive formulas like =DIVIDENDDATA_QUOTE("AAPL", "price") or =DIVIDENDDATA_RATIOS("KO", "PeRatio") to pull live, updated data instantly. It works natively in both Google Sheets and Microsoft Excel, turning your spreadsheet into a powerful, automated analysis terminal without any coding or complex setup.

Comprehensive Dividend & Fundamental Data

Get everything a serious investor needs in one place. The platform provides deep data sets including forward and historical dividends, ex-dates, yields, payout ratios, and dividend growth rates. Beyond dividends, access full financial statements (income, balance sheet, cash flow), earnings metrics, valuation ratios, and price history—over 100 key metrics derived from 30+ years of historical market data.

Built for Speed and Efficiency

Experience average response times under 0.84 seconds. This tool is engineered for speed, delivering data almost instantly as you build or update your models. This eliminates waiting for web queries or manual updates, allowing you to screen stocks, update portfolios, and perform analysis with unprecedented speed and efficiency, keeping your decisions based on the latest information.

Robust Free Tier with No Expiration

Start analyzing immediately with a genuinely free plan that provides 2,500 credits every month, forever. There's no trial period that cuts off, and no credit card is required to begin. This allows individual investors to perform substantial research and build automated spreadsheets at zero cost, lowering the barrier to professional-grade investment tools.

Automated Dividend Portfolio Tracking

Eliminate manual monthly updates. Create a master portfolio sheet that automatically updates dividend amounts, payment dates, yields, and declared amounts for all your holdings. Instantly calculate projected annual income, track dividend growth, and monitor ex-dividend dates without ever leaving your spreadsheet, saving hours of manual data entry.

Rapid Stock Screening and Analysis

Screen thousands of stocks in minutes based on your custom criteria. Use formulas to pull PE ratios, dividend yields, payout ratios, or debt-to-equity across entire watchlists. Quickly compare fundamentals side-by-side to identify undervalued dividend growers or filter out overpriced stocks, accelerating your due diligence process dramatically.

Building Dynamic Financial Models

Construct powerful, auto-updating discounted cash flow (DCF) models or dividend discount models (DDM). Pull in historical EPS, growth rates, and balance sheet data directly into your assumptions. Your model stays current with live price and financial data, ensuring your valuation outputs are always based on the latest available market information.

Historical Performance Backtesting

Test investment strategies against decades of market data. Pull 30+ years of historical prices, dividend payments, and financial ratios to backtest how a dividend growth or value strategy would have performed. Analyze trends, calculate compound annual growth rates, and validate your thesis with robust, long-term historical datasets.

How does the free tier work?

The free tier provides 2,500 credits every rolling month at no cost and requires no credit card to sign up. Each data point retrieved by a formula (e.g., one cell with a price or a dividend yield) typically costs one credit. This plan does not expire, allowing you to perform significant analysis continuously. You can monitor your usage directly within the add-in.

What data sources does Dividend Data use?

Dividend Data aggregates and cleans data from multiple high-quality, institutional-grade financial data providers to ensure accuracy and comprehensiveness. This includes exchange data, regulatory filings (like 10-Ks and 10-Qs), and other trusted financial databases, providing you with reliable and audit-ready data for over 80,000 global securities.

Do I need to know how to code or use APIs?

Absolutely not. Dividend Data is designed for investors, not programmers. There is no API key to configure. You simply install the add-in for Google Sheets or Microsoft Excel and start using the plain-English custom formulas directly in your spreadsheet cells. The data flows in automatically with zero technical setup.

Is my data and portfolio information secure?

Yes. Your spreadsheet data and portfolio lists remain private in your own Google or Microsoft Excel file. Dividend Data's formulas only send the ticker symbol and metric you request to its servers to fetch the corresponding public market data. Your personal holdings, share counts, and proprietary models are never transmitted or stored on Dividend Data's servers.