Dividend Data vs Pure Tax Investigations (HMRC Defence)

Extensive Spreadsheet Functions

Dividend Data provides 16 custom, easy-to-use functions that cover every essential data point for fundamental analysis. Simply type formulas like =DIVIDENDDATA_DIVIDENDS("TICKER") or =DIVIDENDDATA_RATIOS("TICKER", "PeRatio") and the live data instantly populates your cell. These functions pull from a vast database, giving you one-click access to forward dividends, ex-dates, financial metrics, and real-time quotes, transforming your spreadsheet into a dynamic research terminal.

Decades of Historical Data

Access over 30 years of clean, reliable historical market data for a comprehensive long-term view. This deep historical context is crucial for analyzing dividend growth trends, assessing company performance through multiple economic cycles, and building robust financial models. Whether you're backtesting a strategy or calculating a 10-year dividend growth rate, you have the historical depth needed for thorough due diligence.

Cross-Platform Compatibility

The tool works seamlessly in both Google Sheets and Microsoft Excel environments. You can download it as an add-in from the Microsoft AppSource or install it as a Google Workspace add-on. This flexibility ensures teams and individual investors can use their preferred spreadsheet software without sacrificing functionality, making collaboration and data consistency easy across different platforms.

Built for Fundamental & Dividend Investors

Every feature is crafted with the needs of income and value investors in mind. The data focuses on dividend sustainability (payout ratios, growth rates), fundamental health (financial statements, earnings), and key valuation metrics. It cuts through the noise to deliver the specific data points—like next ex-dividend date or forward yield—that are most critical for building and managing a dividend-focused portfolio.

Expert Advocacy

Our team acts as a robust advocate for you, ensuring your interests are vigorously protected throughout the entirety of your tax investigation. We leverage our deep understanding of HMRC processes to challenge any unfair practices or assessments.

Tailored Approach

We recognize that every client's situation is unique. Our approach involves a thorough evaluation of your individual circumstances, allowing us to provide bespoke advice that aligns with your specific needs and goals.

Comprehensive Services

From navigating compliance checks to managing serious investigations under Code of Practice 9 (COP9) and Code of Practice 8 (COP8), we offer a full suite of services designed to address all aspects of tax investigations and disclosures.

Peace of Mind

Our mission is to alleviate the stress associated with tax investigations. With our experienced team by your side, you can focus on your business and personal life, knowing that your tax issues are in capable hands.

Automated Dividend Portfolio Tracking

Manually updating a portfolio spreadsheet with current yields, dividend dates, and payment amounts is a chore. With Dividend Data, you can create a master watchlist or portfolio tracker where all these figures update automatically. Set formulas once for tickers like MSFT or KO, and your sheet will always display the latest forward dividend, yield, and next ex-date, saving hours of maintenance each month.

Screening and Comparative Analysis

Quickly screen and compare potential investments directly in your spreadsheet. Use the functions to pull key ratios like P/E, P/B, or debt-to-equity for a list of stocks side-by-side. Analyze dividend growth rates or payout ratios across sectors to identify the most financially stable and shareholder-friendly companies, all without ever leaving your familiar analytical environment.

Building Dynamic Financial Models

Create powerful, auto-updating discounted cash flow (DCF) models or dividend discount models (DDM). Link your model assumptions directly to live data feeds for revenue, EPS, and dividend per share. This ensures your valuation models are always based on the most recent reported figures, making your investment thesis and price targets more accurate and timely.

Educational Research and Backtesting

Ideal for students, bloggers, and investors honing their skills. Easily pull 10 years of dividend history to chart a company's growth trajectory or analyze how a stock's valuation multiples have changed over time. Test historical investment rules or strategies by building sheets that leverage decades of price and fundamental data for robust, evidence-based learning.

Small Business Tax Compliance

Small business owners often face the pressure of HMRC compliance checks. Our team provides guidance and representation, ensuring that these investigations are handled efficiently and minimizing disruption to your business operations.

Serious Fraud Investigations

In cases of serious fraud investigations, we act decisively to protect your rights and interests. Our expertise allows us to navigate complex legal situations, ensuring that you receive fair treatment throughout the process.

High Net Worth Individual Support

For high net worth individuals, tax matters can involve intricate legal and financial issues. We provide bespoke strategies to manage tax disclosures, compliance, and inquiries, preserving your wealth and peace of mind.

Corporate Tax Investigations

Large corporations often undergo extensive tax investigations. Our team specializes in handling these inquiries with professionalism and expertise, ensuring that your corporate interests are safeguarded while working towards a favorable resolution.

