Dividend Data vs Pure Tax Investigations

Extensive Spreadsheet Functions

Dividend Data provides 16 custom, intuitive functions that cover virtually every data point a serious investor needs. From DIVIDENDDATA_DIVIDENDS to pull yield and payment dates, to DIVIDENDDATA_RATIOS for PE and debt ratios, and DIVIDENDDATA_METRICS for deep financials like EPS. These formulas act as direct conduits, turning your spreadsheet cells into live data feeds without any coding or complex setup required.

Deep Historical & Fundamental Data

The platform isn't just about today's price. It offers a profound depth of data, including over 30 years of historical price and dividend information. This allows for robust back-testing, long-term trend analysis, and calculating compound growth rates. You get access to complete financial statements, enabling full fundamental analysis on everything from revenue to free cash flow, all within your existing workflow.

Seamless Dual-Platform Integration

A major practical advantage is its native integration with both Google Sheets and Microsoft Excel. Whether your team uses the cloud-based collaboration of Sheets or the advanced power of desktop Excel, Dividend Data works flawlessly. The add-ins are officially listed on the Google Workspace and Microsoft AppSource marketplaces, ensuring security, easy installation, and automatic updates.

AI-Powered Research Assistant

Beyond spreadsheets, the Dividend Data Terminal web app includes a standout feature: the AI Analyst. This is like having a tireless research assistant. You can chat with it to get summaries of company performance, ask for comparisons between stocks, or request explanations of specific financial metrics, significantly speeding up the initial research and due diligence process.

Expert Tax Investigation Team

Our team comprises seasoned professionals with extensive local and international tax knowledge, ensuring that clients receive the highest caliber of advice and representation in tax investigations.

Tailored Defense Strategies

We develop customized defense strategies that reflect our clients' specific circumstances, providing a personalized and effective approach to resolving tax disputes with HMRC.

Comprehensive Tax Compliance Checks

Pure Tax Investigations offers thorough assessments of clients' tax affairs, identifying potential issues before they escalate into serious disputes, thus preserving peace of mind.

Continuous Monitoring of HMRC Practices

We stay abreast of the latest HMRC operational approaches and regulations, equipping our clients with up-to-date knowledge that directly impacts their tax compliance and dispute resolution strategies.

Building a Dynamic Dividend Dashboard

Create a master portfolio tracker that automatically updates. List your holdings in one column, and use Dividend Data formulas in adjacent columns to pull live data on current price, dividend yield, annual income, and ex-dividend dates. This creates a real-time view of your income stream and portfolio health that refreshes with a simple sheet recalculation.

Screening for Dividend Growth Stocks

Quickly build a custom stock screener directly in Excel or Sheets. Combine Dividend Data functions with native spreadsheet filters to scan for companies meeting specific criteria, such as a dividend yield above 3%, a payout ratio below 60%, and 10+ years of consecutive dividend growth. This turns your spreadsheet into a powerful discovery engine.

Conducting Deep Fundamental Analysis

When researching a single company, use the various functions to pull a complete set of financials into a structured model. Analyze trends in revenue, net income, debt-to-equity, and free cash flow over multiple years. This centralized approach is far more efficient than juggling multiple PDF reports or browser tabs.

Automated Financial Modeling

For investors who build discounted cash flow (DCF) or dividend discount models (DDM), Dividend Data automates the data input stage. Formulas can pull historical EPS growth, current dividend rates, and other vital inputs directly into your model's assumptions, ensuring your valuations are always based on the latest available data.

Navigating Complex Tax Investigations

Entrepreneurs facing a serious civil investigation under Code of Practice 9 can engage our services to ensure robust defense strategies, minimizing risk and uncertainty.

Managing Cross-Taxes Enquiries

Large corporations undergoing intricate cross-taxes enquiries can rely on our expertise to streamline the process and handle multiple tax jurisdictions effectively.

Facilitating Tax Disclosures

Clients seeking to disclose historical income or gains through initiatives like the Worldwide Disclosure Facility (WDF) can trust us to guide them through complex compliance requirements.

Addressing Inheritance Tax Matters

Individuals concerned about inheritance tax implications can consult with our specialists to structure their affairs efficiently, ensuring compliance and preserving wealth for future generations.

