Dividend Data

Dividend Data is a powerful financial data platform designed to eliminate the tedious manual work of stock research. It brings institutional-grade market data directly into the tools investors already use: Google Sheets and Microsoft Excel. The core product is a spreadsheet add-in that provides instant access to over 30 years of historical data for more than 80,000 tickers through simple, custom formulas. Built specifically for dividend and fundamental investors, it delivers critical metrics like dividend amounts, yields, payout ratios, growth rates, full financial statements, earnings, valuation ratios, and price history without requiring API keys, coding, or copying and pasting from unreliable sources. Its generous free tier offers 2,500 monthly credits with no trial expiration, making professional data accessible to everyone. The platform also includes a web-based Terminal for advanced visualizations, AI-powered research, and portfolio tracking. Ultimately, Dividend Data solves the problem of costly, complex data feeds by giving self-directed investors the comprehensive, accurate, and live data they need to make informed decisions, all within their familiar spreadsheet workflow.

Comprehensive Spreadsheet Functions

Dividend Data provides 16 custom functions that cover every essential data point for fundamental analysis. Simply type formulas like =DIVIDENDDATA_DIVIDENDS("TICKER") to pull forward dividends, yields, and ex-dates, or use =DIVIDENDDATA_RATIOS() and =DIVIDENDDATA_METRICS() for valuation multiples and financial statement items. This turns your spreadsheet into a dynamic, auto-updating research dashboard, replacing hours of manual data collection with instant, reliable results.

Extensive Historical Data Library

Access over 30 years of historical market and financial data for a universe of 80,000+ global tickers. This deep history is crucial for conducting robust long-term analysis, calculating consistent dividend growth rates, assessing company performance through multiple market cycles, and building reliable financial models. The data is standardized and clean, ready for immediate use in your analysis.

Dual-Platform Compatibility

The tool works seamlessly in both Google Sheets and Microsoft Excel environments. Whether you collaborate in the cloud with Google Workspace or prefer the advanced capabilities of desktop Excel, you get the same consistent formulas and data quality. This flexibility ensures teams and individual investors can use their preferred platform without sacrificing functionality or data access.

AI-Powered Research Assistant

Available in the Pro Terminal, the AI Analyst acts as a dedicated research assistant. You can chat with it to screen for stocks based on custom criteria, get explanations of financial metrics, summarize company performance, and generate investment theses. This feature accelerates the initial research phase by providing instant, data-backed insights and answers to complex analytical questions.

Building a Dividend Growth Screener

Create a dynamic stock screener directly in your spreadsheet to identify companies that meet specific dividend investment criteria. Use functions to pull dividend yield, payout ratio, and 5-year dividend growth rate for thousands of stocks simultaneously. Filter and sort to find companies with a yield above 3%, a payout ratio below 60%, and consistent annual growth, all with data that updates automatically.

Automating Portfolio Tracking and Reporting

Manually updating a portfolio spreadsheet with current prices, dividend payments, and yield-on-cost is time-consuming. With Dividend Data, link your holdings using the ticker symbols. Formulas will automatically pull the latest price, dividend announcements, and ex-dates, giving you a real-time view of your portfolio's income, valuation, and performance without any manual input.

Conducting Deep Fundamental Valuation Analysis

Perform thorough company analysis by building a integrated model that pulls live data. Use functions to import years of income statement, balance sheet, and cash flow data directly into your discounted cash flow (DCF) or ratio analysis model. This allows you to test valuation scenarios with current and historical data, ensuring your analysis is based on the most accurate and recent figures available.

Preparing Investment Committee Reports

Quickly generate professional, data-rich reports for presentations or investment reviews. Instead of manually compiling charts and tables from multiple sources, use your spreadsheet with live Dividend Data links to create executive summaries showing key metrics, dividend histories, and peer comparisons. The data refreshes automatically, ensuring every report is based on the latest market information.

How does the free tier work?

The free tier provides 2,500 credits per month, which do not expire and renew each month. No credit card is required to start. Each data point retrieved by a formula (e.g., one cell with a price or a dividend yield) typically costs one credit. This allows for substantial usage for individual investors tracking a portfolio or analyzing a handful of stocks regularly.

What data can I access with the spreadsheet add-in?

You can access over 100 key metrics including dividend data (amount, yield, date, growth), real-time quotes, valuation ratios (P/E, P/B), profitability metrics, and full financial statement items (revenue, EPS, cash flow). The add-in also provides 30+ years of historical data for most of these metrics, enabling deep historical trend analysis.

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

Absolutely not. Dividend Data is designed for investors, not programmers. There is no need for API keys, scripting, or any coding knowledge. You simply install the add-in for Google Sheets or Excel and start using the plain-English custom formulas directly in your spreadsheet cells to pull data instantly.

Is my data secure and private?

Yes. Your spreadsheet data and queries remain private. Dividend Data operates as a read-only add-in; it does not collect, store, or have access to the contents of your spreadsheets or your portfolio holdings. It only receives the ticker symbols and metric names you explicitly request in your formulas to return the corresponding public market data.

Dividend Data operates on a credit-based system. It offers a permanent free tier with 2,500 monthly credits. Paid plans, which provide higher volumes of monthly credits, are available for users who require more extensive data access. Specific plan names, credit allowances, and monthly costs are detailed on the official Dividend Data pricing page, allowing users to scale their usage based on their individual or professional needs.