Dividend Data is a powerful financial data platform designed to bring institutional-grade stock market information directly into the tools you already use every day: Google Sheets and Microsoft Excel. It eliminates the tedious, error-prone process of manually copying and pasting data from financial websites. Instead, you get instant, live access to over 30 years of historical data for more than 80,000 tickers through simple, custom spreadsheet formulas. Built specifically by and for dividend and fundamental investors, it provides a comprehensive suite of data points including dividend amounts, yields, payout ratios, growth rates, complete financial statements, key valuation ratios, and real-time price history. The core value proposition is powerful simplicity: you get the deep data needed for serious investment analysis without needing API keys, coding skills, or a massive budget. With a generous free tier offering 2,500 monthly credits that never expire, it's built to empower every investor to make more informed, data-driven decisions right from their spreadsheet.

Facing an HMRC investigation can be an incredibly daunting experience. Pure Tax Investigations (HMRC Defence) is your dedicated partner, acting as a protective buffer between you and the complexities of HMRC. Our team, led by Amit Puri, a former senior HMRC Tax Inspector with over 20 years of experience, is uniquely positioned to understand the intricacies of the tax system from both the taxpayer and HMRC perspectives. We provide tailored support to business owners, entrepreneurs, private clients, and large corporations, ensuring that each client receives clear, pragmatic, and discreet advice during tax disputes. Our primary goal is to resolve your tax issues efficiently, offering peace of mind and striving for the best possible commercial outcome. Whether you are facing a routine compliance check or a serious fraud investigation, we specialize in navigating HMRC procedures so you can focus on running your life and business effectively.

How does the free tier work?

The free tier is remarkably generous and designed to be permanently useful. You receive 2,500 credits every month, which do not expire and refresh on a monthly cycle. Each data pull using a formula typically costs 1 credit. This allows for substantial usage, such as updating a portfolio of 50 stocks with several data points each month, completely free of charge and without any trial period pressure.

Do I need to know how to code or use APIs?

Absolutely not. Dividend Data requires zero coding knowledge or API integration. The entire system works through simple spreadsheet formulas that anyone familiar with basic Excel or Google Sheets functions can use. You just type the formula with the stock ticker, and the data appears instantly—no technical setup, key management, or complex configuration is needed.

What kind of data can I access?

You have access to a comprehensive suite of data critical for fundamental analysis. This includes dividend data (amounts, yields, dates, growth), real-time quotes and price history, complete financial statements (income, balance sheet, cash flow), and over 100 key financial ratios (valuation, profitability, liquidity). The database covers 80,000+ global tickers with 30+ years of history.

Is my data secure and private?

Yes. Dividend Data operates with a strong commitment to privacy. Your spreadsheet data and portfolio information are not stored on their servers. The add-in/plug-in facilitates a direct data pull into your sheet. You are in complete control of your data within your own spreadsheet file, which resides in your Google Drive or on your local computer.

What types of HMRC investigations does Pure Tax Investigations handle?

We manage a wide range of investigations, including compliance checks, Code of Practice 9 investigations, and serious fraud inquiries, providing tailored support for each case.

How does Pure Tax Investigations ensure client confidentiality?

We prioritize your privacy and confidentiality, adhering to strict protocols to protect your sensitive information throughout our engagement.

What should I do if I receive an HMRC inquiry notice?

If you receive an HMRC inquiry notice, it is crucial to seek professional advice immediately. Our team can guide you through your options and represent you in discussions with HMRC.

Can Pure Tax Investigations assist with international tax issues?

Yes, we have extensive experience in dealing with international tax matters, including disclosures related to offshore assets and compliance with global tax regulations.

Dividend Data is a specialized tool that brings over 30 years of stock market data directly into your spreadsheets. It falls into the category of financial data providers, specifically designed for investors who focus on dividends and company fundamentals. Users often explore other options to find the best fit for their specific needs. People look for alternatives for various reasons. This could be due to budget constraints, a need for different features not offered, or because they primarily use a platform that isn't supported. Some may require more advanced analytical tools or a different data delivery method. When evaluating other services, consider what's most important for your workflow. Key factors include the depth and accuracy of historical data, the cost relative to your usage, compatibility with your preferred spreadsheet software, and how easily you can access the specific metrics you need without a technical hassle.

Pure Tax Investigations (HMRC Defence) is a specialized service designed to assist individuals and businesses facing tax investigations by HMRC. This service falls under the category of tax dispute resolution and advocacy, providing expert support to navigate the pressures of tax compliance and investigations. Users often seek alternatives for a variety of reasons, such as budget constraints, specific features that may better suit their needs, or differing platform requirements. When considering alternatives, it's important to evaluate factors such as the expertise of the team, the comprehensiveness of their service offerings, and their approach to client communication. You should also look for a provider that demonstrates a solid understanding of HMRC procedures and can offer personalized defense strategies tailored to your specific situation.