Dividend Data

Welcome to Dividend Data, your digital treasure map to the vast and often uncharted seas of the stock market. This is not just another data tool; it's a powerful spreadsheet add-in built by a dividend investor for the community of fundamental explorers. It transforms your familiar Google Sheets or Microsoft Excel into a dynamic command center, where decades of financial history and real-time metrics are just a simple formula away. Imagine having a direct line to over 30 years of market data for more than 80,000 tickers, from blue-chip stalwarts to emerging contenders. The quest for dividends, yields, payout ratios, growth rates, complete financial statements, earnings, and over 100 key metrics ends here. No more tedious copying and pasting from unreliable sources, no complex API keys to manage, and absolutely no coding required. Dividend Data is crafted for the self-directed investor who seeks institutional-grade intelligence but refuses to pay the institutional ransom. With a generous free tier offering 2,500 monthly credits that never expire, your journey toward smarter, data-driven investment decisions can begin immediately. Unearth the hidden gems in your portfolio and discover new opportunities with the speed and precision of a seasoned prospector.

Instant Spreadsheet Automation

Banish the tedious ritual of manual data entry forever. With Dividend Data's suite of 16 custom functions, your spreadsheet becomes a live, breathing financial terminal. Simply type a formula like =DIVIDENDDATA_DIVIDENDS("MSFT") and watch as the forward annual dividend, yield, or next ex-date materializes instantly. This seamless automation turns hours of research into seconds of discovery, letting you focus on analysis rather than data gathering.

Deep Historical Data Vault

Dive into a treasure trove of market history spanning over three decades. This feature grants you access to a comprehensive archive for 80,000+ tickers, allowing you to backtest strategies, analyze long-term dividend growth trends, and understand company performance through multiple economic cycles. It's like having a time machine for your investment research, providing the context needed to make informed decisions about the future.

Cross-Platform Compatibility

Your quest for data shouldn't be limited by your tools. Dividend Data works flawlessly in both Google Sheets and Microsoft Excel, ensuring you can access its power wherever you build your financial models. Officially available on the Google Workspace Marketplace and Microsoft AppSource with stellar ratings, it integrates directly into your preferred workflow without any friction or compromise.

Built-for-Purpose Dividend Functions

This toolkit is meticulously crafted for the dividend hunter. It goes beyond simple price quotes to deliver the specific metrics that matter most: forward dividend yield, payout ratio safety, dividend growth rates, and ex-dividend dates. These specialized functions, designed by a fellow investor, act as your custom-made digging tools, expertly extracting the precise nuggets of information you need to assess income stability and growth.

Building a Dividend Growth Portfolio

Screen and analyze thousands of stocks to identify companies with a strong history of consistent and growing dividend payments. Use historical data to calculate compound annual growth rates (CAGR) and the DIVIDENDDATA_RATIOS function to check payout ratio health, ensuring you build a portfolio of financially resilient income-generating assets for the long haul.

Conducting Fundamental Company Analysis

Transform your spreadsheet into a full-scale research report. Pull in years of income statements, balance sheets, and cash flow statements alongside key ratios like P/E, Debt-to-Equity, and ROIC. This allows for deep, side-by-side comparative analysis of competitors, turning your model into a powerful lens for evaluating intrinsic value and business quality.

Automated Portfolio Monitoring and Tracking

Keep a real-time pulse on your holdings without manual updates. Create a master portfolio sheet that uses Dividend Data formulas to automatically pull current prices, dividend yields, and annual income projections. Watch your portfolio's total yield and estimated income update live, making quarterly reviews and rebalancing decisions faster and more accurate.

Educational Research and Backtesting

For students, teachers, and curious investors, Dividend Data serves as an unparalleled educational resource. Test investment theses by pulling historical price and dividend data to simulate past performance. Study how different sectors behaved during market downturns or analyze the impact of dividend cuts on stock prices, all within a flexible, familiar spreadsheet environment.

Is there really a free plan, and what does it include?

Absolutely! Dividend Data offers a genuinely free tier designed to start your exploration. It provides 2,500 credits every month, and crucially, it does not expire. This allows you to extensively test the functions, build small models, and integrate data into your personal analysis without any time pressure or credit card required.

How do I get started with Dividend Data in my spreadsheet?

Getting started is a simple expedition. For Google Sheets, visit the Google Workspace Marketplace, and for Microsoft Excel, go to Microsoft AppSource. Search for "Dividend Data," install the add-in or add-on, and it will appear in your spreadsheet's toolbar or functions menu. From there, you can immediately begin using the custom formulas.

What kind of data can I access with the formulas?

You have access to a vast arsenal of data points tailored for fundamental analysis. This includes dividend information (amount, yield, dates, growth), real-time quotes, 30+ years of price history, complete financial statements (income, balance, cash flow), and over 100 key financial ratios and metrics like P/E, EPS, and ROA.

Does Dividend Data work on both Mac and Windows versions of Excel?

Yes, the Dividend Data add-in is compatible with Microsoft Excel across platforms, including Windows, Mac, and even the web version (Excel for the web). This ensures you can access your data and maintain your financial models regardless of the device or operating system you are using.

Dividend Data operates on a transparent credit-based system. Your journey begins with a generous Free Plan that provides 2,500 credits per month with no expiration date, perfect for casual investors and extensive testing. For power users and professional investors requiring higher volume, paid subscription plans (Pro and higher tiers) are available. These plans offer substantially larger monthly credit allowances, access to premium features like the AI Analyst and advanced portfolio tracking in the web-based Dividend Data Terminal, and priority support. Specific pricing details and credit packages for these upgraded plans can be found on the official Dividend Data website under the "Pricing" section.