Dividend Data vs Pure Tax Investigations

Comprehensive Spreadsheet Functions

Dive deep into your analysis with 16 purpose-built custom functions that cover every essential aspect for a dividend and fundamental investor. From DIVIDENDDATA_DIVIDENDS to fetch forward yield and ex-dividend dates, to DIVIDENDDATA_RATIOS for PE Ratios and DIVIDENDDATA_METRICS for diluted EPS, these formulas act as your direct conduit to live data. Simply type them into any cell to instantly pull and refresh information, turning a static spreadsheet into a live, connected financial dashboard without any coding required.

Vast Historical & Real-Time Data Library

Satisfy your curiosity with an expansive database featuring 30+ years of historical market data across 80,000+ global tickers. This feature allows you to backtest investment theories, analyze long-term dividend growth trends, and examine financial ratios over full market cycles. Whether you're investigating a company's payout consistency through recessions or its earnings trajectory, you have decades of context at your fingertips, all accessible within seconds directly in your spreadsheet.

Dual-Platform Compatibility

Explore and analyze without constraints, as Dividend Data seamlessly integrates with both Google Sheets and Microsoft Excel. This flexibility means you can collaborate on a cloud-based Sheets document with a team or conduct deep, complex modeling in your desktop Excel application, all while using the same familiar formulas and accessing the identical, robust dataset. It ensures your workflow remains uninterrupted, regardless of your preferred spreadsheet environment.

Free Tier with Generous Monthly Credits

Begin your data exploration journey immediately with a free tier that provides 2,500 credits every month, with no trial period expiration. This allows you to thoroughly test the platform's capabilities, run numerous queries, and integrate data into your models without any upfront financial commitment. It’s an open invitation to experiment and discover how automated data can enhance your investment research process.

Specialist-Led Defence Strategy

At the heart of Pure Tax Investigations is a team led by ex-HMRC senior inspectors, offering an unparalleled insider perspective. This isn't just about knowing tax law; it's about understanding how HMRC investigators think, operate, and build their cases. This deep, operational knowledge allows the team to craft pre-emptive and responsive defence strategies that are both robust and pragmatic, anticipating HMRC's moves and effectively countering them to protect the client's position.

Comprehensive Investigation Management

The service provides end-to-end management of the entire investigation process, acting as the sole point of contact with HMRC. This includes handling all correspondence, preparing detailed responses to information notices, analysing complex financial records, and representing the client in meetings. By taking on this burden, they create a vital protective barrier, shielding clients from the day-to-day stress and allowing them to focus on running their business while experts handle the dispute.

Proactive Tax Disclosure Guidance

Beyond reactive defence, Pure Tax Investigations proactively guides clients through voluntary disclosure facilities to regularise their tax affairs before HMRC intervenes. This includes specialist support for the Worldwide Disclosure Facility (WDF), Let Property Campaign (LPC), and disclosures for crypto assets, offshore income, and Indian mutual funds. This forward-looking approach can often mitigate penalties and avoid the more severe consequences of a full HMRC investigation.

Bespoke Client-Centric Approach

Rejecting a one-size-fits-all methodology, the firm takes a deeply personalised approach. They begin by listening intently to understand the client's specific circumstances, commercial aspirations, and concerns. Each case is then evaluated individually, with advice and strategy tailored to the unique nuances of the business, the individual, and the specific tax issue at hand, ensuring solutions are as effective and commercially sensible as they are technically sound.

Building a Dividend Growth Screener

Curious about which companies have not only paid but consistently grown their dividends? You can build a powerful screening model directly in your spreadsheet. Use functions to pull dividend growth rates, payout ratios, and yield history for thousands of stocks. Automate the process to filter and rank companies that meet your specific criteria for sustainable dividend growth, creating a dynamic watchlist that updates with fresh data.

Conducting Deep Fundamental Analysis

When you're researching a potential investment, you need more than just a price quote. Use Dividend Data to pull complete financial statements, calculate key valuation and profitability ratios, and assess debt levels. Create a comprehensive analysis sheet for any ticker, linking cells to live data for revenue, earnings, book value, and cash flow, enabling a thorough, up-to-date fundamental review without leaving your spreadsheet.

Automated Portfolio Monitoring and Reporting

Imagine having a portfolio tracker that updates itself. By linking your holdings to Dividend Data's functions, you can automatically pull current prices, dividend announcements, and yield-on-cost for each position. Aggregate this data to see your portfolio's total income, overall valuation changes, and sector exposure in real-time, transforming a simple list of stocks into a dynamic performance dashboard.

