Dividend Data vs Pure Tax Investigations

Native Spreadsheet Integration

Dividend Data operates through dedicated add-ins for both Google Workspace and Microsoft Excel, embedding itself directly into the spreadsheet's function library. This deep integration allows users to call data using simple formulas like =DIVIDENDDATA_QUOTE("MSFT", "price"), creating a live link between the data source and the spreadsheet cell. It requires no external API key management within the sheet, maintaining a clean and secure user workflow. The add-ins are officially listed and rated on the Google Workspace Marketplace and Microsoft AppSource, ensuring compatibility and trust.

Extensive Financial & Dividend Data Library

The platform provides access to a deep historical database covering over 100 key metrics essential for fundamental analysis. This includes forward and historical dividends, ex-dividend dates, dividend growth rates, full financial statements (income, balance sheet, cash flow), earnings per share, and a wide array of profitability, valuation, and liquidity ratios. With 30+ years of data for 80,000+ tickers, users can perform longitudinal analysis and build robust financial models without sourcing data from multiple, disparate providers.

Formula-Driven Automation Engine

At its core, Dividend Data replaces manual data collection with automated formula functions. Users automate their spreadsheets by writing formulas that reference specific tickers and data points. Once set up, these formulas can refresh to pull in the latest data, ensuring that investment dashboards, screening models, and portfolio trackers remain current without any manual intervention. This feature is pivotal for eliminating the "copy-paste" workflow, reducing errors, and saving significant analytical time.

Multi-Platform Product Ecosystem

Beyond the spreadsheet add-ins, Dividend Data offers a complementary web application, the Dividend Data Terminal. This flagship product provides great data visualizations, AI-powered research tools, and automated portfolio tracking, creating a cohesive ecosystem. The spreadsheet add-ins serve as the data pipeline for quantitative modeling, while the Terminal offers enhanced analytical interfaces, demonstrating the platform's commitment to serving different facets of an investor's workflow across multiple compatible platforms.

Deep HMRC Protocol Integration

The platform is built with first-party integration into HMRC's core operational protocols, including Code of Practice 9 (COP9) for civil fraud, Code of Practice 8 (COP8) for complex enquiries, and various disclosure facilities. This ensures communication and procedural compatibility, allowing for efficient and technically correct handling of cases directly within HMRC's established framework, reducing friction and procedural errors.

Ex-HMRC Specialist Knowledge Base

Pure Tax Investigations operates on a proprietary knowledge base derived from its team of ex-HMRC senior personnel. This provides clients with insider-level understanding of HMRC's latest operational approaches, investigative tactics, and settlement negotiation algorithms, offering a significant strategic advantage in building a robust defence or disclosure.

Full-Spectrum Case Management Engine

The service features a comprehensive case management engine capable of handling the entire spectrum of tax disputes. This includes managing HMRC Information Notices, coordinating responses for Compliance Checks, structuring disclosures for campaigns like the Let Property Campaign (LPC), and preparing for Tax Tribunals, ensuring a seamless and unified defensive process from initial contact to resolution.

Proactive Disclosure and Risk Mitigation Modules

Beyond reactive defence, the platform includes modules designed for proactive risk management. It facilitates voluntary disclosures under facilities like the Worldwide Disclosure Facility (WDF) for offshore matters or for crypto tax enquiries, helping clients to correct historical positions, mitigate severe penalties, and avoid criminal investigation by interfacing correctly with HMRC's disclosure systems.

Automated Dividend Portfolio Tracking

Investors can build a live dividend portfolio tracker within Excel or Google Sheets. By using formulas to pull current prices, dividend yields, and annual payout data for each holding, they can create a dashboard that automatically calculates total portfolio value, projected annual income, and portfolio-level yield. This automates the monitoring process and provides real-time insight into income generation without manual updating.

Dynamic Stock Screening and Analysis

Fundamental investors can construct custom stock screens using the live data functions. For example, a user can build a sheet that screens for stocks with a dividend yield above 3%, a P/E ratio below 20, and a 5-year positive dividend growth rate. By refreshing the sheet, the screen updates with current data, allowing for the rapid identification of new investment opportunities that meet specific, quantitative criteria.

Historical Financial Model Building

