Dividend Data vs Pure Tax Investigations

Extensive Custom Spreadsheet Functions

Dividend Data provides a specialized library of 16+ custom functions, such as DIVIDENDDATA_DIVIDENDS and DIVIDENDDATA_RATIOS, that act as direct conduits to live financial data. Users simply type these formulas into any cell, referencing a stock ticker and desired metric, and the platform instantly populates the cell with accurate, updated information. This transforms static spreadsheets into dynamic, auto-updating financial dashboards, covering everything from forward dividend yields and ex-dates to P/E ratios and diluted EPS.

Deep Historical & Fundamental Data Library

The platform grants users access to a vast repository of over 30 years of historical market data. This is not limited to price history but extends deeply into fundamental analysis, including decades of dividend payments, annual and quarterly financial statements, and hundreds of key financial ratios. This long-term perspective is crucial for conducting thorough trend analysis, assessing a company's financial resilience through cycles, and building robust valuation models based on historical performance.

Multi-Platform Spreadsheet Integration

A key operational feature is its seamless compatibility with both Google Sheets and Microsoft Excel. Users are not locked into a single ecosystem; they can leverage Dividend Data's capabilities within their preferred spreadsheet environment. The add-ins are officially available on the Google Workspace Marketplace and Microsoft AppSource, ensuring easy installation, secure operation, and smooth performance whether working in the cloud with Sheets or locally with Excel.

AI-Powered Research & Portfolio Tools

Beyond spreadsheets, Dividend Data offers a web-based Terminal featuring advanced tools like an AI Analyst. This assistant can answer complex investment questions, generate research reports, and provide insights based on the platform's extensive dataset. Coupled with automated portfolio tracking that aggregates holdings, calculates projected income, and visualizes performance, it creates a holistic research and management suite for the modern investor.

Tailored Tax Investigation Services

Pure Tax Investigations provides bespoke services tailored to the unique needs of each client. This personalized approach ensures that the complex nature of individual tax affairs is skillfully managed, allowing clients to focus on their core business activities.

Expert Team with Insider Knowledge

The team at Pure Tax Investigations comprises seasoned professionals, including former HMRC officials. Their extensive experience and insider knowledge of HMRC procedures equip them to navigate complex tax investigations effectively, making them invaluable allies during disputes.

Comprehensive Support for Various Tax Issues

From Code of Practice investigations to compliance checks, Pure Tax Investigations offers comprehensive support across a wide range of tax issues. They handle everything from voluntary disclosures to tax enquiries into large businesses, ensuring that clients receive the best possible guidance.

Focus on Client Peace of Mind

Understanding the stress associated with tax investigations, Pure Tax Investigations prioritizes client peace of mind. They work diligently to provide clarity and assurance throughout the investigation process, allowing clients to regain control of their financial situations.

Building a Dividend Growth Screening Model

Investors focused on dividend growth can use Dividend Data to create a powerful screening spreadsheet. By using functions to pull dividend growth rates, payout ratios, and earnings history for thousands of stocks, they can instantly filter for companies with a history of consistent, sustainable dividend increases. This automates the initial discovery phase, allowing for rapid identification of candidates that meet specific criteria for further due diligence.

Automating Monthly Portfolio Income Reports

For income-focused investors, manually tracking dividend payments across a portfolio is tedious. With Dividend Data, users can build a master portfolio sheet where each holding's ticker automatically pulls the next ex-dividend date, payment date, and declared dividend amount. This sheet can then forecast monthly and annual income, update live, and provide a clear, always-current view of cash flow expectations without any manual data entry.

Conducting Comparative Fundamental Analysis

Analysts and serious investors can perform deep-dive comparisons between companies. By using functions to pull side-by-side data on metrics like ROE, debt-to-equity, profit margins, and valuation multiples, they can build comprehensive comparison tables. The 30+ years of data allow for analyzing how these metrics have evolved over time, providing context that is essential for determining relative strength and long-term operational efficiency.

Creating Dynamic Financial Dashboards

Financial educators, bloggers, or investment club leaders can use Dividend Data to create interactive dashboards. They can build sheets that display key real-time stats for a watchlist, such as current price, dividend yield, and P/E ratio, which refresh automatically. This turns a simple spreadsheet into a live monitoring tool, perfect for presentations, educational content, or keeping a group informed with up-to-the-minute data.

Handling Complex Civil Investigations

Businesses undergoing serious civil investigations under COP9 or COP8 can rely on Pure Tax Investigations to provide expert guidance and representation, ensuring their interests are robustly defended.

Navigating Tax Disclosures

Clients needing to make voluntary disclosures under initiatives like the Worldwide Disclosure Facility (WDF) can trust Pure Tax Investigations to navigate the complexities of the process, minimizing risks and ensuring compliance.

Representing Large Corporations

Large businesses facing tax enquiries benefit from the firm’s extensive experience in handling intricate tax matters. Pure Tax Investigations offers strategic advice to mitigate risks and achieve favorable outcomes.

Supporting Private Clients in Tax Matters

Pure Tax Investigations assists private clients with various tax-related concerns, including inheritance tax and property taxes. Their tailored approach ensures that each client's unique situation is addressed comprehensively.