Historical Backtesting of Investment Strategies

What would a strategy based on low PE ratios and high dividend yields have returned over the past 20 years? With access to 30+ years of historical data, you can backtest quantitative strategies directly in Excel or Sheets. Pull historical prices, dividends, and financial metrics for relevant periods to model returns and risk, allowing you to explore the historical efficacy of your investment hypotheses with concrete data.

Navigating a Code of Practice 9 (COP9) Investigation

When a business owner or entrepreneur receives a COP9 letter from HMRC, it signals a suspicion of serious tax fraud. This is a critical juncture requiring expert navigation. Pure Tax Investigations steps in to manage this high-stakes process, guiding the client through the contractual disclosure facility (CDF) process, ensuring a robust defence is mounted, and working tirelessly to achieve a civil settlement over a criminal prosecution, thereby protecting the client's future.

Regularising History via the Worldwide Disclosure Facility

An individual with previously undisclosed offshore income or gains discovers the need to become compliant. The complexities of the Worldwide Disclosure Facility (WDF) can be overwhelming. Here, Pure Tax Investigations provides a structured pathway, calculating historical liabilities, preparing the disclosure report, negotiating with HMRC on the client's behalf, and aiming to minimise penalties for the voluntary correction, bringing long-standing issues to a close.

Defending a Large Business Compliance Check

A large corporation faces a comprehensive, cross-tax enquiry from HMRC's Customer Compliance Group. These investigations are vast, intrusive, and resource-intensive. The firm deploys its specialist team to manage the entire process, from responding to broad information requests and analysing complex transaction trails to defending the company's tax positions and engaging in negotiations to reach a commercial resolution without disproportionate disruption.

Managing a Let Property Campaign Disclosure

A landlord with multiple rental properties has not fully declared rental profits or claimed expenses correctly. The Let Property Campaign (LPC) offers a chance to disclose this voluntarily. Pure Tax Investigations assists by reviewing all property income and expenses, calculating the tax owed for up to 20 years, preparing the formal disclosure, and liaising with HMRC to settle the matter efficiently, often under more favourable terms than if HMRC had discovered it first.

What if you could transform your familiar spreadsheet into a dynamic, real-time research terminal? Dividend Data does exactly that, unlocking a world of institutional-grade financial data with the simplicity of a custom formula. Built by a dividend investor for like-minded analysts, this powerful tool brings over 30 years of historical and current market data for more than 80,000 tickers directly into your Google Sheets or Microsoft Excel workspace. Imagine no longer needing to manually copy-paste figures, hunt for API keys, or write a single line of code. The core magic lies in its custom functions; you simply type a formula like =DIVIDENDDATA_DIVIDENDS("MSFT") and watch as live data on dividends, yields, and payout ratios instantly populates your cell. It’s designed for the fundamental investor who craves depth—offering access to dividends, financial statements, earnings, key ratios, price history, and over 100 other metrics—but without the intimidating complexity or cost typically associated with professional data feeds. With a generous free tier offering 2,500 monthly credits that never expire, Dividend Data invites you to start exploring the markets with a curious, data-driven mindset right from your most trusted analytical environment.

What happens when the complex world of tax compliance intersects with the intense scrutiny of an HMRC investigation? Pure Tax Investigations exists to navigate that precise, often daunting, intersection. This premier service is not just about generic advice; it's a dedicated defence unit for businesses and entrepreneurs facing the full spectrum of tax disputes. Acting as an independent, expert buffer, the firm's core mission is to relieve clients from the immense pressure of investigations, providing clarity and a robust strategic defence. But what makes their approach so distinct? It's a deep, insider understanding of HMRC's methodologies, particularly in serious civil investigations like Code of Practice 9 (COP9) and Code of Practice 8 (COP8). Led by Amit Puri, a former HMRC senior tax inspector with over two decades of experience, the team offers a pragmatic, tailored analysis of each client's unique situation. From managing intricate compliance checks and R&D tax enquiries to guiding clients through voluntary disclosures for offshore assets, crypto, or property income, Pure Tax Investigations transforms a process fraught with uncertainty into a managed pathway toward resolution, aiming to preserve wealth and provide ultimate peace of mind.

How do I get started with Dividend Data?

Getting started is a simple exploration. For Google Sheets, install the add-on from the Google Workspace Marketplace. For Microsoft Excel, get the add-in from Microsoft AppSource. Once installed, you can immediately start using the custom functions like =DIVIDENDDATA_QUOTE("AAPL", "price") in your spreadsheets. No API key configuration is needed, and your free monthly credits are available right away.