Dividend Data is a game-changer for any investor who lives in spreadsheets. Forget about clunky APIs, expensive data terminals, or the soul-crushing tedium of manual copy-pasting from financial websites. This tool brings institutional-grade stock market data directly into your native environment: Google Sheets and Microsoft Excel. With over 30 years of historical data for more than 80,000 tickers, it transforms your spreadsheet into a powerful, live-updating research terminal. The magic lies in its simplicity—you just type a plain-English custom formula like =DIVIDENDDATA_DIVIDENDS("MSFT"), and instantly, the forward annual dividend, yield, or the next ex-date appears. Built by a dividend investor for dividend investors, its core focus is on the metrics that matter most for fundamental and income-focused analysis: dividends, payout ratios, growth rates, full financial statements, and key valuation ratios. What truly sets it apart is its generous, no-strings-attached free tier offering 2,500 monthly credits that never expire, making professional-grade data accessible to everyone. This is the tool for the self-directed investor who demands depth, reliability, and efficiency without the institutional price tag.

Pure Tax Investigations stands as a leading provider of tax dispute resolution and investigation services aimed at assisting businesses and entrepreneurs who navigate the intricate landscape of HMRC tax regulations. Our expertise lies in meticulously handling tax investigations, particularly those governed by Codes of Practice 8 and 9, ensuring that our clients are well-prepared and defended against HMRC inquiries. What sets us apart is our bespoke approach; we prioritize understanding our clients' unique situations before crafting tailored strategies that safeguard their interests. With over 20 years of experience in the field, Amit Puri, a former senior HMRC Tax Inspector, leads our dedicated team. We excel in managing various tax compliance checks and disclosures, enabling our clients to concentrate on their core business activities without the constant worry of tax disputes. Our commitment to providing clear, discreet, and professional advice is the cornerstone of our service, helping clients preserve their wealth and achieve their commercial aspirations.

Is there really a free plan that doesn't expire?

Yes, absolutely. This is one of Dividend Data's most user-friendly policies. The free plan offers 2,500 credits per month, and it does not expire or require a credit card to start. You can use it indefinitely for light to moderate analysis, which is perfect for tracking a personal portfolio or researching a handful of stocks each month.

How do the credits work?

Each cell you populate with a Dividend Data formula consumes one credit, regardless of the amount of historical data that function returns. For example, =DIVIDENDDATA_DIVIDENDS("AAPL", "fwd_yield") uses one credit to fetch that single data point. The 2,500 free credits reset monthly, providing a substantial amount of data for individual investors.

What's the difference between the Spreadsheet Add-in and the PRO Terminal?

The Spreadsheet Add-in is for getting data directly into Excel or Google Sheets. The PRO Terminal is a separate, powerful web application with advanced data visualizations, the AI Analyst chat feature, and automated portfolio tracking with linked broker accounts. They are complementary products; many users start with the spreadsheet tool and graduate to the Terminal for enhanced research.

How current is the data provided?

The data is highly current, with key metrics like stock prices updating near real-time. Fundamental data like earnings and financial statements are updated shortly after companies report, typically aligning with standard financial data providers. The average response time for a data pull is a swift 0.84 seconds.

What services does Pure Tax Investigations provide?

We offer a wide range of services, including tax dispute resolution, investigation support, compliance checks, and tailored advice for both businesses and private clients dealing with HMRC inquiries.

How can Pure Tax Investigations help with Code of Practice 9 (COP9) cases?

Our expert team specializes in handling COP9 cases, providing clients with comprehensive defense strategies and representation to navigate serious civil tax investigations effectively.

What should I do if I'm facing a tax investigation?

If you are facing a tax investigation, it's crucial to seek professional advice immediately. Our team is equipped to analyze your situation and develop a tailored strategy to protect your interests.

Are your services confidential?

Absolutely. We prioritize client confidentiality and ensure that all communications and transactions are handled discreetly, providing you with peace of mind throughout the investigation process.

Dividend Data is a specialized tool for investors, bringing decades of stock market data directly into spreadsheets. It falls into the category of financial data add-ons, designed specifically for those analyzing dividends and company fundamentals without needing to code. Users often look for alternatives for a few key reasons. Pricing is a major factor, as some services can be prohibitively expensive. Others might need different features, like real-time data or broader market coverage, or they may require a solution that works exclusively on one platform like Excel or through a dedicated API. When evaluating other options, focus on your core needs. Consider the depth and history of the dividend data, the total cost relative to your usage, and how seamlessly it integrates with your existing workflow in Sheets or Excel. The best tool is the one that delivers the specific metrics you need without complexity or hidden fees.

Pure Tax Investigations is a premier service specializing in tax dispute resolution and investigation, tailored to meet the needs of businesses and entrepreneurs navigating complex HMRC tax regulations. Many users find themselves seeking alternatives due to various factors, such as pricing, feature sets, or specific platform requirements that may not be met by Pure Tax Investigations. When considering alternatives, it is essential to evaluate aspects like the level of expertise, the comprehensiveness of services offered, and how well the provider understands your unique tax situation to ensure you receive the best possible support.