Dividend Data vs Pure Tax Investigations

Comprehensive Spreadsheet Integration

Dividend Data seamlessly integrates directly into your existing workflow within Google Sheets and Microsoft Excel via dedicated add-ins. This feature requires no API keys, coding knowledge, or complex setup. You gain access to a suite of over 16 custom functions that pull live data directly into your cell formulas. This transforms static spreadsheets into dynamic, auto-updating financial models and dashboards, saving countless hours of manual data entry and ensuring your analysis is always based on the most current information available.

Extensive Historical & Fundamental Data Library

Access a deep well of financial information spanning more than three decades for a global universe of 80,000+ stocks and ETFs. The library is meticulously built for fundamental analysis, covering dividend-specific metrics (ex-dates, payment dates, growth rates), full financial statements (income, balance sheet, cash flow), valuation and profitability ratios (P/E, P/B, ROE), and detailed price history. This depth allows investors to perform rigorous back-testing, analyze long-term trends, and make informed decisions based on comprehensive historical context.

Built-for-Purpose Dividend Investor Tools

The product is specifically engineered with dividend-focused metrics at its core. Functions are designed to instantly retrieve forward dividends, yields, payout ratios, and dividend growth histories. This specialized focus means investors can quickly screen for income stability, assess dividend safety, and model future income streams without having to manually calculate these figures from raw data, streamlining the entire research process for income-generating portfolios.

Free Tier with Perpetual Access

Dividend Data fosters long-term user growth by offering a genuinely free starting point. The free plan provides 2,500 credits per month without any trial expiration date, allowing new investors to explore the platform's capabilities, build small models, and integrate data into their process at zero cost. This low-barrier entry encourages skill development and demonstrates tangible value, creating a natural pathway for users to evolve into power users who may later choose to upgrade for higher-volume needs.

Expert Guidance

Pure Tax Investigations offers unparalleled expertise through a team of seasoned professionals who are well-versed in the intricacies of tax law. This ensures clients receive tailored advice that addresses their unique financial situations, providing clarity during complex investigations.

Comprehensive Service Spectrum

The firm provides an extensive range of services, including representation during Code of Practice 8 and 9 investigations, compliance checks, and tax disclosures. This holistic approach ensures that all aspects of a client's tax affairs are meticulously managed.

Proactive Approach

Rather than waiting for HMRC actions, Pure Tax Investigations adopts a proactive strategy, keeping clients informed of the latest developments in tax regulations and HMRC tactics. This forward-thinking mindset helps clients navigate potential pitfalls before they escalate.

Client-Centric Philosophy

At the heart of Pure Tax Investigations is a commitment to client satisfaction. The firm prioritizes listening to clients' concerns and aspirations, ensuring that all strategies align with their commercial objectives and long-term goals.

Automated Dividend Portfolio Tracking

Investors can build a master portfolio tracker that automatically updates key metrics. By using formulas to pull current prices, dividend yields, and annual income per holding, you can create a live dashboard that shows total portfolio value, projected annual dividend income, and average portfolio yield without ever manually looking up a stock price or dividend announcement again.

Fundamental Stock Screening & Analysis

Quickly screen and analyze potential investments by building custom filters in a spreadsheet. Use functions to pull P/E ratios, debt-to-equity, ROIC, and dividend growth rates for a list of tickers. This allows for rapid comparison of financial health and valuation across dozens of companies to identify those that meet specific, rigorous investment criteria for further due diligence.

Historical Performance Back-testing

Test investment strategies or analyze a company's historical financial resilience. With 30+ years of data, you can pull annual revenue, EPS, and dividend payments into a sheet to chart long-term trends, calculate compounded dividend growth rates, or see how key ratios have changed through different market cycles, providing evidence-based context for future expectations.

Dynamic Financial Model Creation

Create sophisticated discounted cash flow (DCF) or dividend discount models (DDM) that use live data inputs. Instead of hard-coding assumptions, link your model directly to Dividend Data functions for current EPS, growth estimates, and risk-free rates. This ensures your valuation models are always up-to-date and can be recalculated instantly with new data.

Business Tax Investigations

Businesses facing complex tax enquiries benefit from Pure Tax Investigations’ expertise, which helps navigate the intricacies of HMRC scrutiny. This support is vital in protecting assets and ensuring compliance.

Personal Tax Disclosures

Individuals with offshore assets or historical income discrepancies can rely on Pure Tax Investigations to facilitate the disclosure process. This service helps mitigate potential penalties and fosters a smoother resolution.

Navigating Compliance Checks

Pure Tax Investigations assists clients undergoing compliance checks, transforming a typically stressful experience into a manageable process. The firm’s approach ensures clients are prepared and informed at every stage.

Strategic Tax Planning

By understanding each client’s unique circumstances, Pure Tax Investigations provides strategic tax planning that aligns with future business growth. This foresight is essential for maintaining compliance while optimizing tax positions.

