Dividend Data

Dividend Data is a powerful financial data platform designed to bring institutional-grade stock market information directly into the tools you already use every day: Google Sheets and Microsoft Excel. It eliminates the tedious, error-prone process of manually copying and pasting data from financial websites. Instead, you get instant, live access to over 30 years of historical data for more than 80,000 tickers through simple, custom spreadsheet formulas. Built specifically by and for dividend and fundamental investors, it provides a comprehensive suite of data points including dividend amounts, yields, payout ratios, growth rates, complete financial statements, key valuation ratios, and real-time price history. The core value proposition is powerful simplicity: you get the deep data needed for serious investment analysis without needing API keys, coding skills, or a massive budget. With a generous free tier offering 2,500 monthly credits that never expire, it's built to empower every investor to make more informed, data-driven decisions right from their spreadsheet.

Extensive Spreadsheet Functions

Dividend Data provides 16 custom, easy-to-use functions that cover every essential data point for fundamental analysis. Simply type formulas like =DIVIDENDDATA_DIVIDENDS("TICKER") or =DIVIDENDDATA_RATIOS("TICKER", "PeRatio") and the live data instantly populates your cell. These functions pull from a vast database, giving you one-click access to forward dividends, ex-dates, financial metrics, and real-time quotes, transforming your spreadsheet into a dynamic research terminal.

Decades of Historical Data

Access over 30 years of clean, reliable historical market data for a comprehensive long-term view. This deep historical context is crucial for analyzing dividend growth trends, assessing company performance through multiple economic cycles, and building robust financial models. Whether you're backtesting a strategy or calculating a 10-year dividend growth rate, you have the historical depth needed for thorough due diligence.

Cross-Platform Compatibility

The tool works seamlessly in both Google Sheets and Microsoft Excel environments. You can download it as an add-in from the Microsoft AppSource or install it as a Google Workspace add-on. This flexibility ensures teams and individual investors can use their preferred spreadsheet software without sacrificing functionality, making collaboration and data consistency easy across different platforms.

Built for Fundamental & Dividend Investors

Every feature is crafted with the needs of income and value investors in mind. The data focuses on dividend sustainability (payout ratios, growth rates), fundamental health (financial statements, earnings), and key valuation metrics. It cuts through the noise to deliver the specific data points—like next ex-dividend date or forward yield—that are most critical for building and managing a dividend-focused portfolio.

Automated Dividend Portfolio Tracking

Manually updating a portfolio spreadsheet with current yields, dividend dates, and payment amounts is a chore. With Dividend Data, you can create a master watchlist or portfolio tracker where all these figures update automatically. Set formulas once for tickers like MSFT or KO, and your sheet will always display the latest forward dividend, yield, and next ex-date, saving hours of maintenance each month.

Screening and Comparative Analysis

Quickly screen and compare potential investments directly in your spreadsheet. Use the functions to pull key ratios like P/E, P/B, or debt-to-equity for a list of stocks side-by-side. Analyze dividend growth rates or payout ratios across sectors to identify the most financially stable and shareholder-friendly companies, all without ever leaving your familiar analytical environment.

Building Dynamic Financial Models

Create powerful, auto-updating discounted cash flow (DCF) models or dividend discount models (DDM). Link your model assumptions directly to live data feeds for revenue, EPS, and dividend per share. This ensures your valuation models are always based on the most recent reported figures, making your investment thesis and price targets more accurate and timely.

Educational Research and Backtesting

Ideal for students, bloggers, and investors honing their skills. Easily pull 10 years of dividend history to chart a company's growth trajectory or analyze how a stock's valuation multiples have changed over time. Test historical investment rules or strategies by building sheets that leverage decades of price and fundamental data for robust, evidence-based learning.

How does the free tier work?

The free tier is remarkably generous and designed to be permanently useful. You receive 2,500 credits every month, which do not expire and refresh on a monthly cycle. Each data pull using a formula typically costs 1 credit. This allows for substantial usage, such as updating a portfolio of 50 stocks with several data points each month, completely free of charge and without any trial period pressure.

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

Absolutely not. Dividend Data requires zero coding knowledge or API integration. The entire system works through simple spreadsheet formulas that anyone familiar with basic Excel or Google Sheets functions can use. You just type the formula with the stock ticker, and the data appears instantly—no technical setup, key management, or complex configuration is needed.

What kind of data can I access?

You have access to a comprehensive suite of data critical for fundamental analysis. This includes dividend data (amounts, yields, dates, growth), real-time quotes and price history, complete financial statements (income, balance sheet, cash flow), and over 100 key financial ratios (valuation, profitability, liquidity). The database covers 80,000+ global tickers with 30+ years of history.

Is my data secure and private?

Yes. Dividend Data operates with a strong commitment to privacy. Your spreadsheet data and portfolio information are not stored on their servers. The add-in/plug-in facilitates a direct data pull into your sheet. You are in complete control of your data within your own spreadsheet file, which resides in your Google Drive or on your local computer.