What is included in the free tier?

The free tier is designed for curious investors to begin their discovery. It includes 2,500 credits per month, which never expire, allowing you to make a substantial number of data queries. You get full access to all 16 custom functions and the vast database of historical and current data, enabling significant analysis without any cost. It's a fully-featured introduction to the platform's capabilities.

What kind of data can I access?

Your curiosity can span a wide range of financial data. You have instant access to dividend-specific information (amounts, yields, dates, growth), real-time quotes, over 30 years of price history, complete financial statements (income, balance sheet, cash flow), and key fundamental ratios (P/E, P/B, Debt/Equity). In total, you can explore over 100 different metrics for more than 80,000 global stocks and ETFs.

Does the data update automatically in my spreadsheet?

Yes, the data is designed to be live and refreshable. When you open a spreadsheet containing Dividend Data formulas, the cells will typically update to show the most current information available. You can also manually recalculate or refresh the sheet to pull the latest data, ensuring your analysis always reflects the current market conditions and company fundamentals.

What is the main benefit of using a specialist like Pure Tax Investigations over my regular accountant?

While your accountant is vital for compliance, a tax investigation specialist operates in the distinct arena of dispute and defence. Pure Tax Investigations brings focused expertise in HMRC's investigation tactics, deep knowledge of specialist procedures like COP9, and a dedicated advocacy role. They act as an independent shield, managing the conflict directly with HMRC, which allows your accountant to maintain their ongoing advisory relationship while the specialists handle the high-pressure dispute.

How does your experience as ex-HMRC inspectors benefit my case?

This insider experience is invaluable. It means the team understands the internal processes, priorities, and pressures within HMRC. They can interpret the subtext of HMRC's requests, anticipate the next steps in an investigation, and craft responses and strategies that are effective within the framework HMRC uses. This perspective allows for more pragmatic and often faster resolutions, as communication is strategic and informed by first-hand operational knowledge.

What should I do immediately if I receive a letter from HMRC opening an investigation?

Do not ignore it or respond immediately without specialist advice. Contact a firm like Pure Tax Investigations straight away. An early, expert assessment is crucial. The specialists can review the letter's scope and language, advise you on your rights and obligations, and ensure any initial response is carefully considered to protect your position. Taking prompt, informed action can prevent missteps that might complicate the investigation later on.

Are your services only for serious fraud cases under COP9?

Absolutely not. While they are experts in the most serious civil investigations like COP9 and COP8, their services span the full spectrum of tax disputes. This includes routine compliance checks, enquiries into R&D claims, inheritance tax investigations, disputes over tax avoidance schemes, and managing Alternative Dispute Resolution (ADR) or Tax Tribunal appeals. They provide robust defence and management for any formal HMRC challenge to your tax affairs.

Dividend Data is a specialized tool that brings decades of stock market and dividend information directly into your spreadsheet. It falls into the category of financial data platforms designed for self-directed, fundamental investors who prioritize ease of use and deep historical analysis. Users often explore other options to find a solution that perfectly aligns with their budget, the specific metrics they track, or whether they primarily use Excel versus Google Sheets. The search for an alternative is a natural part of the discovery process. You might be evaluating different pricing models, seeking a particular dataset not currently offered, or require integration with other software in your investment workflow. It's a smart way to ensure the tool you choose is the best fit for your unique strategy and technical environment. When comparing options, focus on the core elements that matter most to your research. Consider the depth and reliability of the historical data, the simplicity of accessing it within your preferred spreadsheet platform, and the total cost relative to your usage. The ideal alternative will feel like a seamless extension of your investment process, providing trustworthy data without complexity.

Pure Tax Investigations is a specialized service in the business and finance sector, focusing on resolving complex tax disputes and managing HMRC investigations for companies and entrepreneurs. Their expertise lies in acting as a dedicated, independent buffer between clients and tax authorities. People often explore alternatives for various reasons. They might be seeking a different pricing model, a firm with a specific regional focus, or a service that aligns more closely with their company's size or industry niche. The need for a particular technological platform or a different approach to client communication can also spark this curiosity. When evaluating other options, it's wise to consider the depth of direct HMRC experience on the team, the range of specific disclosure facilities they handle, and their approach to personalized service. Understanding their process for ongoing risk assessment and how they provide clarity during stressful investigations is equally crucial.