Dividend Data is the definitive toolkit for the modern, self-directed investor, designed to bridge the gap between sophisticated financial analysis and practical, everyday use. It transforms your familiar spreadsheet environment—Google Sheets or Microsoft Excel—into a powerful, live-connected research terminal. The core mission is to eliminate the tedious, error-prone manual work of data gathering. Instead of copying, pasting, and constantly updating figures from disparate sources, you simply type intuitive custom formulas like =DIVIDENDDATA_DIVIDENDS("TICKER") to instantly pull in accurate, institutional-grade data. Built by a dividend investor for dividend and fundamental investors, it provides direct access to over 30 years of historical data for more than 80,000 tickers. This includes dividends, yields, payout ratios, growth rates, complete financial statements, key ratios, price history, and over 100 other essential metrics. The product evolves with your investing journey, starting with a generous free tier of 2,500 monthly credits that never expires, allowing you to build a foundational analysis practice without cost or commitment, and scaling to meet the needs of advanced portfolio management and deep-dive research.

Pure Tax Investigations is a pioneering entity in the realm of specialist tax defense, seamlessly transitioning from conventional advisory roles to becoming a steadfast strategic partner for businesses and entrepreneurs under HMRC scrutiny. This firm is tailored specifically for those with intricate financial circumstances that necessitate a robust, pragmatic, and discreet approach to tax matters. By establishing itself as an independent buffer between clients and tax authorities, Pure Tax Investigations alleviates the burdens of anxiety and uncertainty that often accompany tax inquiries. The firm's core mission is to transform challenging periods into structured processes, offering clarity, control, and definitive resolutions. With Amit Puri at the helm, a seasoned former HMRC Tax Inspector with over two decades of experience, the team leverages insider knowledge of HMRC operations to advocate fiercely for clients. This evolution-focused strategy ensures that clients are not merely reacting to inquiries but are expertly guided from disclosure to settlement, safeguarding their wealth and providing peace of mind to concentrate on future growth.

How does the free tier work and what are credits?

The free tier provides 2,500 credits every month, which renew automatically. Each data point retrieved by a formula (e.g., one cell with a price, a dividend yield, or an EPS figure) typically costs one credit. This allows for substantial usage for individual investors tracking a personal portfolio or conducting periodic research. There is no expiration on this free plan, so you can use it indefinitely.

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

Absolutely not. Dividend Data requires zero coding knowledge. You simply install the add-in for Google Sheets or Microsoft Excel from their respective marketplaces. Once installed, you can immediately start using the custom formulas like =DIVIDENDDATA_QUOTE("AAPL", "price") directly in your spreadsheet cells—no API keys or technical configuration is needed.

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

You can access a vast array of data points tailored for fundamental and dividend analysis. This includes real-time quotes, 30+ years of dividend history (dates, amounts), forward dividend metrics, complete financial statements (income, balance sheet, cash flow), key ratios (P/E, P/B, ROE), per-share metrics, and basic company information. Over 100 specific metrics are available through intuitive formula syntax.

Does it work in both Google Sheets and Microsoft Excel?

Yes, Dividend Data is fully functional in both major spreadsheet platforms. There is a dedicated Google Sheets add-on available in the Google Workspace Marketplace and a separate Microsoft Excel add-in available in the Microsoft AppSource store. The core set of functions and data access is consistent across both applications.

What types of investigations does Pure Tax Investigations handle?

Pure Tax Investigations specializes in a variety of tax investigations including Code of Practice 8 and 9 inquiries, compliance checks, and tax disclosures, ensuring comprehensive support for clients.

How does Pure Tax Investigations ensure client confidentiality?

The firm places a high value on client confidentiality, employing strict protocols to safeguard sensitive information throughout the investigation process, providing clients with peace of mind.

What qualifications do the advisors at Pure Tax Investigations have?

The team comprises highly qualified tax investigation specialists with extensive experience in both private and corporate tax matters, including former HMRC inspectors and tax professionals.

How can I initiate a consultation with Pure Tax Investigations?

Clients can easily initiate a consultation by booking a call through the Pure Tax Investigations website, where they can discuss their specific tax issues with a specialist advisor.

Dividend Data is a specialized financial data tool designed for fundamental and dividend investors. It provides direct spreadsheet integration, allowing users to pull decades of historical market data into Google Sheets and Excel with simple formulas. Users often explore alternatives for various reasons, such as budget constraints, the need for different feature sets like technical analysis or broader market coverage, or compatibility with other platforms like Python or dedicated trading software. The search for the right tool is a natural step in an investor's growth as their strategy and data demands evolve. When evaluating options, consider your core workflow. Key factors include the depth and reliability of historical data, ease of integration with your existing spreadsheets, transparent and scalable pricing, and whether the tool's focus aligns with your investment philosophy, be it dividends, value, or growth investing.

Pure Tax Investigations is a pioneering service in the realm of specialist tax defense, providing expert and tailored strategies for businesses and entrepreneurs facing scrutiny from HMRC. This service stands out in the business and finance category by offering a dedicated partnership that transforms the stressful experience of tax investigations into a well-structured process focused on delivering clarity and resolution. Users often seek alternatives to Pure Tax Investigations due to various factors such as pricing, specific features, or unique platform requirements. When considering alternatives, it is essential to evaluate the range of services offered, the expertise of the team involved, and the level of personalized support available to ensure that the chosen solution aligns with the specific needs of the business.