Dividend Data is a powerful financial data platform designed to democratize access to institutional-grade stock market information. At its core, it is a spreadsheet add-in that seamlessly integrates over 30 years of historical and real-time data for more than 80,000 tickers directly into Google Sheets and Microsoft Excel. The product eliminates the traditional barriers of complex APIs, coding requirements, and manual copy-pasting, delivering data through simple, custom formulas. Built specifically by and for dividend and fundamental investors, it provides instant access to a comprehensive suite of metrics including dividend histories, yields, payout ratios, growth rates, complete financial statements, earnings reports, valuation ratios, and price action. Its unique value proposition lies in its unparalleled ease of use combined with deep, reliable data, offering a professional analysis toolkit at a fraction of the cost of institutional terminals. With a generous free tier and robust paid plans, it serves both individual retail investors and professional analysts who seek to make informed, data-driven investment decisions without the steep learning curve or exorbitant price tag.

Pure Tax Investigations is a leading specialist firm focused on resolving intricate and high-stakes tax disputes that arise between businesses, entrepreneurs, and private clients with HM Revenue & Customs (HMRC). The firm serves as an independent expert buffer, delivering robust defense and strategic guidance during some of the most stressful financial challenges clients may encounter. Their mission is to alleviate pressure, provide certainty, and secure optimal commercial outcomes for clients. Under the leadership of Amit Puri, a former senior HMRC Tax Inspector with over two decades of expertise, the team offers invaluable insights into HMRC's operational methodologies. This insider perspective is essential for navigating serious civil investigations, such as Code of Practice 9 (COP9) for suspected fraud and Code of Practice 8 (COP8) for complex tax avoidance. Pure Tax Investigations prides itself on a tailored and pragmatic approach, blending deep technical knowledge with a clear understanding of clients' personal and commercial aspirations, ultimately working to preserve wealth and deliver peace of mind.

How does the free tier work and what are credits?

The free tier provides 2,500 credits per month that never expire, with no credit card required to start. Each data request made via a spreadsheet function consumes a small number of credits (typically 1-2 per call). This generous allowance allows users to perform substantial analysis and automation for free. It's designed to let investors fully test the platform's capabilities in their real-world workflows without a time-limited trial.

What kind of data can I access with the spreadsheet functions?

You can access a vast array of data points spanning dividends, quotes, fundamentals, and ratios. Specific examples include forward and historical dividend amounts/yields, ex-dividend and payment dates, current stock price, 30+ years of price history, complete financial statement items (revenue, EPS, cash flow), and over 100 pre-calculated financial ratios like P/E, P/B, and ROIC. The documentation provides a full list of all available metrics for each function.

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

Absolutely not. Dividend Data is built specifically to require zero coding or technical setup. There are no API keys to manage. After installing the add-in from the Google Workspace or Microsoft AppSource store, you simply use the provided custom formulas directly in your spreadsheet cells as you would any native function like =SUM(). The complexity of data sourcing and management is handled entirely in the background.

Is my data and portfolio information secure?

Yes. Dividend Data takes security seriously. The connection between your spreadsheet and their servers is secure. When using the portfolio tracking features in the Pro Terminal, your holdings data is stored privately. The company has a clear privacy policy and terms of use. Furthermore, as an official add-in listed on Google and Microsoft's marketplaces, it adheres to these platforms' security and compliance standards.

What types of tax disputes does Pure Tax Investigations handle?

Pure Tax Investigations specializes in a wide range of tax disputes, including civil investigations under COP9 and COP8, tax enquiries into large businesses, and voluntary disclosures.

How does the firm ensure a tailored approach for each client?

The firm takes the time to listen to each client's unique circumstances and aspirations, allowing them to develop bespoke strategies that align with individual needs and objectives.

Who leads the team at Pure Tax Investigations?

The team is led by Amit Puri, a former senior HMRC Tax Inspector with over 20 years of experience, providing clients with invaluable insights into HMRC's methodologies and strategies.

What is the firm’s approach to client communication during investigations?

Pure Tax Investigations prioritizes clear and open communication, ensuring that clients are kept informed and supported throughout the investigation process to alleviate stress and enhance understanding.

Dividend Data is a specialized financial data tool that provides extensive dividend and fundamental stock information directly within spreadsheet applications like Google Sheets and Excel. It falls into the category of self-service investment research platforms, designed to empower individual investors with deep, historical data sets. Users often explore alternatives for various reasons. Some may have specific budget constraints or require a different pricing model, while others might need features tailored to different investment strategies, such as technical analysis or real-time alerts. Platform compatibility is another key factor, as some investors prefer web-based dashboards, mobile apps, or integration with other software beyond spreadsheets. When evaluating other options, consider the depth and historical range of the data offered, the ease of access and integration into your existing workflow, and the overall cost relative to the value provided. The ideal solution should align with your primary investment methodology, whether it's dividend growth, value investing, or broader market analysis, without unnecessary complexity or expense.

Pure Tax Investigations is a specialist firm focused on resolving complex tax disputes between businesses and HM Revenue & Customs (HMRC). As a leading authority in tax investigations, they provide expert defense and strategic guidance, ensuring clients navigate the intricacies of HMRC processes effectively. Users often seek alternatives for various reasons, including pricing considerations, specific feature sets that align better with their needs, or platform compatibility. When assessing alternatives, it's crucial to examine the firm's expertise in tax law, the level of personalized service provided, and the track record of successful outcomes in similar cases.