Dividend Data

Dividend Data is a comprehensive financial data platform engineered for self-directed investors, specifically targeting dividend and fundamental analysis. Its core product is a powerful spreadsheet add-in that delivers institutional-grade stock market data directly into Google Sheets and Microsoft Excel. The platform eliminates the traditional barriers to high-quality financial data: there is no need for complex API integration, coding knowledge, or manual copy-pasting from disparate sources. With access to over 30 years of historical data across 80,000+ global tickers, investors can instantly pull critical metrics through simple, custom formulas. Built by a dividend investor for the community, it provides a robust free tier with 2,500 monthly credits that never expires, making professional analysis accessible. The value proposition is clear: automate your investment research workflow with reliable, real-time data on dividends, yields, financial statements, valuation ratios, and price history, all without the institutional price tag, directly within the tools you already use.

Extensive Financial Data Library

Dividend Data provides direct access to over 100 key financial metrics spanning three decades of market history. This includes detailed dividend information (dates, amounts, growth rates, payout ratios), complete financial statements (income, balance sheet, cash flow), essential valuation and profitability ratios (P/E, P/B, ROE), and real-time price quotes. This centralized library ensures all data points are consistent, comparable, and updated automatically, replacing hours of manual data aggregation from multiple unreliable sources.

Seamless Spreadsheet Integration

The platform operates entirely through native add-ins for Google Sheets and Microsoft Excel, requiring zero technical setup. Users simply install the add-on and begin using intuitive custom formulas like =DIVIDENDDATA_DIVIDENDS("TICKER"). Data populates live within the spreadsheet cell, enabling dynamic models, dashboards, and screens that update automatically. This integration turns familiar spreadsheet software into a powerful, connected investment research terminal without any coding or API key management.

Built-for-Purpose Dividend Functions

Tailored specifically for income investors, Dividend Data offers 16 dedicated custom functions covering every aspect of dividend analysis. Key formulas allow users to fetch forward annual dividends, yields, ex-dividend dates, payout ratios, and dividend growth history for any stock. This focused toolset enables rapid screening and deep-dive analysis on the most critical metrics for building and monitoring a dividend growth portfolio directly within a financial model.

High-Performance Data Delivery

The system is engineered for speed and reliability, delivering data with an average response time of 0.84 seconds. This performance is critical for investors building complex models or screening large universes of stocks, as it ensures workflows are not interrupted by lag. The infrastructure supports real-time queries for prices and daily updates for fundamental data, ensuring your spreadsheets reflect the most current market information available.

Automated Dividend Portfolio Dashboard

Investors can construct a live, automated dashboard to monitor their entire dividend portfolio. By using formulas to pull current prices, annual dividend income, yield-on-cost, and ex-dividend dates for each holding, the dashboard updates in real-time. This eliminates manual entry, provides a single source of truth for portfolio health, and allows for instant tracking of projected income and portfolio valuation without leaving the spreadsheet.

Fundamental Stock Screening & Analysis

Users can build powerful stock screeners by combining multiple Dividend Data functions. For example, an investor can screen for stocks with a dividend yield above 3%, a payout ratio below 60%, and 5-year dividend growth exceeding 10%. By pulling these metrics for thousands of tickers into a structured sheet, investors can quickly identify potential investment candidates that meet their specific, quantitative criteria for further due diligence.

Historical Financial Model Backtesting

With access to 30+ years of historical data, analysts can build and backtest long-term financial models. Users can pull annual revenue, EPS, dividend payments, and key ratios for any company over decades to analyze business cycles, growth trends, and dividend sustainability through different economic environments. This enables data-driven, historical perspective when assessing a company's long-term performance and resilience.

Comparative Peer Analysis

Fundamental investors can perform detailed peer group comparisons efficiently. By creating a spreadsheet with a list of competitor tickers and using formulas to pull consistent metrics like P/E ratio, profit margin, debt-to-equity, and ROIC for all companies simultaneously, an apples-to-apples comparison is automated. This streamlines the competitive analysis phase of research, highlighting relative strengths and weaknesses across an industry.

What is included in the free tier?

The free tier offers full, unrestricted access to all 16 custom spreadsheet functions and the complete data library. It provides 2,500 credits per month, which do not expire and renew monthly. This tier is designed to be permanently usable for individual investors analyzing a moderate number of stocks, allowing for substantial research without ever requiring a credit card or facing a trial expiration date.

How does the credit system work?

Each successful call to a Dividend Data formula in your spreadsheet consumes one credit. For example, using =DIVIDENDDATA_QUOTE("MSFT", "price") counts as one credit. Pulling multiple metrics in a single call, like =DIVIDENDDATA_DIVIDENDS("AAPL", "fwd_yield"), also consumes one credit. The system is efficient, allowing you to build complex models without excessive credit consumption. Your monthly credit balance resets on your billing cycle date.

Does it work with both Google Sheets and Microsoft Excel?

Yes, Dividend Data provides fully native add-ins for both major spreadsheet platforms. You can install it as an Add-on from the Google Workspace Marketplace for Google Sheets (rated 4.9 stars) and as an Add-in from Microsoft AppSource for Excel (rated 5.0 stars). The core functions and data availability are identical across both platforms, ensuring a consistent experience regardless of your preferred software.

How current is the financial data provided?

Price data (quotes) is delivered in real-time. Fundamental data, including dividends, financial statements, and ratios, is updated daily based on the latest company filings and announcements. The platform processes new SEC filings, dividend declarations, and earnings reports to ensure your spreadsheets reflect the most recent publicly available information with high reliability.