Skip to main content

Using Kensho (S&P Capital IQ) for Financial Analysis

Updated today

The Kensho integration provides Claude with access to S&P's financial data service, delivering comprehensive market and fundamental data for public companies. This article explains how to set up and use Kensho data for financial analysis, including price history, financial statements, segment data, and business relationships.

What This Integration Provides

Capabilities

The Kensho integration enables Claude to access multiple dimensions of financial and market data:

  • Company Identification and Information: Retrieve company profiles using tickers, ISINs, or CUSIPs, including industry classifications, employee counts, headquarters locations, and operating status

  • Historical Price and Market Data: Access OHLC prices, volumes, market cap, and enterprise value at daily, weekly, monthly, or yearly frequencies, with adjusted prices for accurate return calculations

  • Financial Statement Access: Pull complete balance sheets, income statements, and cash flow statements for annual, quarterly, LTM, or YTD periods with customizable date ranges

  • Granular Financial Metrics: Extract specific line items from 200+ available metrics including revenue, EBITDA, R&D expense, and calculated ratios like debt-to-equity

  • Segment Performance Data: Access business unit and geographic breakdowns showing how revenue and operating income distribute across divisions (availability varies by company)

  • Business Relationship Mapping: Identify supplier relationships, customer dependencies, and strategic partnerships from SEC filings to assess operational risks

  • Competitor Intelligence: Retrieve competitor lists from multiple sources including SEC filings, self-identification, and third-party analysis

  • Time Period Management: Determine latest reporting periods and calculate historical quarters for consistent comparisons across companies with different fiscal years

How Claude Uses Kensho Data

Claude applies Kensho's data capabilities to support comprehensive financial analysis

  • Cross-Identifier Lookups: Automatically handles tickers, ISINs, or CUSIPs, useful for international portfolios or fixed income securities

  • Multi-Period Analysis: Constructs time series by pulling data across periods, calculating growth rates and identifying trend changes

  • Statement Reconciliation: Combines data from different statements to calculate derived metrics and verify consistency

  • Peer Group Construction: Retrieves identical metrics across companies for true apples-to-apples comparisons

  • Relationship Network Analysis: Maps business ecosystems to reveal concentration risks and strategic positioning not apparent from financials alone

Setting Up Kensho Integration

For Organization Admins

  1. Navigate to Settings > Integrations

  2. Toggle to "Organization integrations"

  3. Click "Add custom integration"

  4. Enter the Kensho integration URL: https://kfinance.kensho.com/integrations/mcp

  5. Name the integration (e.g., "Kensho S&P")

  6. Click "Add"

For Individual Users

Common Use Cases

Comprehensive Company Profile

Using Kensho, create a complete profile for Microsoft (MSFT) including current market data, latest financial metrics, business segments, and key competitors. Include market cap, enterprise value, trailing twelve-month revenue and margins, plus geographic revenue breakdown.

This type of comprehensive profile combines multiple data types into a single analytical view. Claude retrieves current market metrics, pulls recent financial performance, and identifies segment breakdowns to show how the business operates across different units and geographies. The competitor identification adds context about the competitive environment.

When to use: Initial company research or updating investment memos with current information

Tip: Request both market data and fundamentals together for a complete overview that includes valuation context alongside operational performance.

Historical Price Performance Analysis

Pull five years of weekly price data for Tesla (TSLA) and calculate the volatility, maximum drawdown, and performance versus the S&P 500. Include adjusted prices to account for any stock splits and show periods of highest volatility.

Historical price analysis using Kensho data goes beyond simple price charts. Claude can calculate risk metrics like volatility and maximum drawdown while comparing performance to benchmarks. Using adjusted prices ensures that return calculations properly account for corporate actions, providing accurate performance measurement over multi-year periods.

When to use: Evaluating historical risk-return profiles or backtesting investment strategies

Note: Adjusted prices ensure accurate return calculations across corporate actions like splits and special dividends, which is essential for long-term performance analysis.

Financial Statement Deep Dive

Retrieve Apple's last 12 quarters of income statements and calculate the trend in gross margins, operating margins, and R&D as percentage of revenue. Show both the quarterly values and the rolling four-quarter averages to smooth seasonality.

Financial statement analysis through Kensho allows examination of margin trends and cost structure evolution over time. Claude can pull specific line items across multiple quarters, calculate relevant ratios, and apply smoothing techniques to identify underlying trends beyond seasonal fluctuations. This granular approach reveals operational changes that might be obscured in annual reports.

When to use: Analyzing margin trends, cost structure changes, or earnings quality

Tip: LTM calculations help normalize for seasonal businesses, providing clearer trend analysis for companies with significant quarterly variations.

Competitor Benchmarking

Identify Netflix's competitors from their SEC filings and compare key metrics including subscriber growth, content costs, average revenue per user, and free cash flow margins. Focus on direct streaming competitors they specifically mention as competitive threats.

Competitor analysis combines Kensho's relationship mapping with financial metric comparisons. Claude first identifies competitors from various sources, then retrieves comparable metrics for each company. This approach provides both the competitive landscape view and quantitative performance comparisons, helping assess relative positioning and competitive advantages.

When to use: Industry analysis or relative valuation work

Note: Different source filters provide varying perspectives on competition—SEC filings show who companies view as threats, while third-party sources may identify less obvious competitive dynamics.

Segment Performance Tracking

Show Amazon's segment breakdown for the last eight quarters, including revenue and operating income by segment. Calculate the growth rates for AWS, North America retail, and International retail, and identify which segments are driving overall margin expansion.

Segment analysis reveals the underlying drivers of consolidated performance. Claude retrieves segment-level financial data to show how different business units contribute to overall results. By tracking segment metrics over time, you can identify which divisions are accelerating or decelerating, understand margin mix shifts, and assess the quality of revenue growth.

When to use: Understanding business mix changes and identifying growth drivers

Tip: Segment data reveals trends not visible in consolidated statements, particularly for conglomerates or companies undergoing business model transitions.

Supply Chain Analysis

Map NVIDIA's key business relationships including their primary chip manufacturers, major customers, and strategic technology partners. Focus on relationships mentioned in their latest 10-K filing to understand supply chain dependencies and customer concentration risks.

Business relationship mapping through Kensho provides insights into operational dependencies and strategic positioning. Claude identifies suppliers, customers, and partners from regulatory filings, revealing concentration risks and potential vulnerabilities. This network view complements financial analysis by highlighting operational factors that could impact future performance.

When to use: Assessing operational risks or understanding industry value chains

Key benefit: Reveals dependencies not apparent from financial statements alone, such as single-source supplier risks or customer concentration that could impact revenue stability.

Tips for Using Kensho

  • Use any identifier format (ticker, ISIN, CUSIP) - Claude handles conversion automatically

  • Request specific date ranges to manage data volume and focus analysis

  • Combine market data with fundamentals for comprehensive analysis

  • Check data availability periods using the latest reporting period function

  • Note that segment data availability varies by company reporting practices

  • Be specific about which financial statement items you need from the 200+ available metrics

  • Consider using LTM periods for companies with significant seasonality

  • Remember that business relationship data comes from disclosed sources and may not capture all partnerships

Did this answer your question?