Crunched × S&P Capital IQ

Ai-powered Capital IQ workflows, native to Excel

Crunched is collaborating with S&P Global Market Intelligence to bring S&P Capital IQ formula capabilities into the Crunched experience – live with select joint customers, including a major global professional services firm. Analysts can now describe what they need in plain language, and Crunched writes accurate Capital IQ formulas straight into the live workbook.

1. 01_Plain-language formula generation – describe the metric, ticker, period or currency you need; Crunched writes the Capital IQ formula.
2. 02_Live, refreshable formulas – not transcribed numbers. Every cell stays a native Capital IQ formula your team can audit and refresh.
3. 03_Built into the deal workflow – comps, model population, and review run inside the same Excel session, using your firm's templates.

Why this collaboration

S&P Capital IQ is the backbone of how finance teams work in Excel. Hundreds of thousands of analysts across investment banking, corporate development, private equity, and advisory rely on its plug-in for live, structured market data. The pain has never been the data – it's the formula syntax: tickers, date parameters, currency settings, metric identifiers, all of it constructed by hand and debugged formula by formula.

Crunched closes that gap. Analysts describe what they need in plain language and Crunched generates the Capital IQ formula with correct syntax and parameters. For users with the Capital IQ Excel plug-in installed, the response is written directly into the live workbook – preserving the auditability, precision, and refresh capabilities Capital IQ Pro users depend on, while dramatically reducing manual effort.

"S&P Capital IQ is the backbone of how finance teams work in Excel. By bringing that formula ecosystem into Crunched, we're giving analysts a way to move faster without ever leaving their spreadsheet or sacrificing the data integrity their work demands."— Michael Sakowski, Co-founder, Crunched

A new standard for data-driven modeling in Excel

The collaboration combines Crunched's AI modeling capabilities with Capital IQ's comprehensive financial data to deliver an integrated workflow that spans the full lifecycle of financial analysis.

Intelligent formula generation

Crunched interprets analyst intent and constructs properly formatted Capital IQ formulas – including tickers, date parameters, currency settings, and metric identifiers – eliminating the trial-and-error of manual syntax construction.

Template-aware model building

The integration works with existing firm-specific templates and formatting standards, populating models with live Capital IQ data for users with the plug-in installed, tailored to each organisation's established workflows.

Automated comparable company analysis

Analysts can generate peer groups with supporting rationale, build comps tables populated with Capital IQ data, and iterate on selection criteria – all through conversation.

Full auditability

Every data point flows through Capital IQ's native formula framework, preserving the transparency and traceability that compliance and review processes require. Unlike MCP-based approaches – where an AI agent retrieves data and must transcribe it into the spreadsheet, introducing the risk of hallucination or errors, especially with large datasets – Crunched writes live Capital IQ formulas directly into Excel in collaboration with the Capital IQ team. Every number is a native, refreshable formula, not a static value copied by an AI.

Error detection and verification

Crunched's proprietary verification layer cross-checks model structure, formula logic, and data linkages, catching errors that are difficult to spot in complex, multi-sheet financial models.

Validated with leading financial institutions

The integration is live with a select group of joint customers across investment banking, professional services, and investment management. Early adopters have been closely involved in shaping the collaboration's design and priorities, ensuring it addresses real-world workflows from day one.

At one large consulting firm, Capital IQ formula support was the single most-requested feature – and within a week of going live, it became one of the most-used capabilities on the Crunched platform.

Pioneering AI-native data integration for finance

General-purpose AI assistants have made inroads into casual spreadsheet use, but the specialised demands of professional financial modelling – proprietary data feeds, complex formula syntax, firm-specific templates, and strict auditability requirements – have remained beyond their reach.

The Crunched and Capital IQ collaboration represents a fundamentally different approach: purpose-built AI that understands both the analytical rigour of professional finance and the data architecture of institutional platforms. Capital IQ's Excel plug-in serves hundreds of thousands of finance professionals globally; combined with Crunched's AI-native workflow engine, the collaboration is defining a new category of productivity for the most demanding Excel users in finance.

Crunched is an AI platform designed for the top tier of M&A professionals. Purpose-built for transaction, advisory, and consulting workflows, Crunched combines natural language interaction with structured model building, document data extraction with source verification, and a comprehensive error detection & review system – all directly inside the tools where professionals work (e.g., Excel). Crunched is trusted by leading investment banks, professional services firms, and institutional investors across five continents.

Forward-looking statement: this article describes planned product capabilities and partnership intentions. Timing and availability are subject to change.

See it in your workflow

Bring Crunched and Capital IQ into your firm's Excel environment. We'll walk you through it on a deal you're working on right now.