Dividend Data

Alright, let's cut through the Wall Street jargon. Dividend Data is your new bestie for stock analysis, but it lives where you already work: your spreadsheet. Think of it as a magic wand for Google Sheets and Microsoft Excel that summons decades of stock market intel with a simple formula. Done with copying and pasting data from sketchy websites or wrestling with complex API keys? This tool is built for that exact pain point. It's specifically crafted for dividend and fundamental investors who are tired of paying Bloomberg Terminal prices but still want that institutional-grade data. We're talking instant access to dividends, yields, payout ratios, growth rates, full financial statements, earnings, key ratios, price history, and over 100 other metrics. The best part? You just type something like =DIVIDENDDATA_DIVIDENDS("MSFT") and bam, the data appears live. It's got a legit free tier that doesn't ghost you after a trial (2,500 credits monthly, forever), covers over 80,000 tickers with 30+ years of history, and was built by a dividend investor who actually gets what you need. This is for the investor who wants to level up their research game without the institutional price tag or headache.

Spreadsheet Superpowers

This is the core magic. The add-in gives you a library of custom functions (like DIVIDENDDATA_DIVIDENDS, DIVIDENDDATA_RATIOS, etc.) that work directly in your cells. No more tab-hopping to finance sites. You build your own live, updating financial models and dashboards right inside the comfort of Google Sheets or Excel. It automates the tedious data-grunt work so you can focus on the actual analysis.

Deep Dividend & Fundamental Data Dive

Built for the income-focused crowd, it delivers the specific metrics you crave. Get forward dividends, yields, ex-dates, payout ratios, and dividend growth rates instantly. But it doesn't stop there; you also get the full context with PE ratios, EPS, revenue, balance sheet items, and over 100 other fundamental metrics. It's like having a direct feed from the market's brain into your spreadsheet.

30+ Years of Historical Context

You can't make smart decisions with just today's data. Dividend Data hooks you up with decades of historical data for those 80,000+ tickers. This lets you backtest strategies, analyze long-term trends, calculate compound growth rates, and see how a company performed through different market cycles. It's your financial time machine, no DeLorean required.

AI-Powered Research Assistant (Pro Terminal)

Beyond the spreadsheets, their flagship web app, the Dividend Data Terminal, includes an AI Analyst. This is your on-demand research buddy. Chat with it to get summaries, ask complex questions about stocks, and generate insights without digging through 10-Ks yourself. It supercharges your initial research phase before you even build your spreadsheet model.

Building a Dynamic Dividend Dashboard

Create a master spreadsheet that tracks your entire watchlist or portfolio. Use formulas to pull in live dividend yields, next ex-dates, payout ratios, and stock prices. Watch it update automatically, giving you a real-time snapshot of your income investments without manual refreshes. Perfect for tracking your dividend calendar.

Screening for Dividend Aristocrats & Growers

Use the historical data functions to screen for stocks with a proven track record. Build formulas that check for consecutive years of dividend growth, analyze growth rates over 5 or 10 years, and filter by safe payout ratios. You can create a powerful, custom stock screener that lives right in your Sheets or Excel.

Performing Deep-Dive Company Analysis

When you find a interesting stock, go deep. Pull 10 years of income statements, balance sheets, and cash flow statements directly into a sheet to build your own financial models and ratio analysis. Calculate trends in debt, margins, and returns on equity without ever leaving your workbook.

Automating Portfolio Performance Reports

Link your portfolio holdings and use Dividend Data to automatically pull in current prices, dividend amounts, and YTD performance metrics. Combine this with your share counts to calculate total portfolio value, projected annual income, and overall yield. Automate your monthly or quarterly performance review reports.

Is there really a free plan?

Yes, for real! The free plan gives you 2,500 credits every single month, and it never expires. No credit card needed to start. It's perfect for individual investors doing periodic research. You're not getting a 7-day trial that forces you to pay; you get a permanently useful free tier.

How do I get started? Is it complicated?

Not at all. If you use Google Sheets, just install the add-on from the Google Workspace Marketplace. For Excel, get it from Microsoft AppSource. Once installed, a sidebar will appear, and you can start typing the =DIVIDENDDATA... formulas directly into your cells. No coding, no API key setup.

What's the difference between the Spreadsheet add-in and the Pro Terminal?

The Spreadsheet add-in is about getting data into your existing workflow (Sheets/Excel). The Pro Terminal is their full web application with advanced data visualizations, the AI Analyst for chat-based research, and automated portfolio tracking tools. They complement each other; many users start with the spreadsheets and upgrade to the Terminal for deeper analysis.

What counts as a "credit"?

A credit is typically used each time you call a formula that fetches new data. For example, using =DIVIDENDDATA_QUOTE("AAPL", "price") might cost 1 credit. Pulling a longer history might cost a few more. The system is designed so the 2,500 free credits are plenty for substantial individual use.