Dividend Data

Forget clunky APIs, expensive terminals, and the endless copy-paste grind. Dividend Data is the battle-tested spreadsheet weapon built for one purpose: to give self-directed investors institutional-grade market intelligence without the institutional complexity or price tag. This is not just another data feed; it's a complete operational system designed by a dividend investor for fundamental analysts who live in Google Sheets and Microsoft Excel. The core value proposition is ruthless efficiency: you get instant, live access to over 30 years of historical data for 80,000+ tickers directly in your cells through simple, plain-English formulas. No coding, no API keys, no manual updates. Just type a function like =DIVIDENDDATA_DIVIDENDS("MSFT") and watch the forward dividend, yield, ex-date, or payout ratio populate instantly. It brings together dividends, yields, full financial statements, key ratios, earnings, and price history—over 100 metrics—transforming your spreadsheet from a static record into a dynamic, real-time research and portfolio tracking powerhouse. With a permanently free tier offering 2,500 monthly credits and seamless integration across both major spreadsheet platforms, Dividend Data democratizes high-quality financial data, empowering investors to make faster, more informed decisions with confidence.

Comprehensive Dividend Intelligence Engine

Go beyond basic yield. This feature delivers the deep, forward-looking data dividend investors crave. Access forward annual dividend amounts, yields, payout ratios, growth rates, and critical dates like ex-dividend and payment dates for any stock instantly. It's built specifically to analyze the sustainability and growth trajectory of income streams, putting professional-grade dividend analytics at your fingertips with a single formula.

Deep Historical Financials & Ratios

Conduct thorough fundamental analysis without leaving your spreadsheet. Pull in 30+ years of historical data from income statements, balance sheets, and cash flow statements. Instantly calculate and retrieve essential valuation and health metrics like P/E Ratio, Price-to-Book, Debt-to-Equity, and Return on Equity. This turns your sheet into a dynamic financial modeling platform, allowing for robust back-testing and trend analysis.

Live Price & Market Data Integration

Keep your portfolio tracking and valuation models perpetually up-to-date. With simple functions, pull real-time or delayed closing prices, market capitalization, and daily price history. This seamless integration ensures your net worth calculations, performance charts, and alert systems are always reflecting the live market, eliminating manual data entry errors and outdated information.

Universal Spreadsheet Compatibility

Why choose between ecosystems? Dividend Data delivers identical, powerful functionality in both Google Sheets and Microsoft Excel. Whether your team uses Google Workspace or your models are built in Excel, you get the same reliable formulas, data quality, and user experience. This flexibility ensures no investor is left behind and allows for seamless collaboration across different platforms.

Automated Dividend Portfolio Tracking

Manually updating a portfolio of income stocks is a tedious chore. Investors use Dividend Data to build a live dashboard that automatically tracks dividend payments, yields-on-cost, projected annual income, and ex-dividend calendars. This automates the entire monitoring process, providing a real-time view of portfolio income health and freeing up hours for analysis instead of data entry.

Screening and Building Watchlists

Quickly filter the universe of 80,000+ stocks based on precise, live criteria. Use the formulas to create dynamic screens for stocks meeting specific conditions, such as a P/E ratio under 20, a dividend yield above 3%, and a payout ratio below 60%. This allows investors to systematically identify new opportunities based on the latest data without relying on third-party screeners with limited metrics.

Streamlined Fundamental Research Reports

When analyzing a company for a potential investment, gathering data from multiple sources is inefficient. With Dividend Data, an investor can create a standardized research template in a spreadsheet. By simply entering a ticker symbol, the template auto-populates with decades of financials, key ratios, and dividend history, creating a comprehensive, consistent report in seconds.

Dynamic Financial Modeling & Projections

Build more accurate and responsive financial models. By linking valuation models directly to live data feeds for revenue, EPS, and growth rates, analysts can ensure their assumptions and projections are grounded in the latest reported figures. This creates living models that adjust as new quarterly data is released, providing a significant edge in investment thesis development.

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

Absolutely. The free tier is a permanent offering, not a limited trial. It provides 2,500 credits per month at no cost and with no credit card required. This is ample for most individual investors to track a portfolio, research several companies, and automate key data in their spreadsheets, making professional-grade analysis accessible to everyone.

How does Dividend Data compare to using free Yahoo Finance or Google Finance data?

While those sources are free, they are notoriously unreliable, inconsistent, and often lack the depth and history serious investors need. Dividend Data provides clean, standardized, and battle-tested data directly into your spreadsheet cells with 30+ years of history. You trade the fragility of web scraping and manual copying for robust, automated, and institutional-quality data feeds.

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

Not at all. Dividend Data requires zero coding knowledge. The entire system runs on simple, custom spreadsheet functions (like =DIVIDENDDATA_QUOTE("AAPL", "price")). If you know how to type a formula in Excel or Google Sheets, you can use all its features. There are no APIs to manage, authenticate, or troubleshoot.

Is my data secure and private?

Yes. Dividend Data operates with a strong commitment to privacy. Your spreadsheet data and portfolio holdings are not stored on their servers. The add-in fetches public market data based on the formulas you type. You maintain full control and ownership of your financial models and investment information at all times.