Dividend Data vs Pure Tax Investigations

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.

Expert Tax Dispute Resolution

Our team specializes in navigating complex tax disputes, ensuring that clients receive tailored strategies to resolve their tax issues efficiently and effectively.

Independent Representation

We act as an independent buffer between our clients and HMRC, providing a protective layer during investigations and compliance checks to safeguard our clients’ interests.

Comprehensive Tax Disclosure Services

We offer extensive services for tax disclosures, including the Worldwide Disclosure Facility (WDF) and Let Property Campaign (LPC), ensuring clients meet their obligations while minimizing potential penalties.

Experienced Team

Led by Amit Puri, our team consists of seasoned professionals with extensive knowledge of tax regulations and investigations, enabling us to deliver exceptional results for our clients.

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.

Handling Serious HMRC Investigations

Businesses facing serious investigations under COP8 or COP9 can rely on our expertise to navigate the complexities, ensuring their rights are protected throughout the process.

Managing Tax Compliance Checks

Our specialists assist clients with routine compliance checks, providing clear guidance to mitigate stress and ensure that all documentation and responses are appropriately managed.

Facilitating Tax Disclosures

We help clients voluntarily disclose historical income and gains through various campaigns, providing a structured approach to compliance that reduces the risk of penalties.

Advising on Complex Tax Matters

Entrepreneurs and businesses can consult with our experts for tailored advice on complex tax situations, including issues related to offshore assets and property rental profits.

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.

Pure Tax Investigations is a specialized service dedicated to providing expert tax dispute resolution and investigation services for businesses and entrepreneurs. We understand that navigating the complexities of tax regulations can be overwhelming, especially when dealing with HMRC investigations. Our team acts as a vital buffer, ensuring that our clients' interests are vigorously defended during compliance checks and tax inquiries. With a wealth of experience in handling cases under Code of Practice 8 (COP8) and Code of Practice 9 (COP9), we offer tailored solutions that alleviate the stress associated with tax disputes. Led by Amit Puri, an ex-HMRC senior Tax Inspector with over 20 years of expertise, we prioritize clarity and certainty in our approach. Our services also encompass tax disclosures, such as the Worldwide Disclosure Facility (WDF) and Let Property Campaign (LPC), providing comprehensive support to meet our clients' unique needs.

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.

What is Pure Tax Investigations?

Pure Tax Investigations offers expert services in tax dispute resolution and investigations for businesses and entrepreneurs, helping them navigate complex tax challenges.

How does Pure Tax Investigations support clients during HMRC investigations?

We act as an independent buffer, providing representation and tailored strategies to protect our clients' interests during tax investigations and compliance checks.

What types of tax disclosures do you handle?

We specialize in various tax disclosures, including the Worldwide Disclosure Facility (WDF) and the Let Property Campaign (LPC), ensuring compliance while minimizing penalties.

Who leads the team at Pure Tax Investigations?

The team is led by Amit Puri, an ex-HMRC senior Tax Inspector with over 20 years of experience, ensuring clients receive expert guidance and support throughout their tax inquiries.

Dividend Data is a specialized tool for fundamental and dividend investors, providing deep historical market data directly within spreadsheet platforms like Google Sheets and Excel. It falls into the category of financial data and analysis tools designed for individual investors and analysts. Users often explore alternatives for various reasons, such as budget constraints, the need for different data points, specific platform compatibility, or seeking a different pricing model like a one-time purchase versus a subscription. When evaluating other options, it's crucial to consider your core needs. Key factors include the depth and historical range of the financial data offered, the ease of integration with your existing workflow (especially within spreadsheets), the total cost relative to your usage, and whether the tool's features are built with a genuine understanding of fundamental and dividend investing strategies. The right solution should save you time and provide reliable data without unnecessary complexity.

Pure Tax Investigations is a specialized service dedicated to providing expert defense and tailored solutions for complex tax disputes and HMRC investigations. Primarily serving businesses and entrepreneurs, it falls under the category of tax dispute resolution and compliance support. Users frequently seek alternatives to Pure Tax Investigations for various reasons, including pricing considerations, specific features that may better suit their needs, or platform compatibility. When evaluating an alternative, it's essential to look for expertise in tax representation, the ability to provide customized advice, and a solid track record in handling compliance checks and disclosures.