Equity researchers and advanced investors can utilize the 30+ years of historical data to build detailed discounted cash flow (DCF) models or conduct trend analyses. They can pull historical revenue, EPS, and free cash flow directly into their model templates to analyze company performance across business cycles, create financial forecasts, and derive intrinsic value estimates based on deep historical datasets.

Educational and Research Modeling

Students, educators, and individual investors learning security analysis can use the tool to pull real-world data into their study models. Instead of working with static, outdated examples, they can build live models that calculate ratios, chart dividend history, or analyze financial statements for any public company, enhancing the practical learning experience with current market data.

Defence Against COP9 Civil Fraud Investigations

When a client receives a COP9 letter, indicating HMRC suspects serious tax fraud, Pure Tax Investigations provides the critical specialist interface. The team manages the entire Contractual Disclosure Facility (CDF) process, from the initial outline disclosure to detailed negotiations, leveraging deep protocol integration to seek the best possible civil settlement and avoid criminal prosecution.

Navigating Complex COP8 and Large Business Enquiries

For clients facing intricate, multi-faceted enquiries under COP8 or an extensive tax enquiry into a large business, the service deploys its specialist knowledge base to dissect HMRC's information requests. It ensures technically robust responses, challenges inappropriate enquiries, and uses mechanisms like Alternative Dispute Resolution (ADR) to resolve contentious points efficiently.

Managing Voluntary Tax Disclosures

Clients with undisclosed income, gains from offshore assets, Indian mutual funds, crypto activities, or property rental profits can utilise the platform's disclosure modules. Pure Tax Investigations ensures full compatibility with the correct HMRC disclosure facility (e.g., WDF, LPC), prepares the comprehensive disclosure package, and calculates liabilities to minimise penalties and secure finality.

Handling HMRC Compliance Checks and Information Notices

For routine but stressful HMRC compliance checks or formal Schedule 36 Information Notices, the service acts as a compliant buffer. It ensures all client communications and document productions are managed correctly, preventing over-disclosure or missteps that could escalate the enquiry, thereby containing the scope and pressure on the business or individual.

Dividend Data is a comprehensive financial data integration platform engineered to deliver institutional-grade stock market intelligence directly into the user's native spreadsheet environment. The core product is a suite of add-ins for Google Sheets and Microsoft Excel that eliminates the traditional friction of financial data acquisition. It provides seamless, formula-driven access to over 30 years of historical and real-time data for more than 80,000 global tickers. Designed specifically for dividend and fundamental investors, the system bypasses the need for complex API setups, manual coding, or error-prone copy-paste routines. Users simply employ custom spreadsheet functions, such as =DIVIDENDDATA_DIVIDENDS() or =DIVIDENDDATA_RATIOS(), to pull live data on dividends, yields, payout ratios, financial statements, valuation metrics, and price history directly into their models. Its architecture is built for compatibility and efficiency, offering a generous free tier with 2,500 monthly credits and sub-second average response times. This tech-stack oriented solution empowers investors to build dynamic, automated analysis and portfolio tracking systems within the tools they already use, democratizing access to deep financial data without the prohibitive cost or technical overhead typically associated with professional data feeds.

Pure Tax Investigations is a specialised, high-fidelity service platform engineered to act as a critical defensive layer between clients and HM Revenue & Customs (HMRC). It functions as an independent intermediary, built on a deep-stack integration with HMRC's operational protocols and investigative frameworks. The platform is designed for businesses, entrepreneurs, and private clients with complex tax affairs who are facing scrutiny, from routine compliance checks to serious civil fraud investigations under Code of Practice 9 (COP9) or Code of Practice 8 (COP8). Its core architecture leverages proprietary knowledge from ex-HMRC senior personnel, ensuring compatibility with the tax authority's internal processes and dispute resolution mechanisms. The primary value proposition is delivering certainty, resolution, and risk mitigation in high-stakes tax disputes by providing a seamless, expert-led interface that handles intrusive enquiries, facilitates voluntary disclosures, and navigates complex procedures like the Worldwide Disclosure Facility (WDF) or Alternative Dispute Resolution (ADR).

How does Dividend Data connect to my spreadsheet?

Dividend Data connects via official add-ins you install from the Google Workspace Marketplace (for Google Sheets) or Microsoft AppSource (for Excel). Once installed, it adds a custom set of functions to your spreadsheet's formula library. You simply type these formulas, like =DIVIDENDDATA_DIVIDENDS("TICKER"), and the add-in handles the data request and population securely in the background, with no coding required.

