Dividend Data

Dividend Data is a powerful financial data platform designed to democratize access to institutional-grade stock market information. At its core, it is a spreadsheet add-in that seamlessly integrates over 30 years of historical and real-time data for more than 80,000 tickers directly into Google Sheets and Microsoft Excel. The product eliminates the traditional barriers of complex APIs, coding requirements, and manual copy-pasting, delivering data through simple, custom formulas. Built specifically by and for dividend and fundamental investors, it provides instant access to a comprehensive suite of metrics including dividend histories, yields, payout ratios, growth rates, complete financial statements, earnings reports, valuation ratios, and price action. Its unique value proposition lies in its unparalleled ease of use combined with deep, reliable data, offering a professional analysis toolkit at a fraction of the cost of institutional terminals. With a generous free tier and robust paid plans, it serves both individual retail investors and professional analysts who seek to make informed, data-driven investment decisions without the steep learning curve or exorbitant price tag.

Extensive Custom Spreadsheet Functions

Dividend Data provides a specialized library of 16+ custom functions, such as DIVIDENDDATA_DIVIDENDS and DIVIDENDDATA_RATIOS, that act as direct conduits to live financial data. Users simply type these formulas into any cell, referencing a stock ticker and desired metric, and the platform instantly populates the cell with accurate, updated information. This transforms static spreadsheets into dynamic, auto-updating financial dashboards, covering everything from forward dividend yields and ex-dates to P/E ratios and diluted EPS.

Deep Historical & Fundamental Data Library

The platform grants users access to a vast repository of over 30 years of historical market data. This is not limited to price history but extends deeply into fundamental analysis, including decades of dividend payments, annual and quarterly financial statements, and hundreds of key financial ratios. This long-term perspective is crucial for conducting thorough trend analysis, assessing a company's financial resilience through cycles, and building robust valuation models based on historical performance.

Multi-Platform Spreadsheet Integration

A key operational feature is its seamless compatibility with both Google Sheets and Microsoft Excel. Users are not locked into a single ecosystem; they can leverage Dividend Data's capabilities within their preferred spreadsheet environment. The add-ins are officially available on the Google Workspace Marketplace and Microsoft AppSource, ensuring easy installation, secure operation, and smooth performance whether working in the cloud with Sheets or locally with Excel.

AI-Powered Research & Portfolio Tools

Beyond spreadsheets, Dividend Data offers a web-based Terminal featuring advanced tools like an AI Analyst. This assistant can answer complex investment questions, generate research reports, and provide insights based on the platform's extensive dataset. Coupled with automated portfolio tracking that aggregates holdings, calculates projected income, and visualizes performance, it creates a holistic research and management suite for the modern investor.

Building a Dividend Growth Screening Model

Investors focused on dividend growth can use Dividend Data to create a powerful screening spreadsheet. By using functions to pull dividend growth rates, payout ratios, and earnings history for thousands of stocks, they can instantly filter for companies with a history of consistent, sustainable dividend increases. This automates the initial discovery phase, allowing for rapid identification of candidates that meet specific criteria for further due diligence.

Automating Monthly Portfolio Income Reports

For income-focused investors, manually tracking dividend payments across a portfolio is tedious. With Dividend Data, users can build a master portfolio sheet where each holding's ticker automatically pulls the next ex-dividend date, payment date, and declared dividend amount. This sheet can then forecast monthly and annual income, update live, and provide a clear, always-current view of cash flow expectations without any manual data entry.

Conducting Comparative Fundamental Analysis

Analysts and serious investors can perform deep-dive comparisons between companies. By using functions to pull side-by-side data on metrics like ROE, debt-to-equity, profit margins, and valuation multiples, they can build comprehensive comparison tables. The 30+ years of data allow for analyzing how these metrics have evolved over time, providing context that is essential for determining relative strength and long-term operational efficiency.

Creating Dynamic Financial Dashboards

Financial educators, bloggers, or investment club leaders can use Dividend Data to create interactive dashboards. They can build sheets that display key real-time stats for a watchlist, such as current price, dividend yield, and P/E ratio, which refresh automatically. This turns a simple spreadsheet into a live monitoring tool, perfect for presentations, educational content, or keeping a group informed with up-to-the-minute data.

How does the free tier work and what are credits?

The free tier provides 2,500 credits per month that never expire, with no credit card required to start. Each data request made via a spreadsheet function consumes a small number of credits (typically 1-2 per call). This generous allowance allows users to perform substantial analysis and automation for free. It's designed to let investors fully test the platform's capabilities in their real-world workflows without a time-limited trial.

What kind of data can I access with the spreadsheet functions?

You can access a vast array of data points spanning dividends, quotes, fundamentals, and ratios. Specific examples include forward and historical dividend amounts/yields, ex-dividend and payment dates, current stock price, 30+ years of price history, complete financial statement items (revenue, EPS, cash flow), and over 100 pre-calculated financial ratios like P/E, P/B, and ROIC. The documentation provides a full list of all available metrics for each function.

Do I need to know how to code or set up an API?

Absolutely not. Dividend Data is built specifically to require zero coding or technical setup. There are no API keys to manage. After installing the add-in from the Google Workspace or Microsoft AppSource store, you simply use the provided custom formulas directly in your spreadsheet cells as you would any native function like =SUM(). The complexity of data sourcing and management is handled entirely in the background.

Is my data and portfolio information secure?

Yes. Dividend Data takes security seriously. The connection between your spreadsheet and their servers is secure. When using the portfolio tracking features in the Pro Terminal, your holdings data is stored privately. The company has a clear privacy policy and terms of use. Furthermore, as an official add-in listed on Google and Microsoft's marketplaces, it adheres to these platforms' security and compliance standards.