What is included in the free tier?

The free tier provides 2,500 credits per month that never expire, allowing you to use the spreadsheet functions extensively without a trial period cutoff. This is sufficient for many individual investors to track a portfolio and perform regular analysis. The tier includes access to the core 16+ custom functions for dividends, quotes, ratios, and metrics within the spreadsheet add-ins.

Does it work with both Google Sheets and Microsoft Excel?

Yes, Dividend Data is fully compatible with both major spreadsheet platforms. There is a dedicated Google Sheets add-on and a separate Microsoft Excel add-in. Both offer the same core functionality and formula syntax, allowing you to maintain consistent analysis workflows whether you use Google Workspace or Microsoft 365. The add-ins are independently listed and rated on their respective official stores.

What kind of data history is available?

The platform provides over 30 years of historical market data. This includes historical dividend payments, stock price history, and fundamental financial statement data (annual and quarterly). This deep historical dataset enables long-term trend analysis, backtesting of investment strategies, and the construction of financial models based on extensive historical performance.

What is the main advantage of using Pure Tax Investigations over a general accountant?

The core advantage is deep, system-level integration with HMRC's specialised investigative protocols. While a general accountant handles compliance, Pure Tax Investigations is engineered specifically for dispute resolution, built on ex-HMRC operational knowledge. This ensures technically precise navigation of high-stakes procedures like COP9, disclosures, and tribunals, which fall outside standard accounting support.

How does your service interface with HMRC during an investigation?

Our platform functions as the authorised intermediary. All direct communication with HMRC's specialist departments like the Fraud Investigation Service (FIS) or Customer Compliance Group is managed by our ex-HMRC specialists. This ensures all correspondence and submissions are formatted and processed within their expected operational frameworks, providing a seamless and compliant interface that protects the client.

Can you assist with disclosing historical offshore or crypto tax issues?

Yes. Our service includes dedicated modules for interfacing with HMRC's disclosure facilities. Whether it's the Worldwide Disclosure Facility (WDF) for offshore assets, specific campaigns for Indian interest income, or undisclosed crypto gains, we ensure full technical compatibility with the relevant HMRC system, prepare the comprehensive disclosure, and negotiate the optimal penalty mitigation terms.

What happens if my case escalates to a Tax Tribunal?

Our full-spectrum case management engine covers tribunal preparation and representation. We leverage our deep understanding of HMRC's litigation strategy and procedural requirements to build a robust case, prepare all necessary documentation, and instruct specialist tax counsel, ensuring your defence is presented in a technically sound and compelling manner to the tribunal.

Dividend Data is a specialized financial data add-on that delivers institutional-grade dividend and fundamental stock metrics directly into spreadsheet cells. It falls into the category of direct spreadsheet integration tools, designed to bypass complex APIs and manual data entry for investors. Users often explore alternatives for several key reasons. These include budget constraints, where subscription costs may not align with individual needs, or specific feature gaps, such as a requirement for different financial metrics, deeper historical data, or compatibility with other analysis platforms like Python or dedicated portfolio software. The need for a different pricing model, like one-time purchase versus subscription, is also a common driver. When evaluating other solutions, focus on core technical compatibility: does it integrate natively with your primary spreadsheet environment (Google Sheets, Excel, or both)? Assess the depth and breadth of the historical financial data offered, the simplicity of the formula or query syntax, and the transparency of the pricing structure. The ideal tool should fit seamlessly into your existing tech stack and workflow without creating new complexities.

Pure Tax Investigations is a specialised service platform within the business and finance category, engineered to provide robust defense and disclosure management for complex HMRC tax disputes. It functions as an expert intermediary, integrating directly with HMRC's operational protocols to deliver certainty and resolution. Users may explore alternative solutions due to varying requirements around pricing structures, specific feature sets, or different levels of platform integration needed for their unique tax affairs. The need for a different service stack compatibility or a more tailored advisory approach can also drive this evaluation. When assessing an alternative, key considerations should include the depth of its HMRC protocol integration, the provenance and expertise of its specialist team, and the platform's capability to handle the full spectrum from voluntary disclosures to serious civil fraud investigations. The technical architecture and defensive strategy alignment are critical for optimal outcomes.