Get a demo

Please add at least 2 characters.
Please add at least 2 characters.
Please add a company.
Please add at least 2 characters.
Thank you for your enquiry.
We’ll be in touch soon.
Oops! Something went wrong while submitting the form.

Integrate Capital IQ data

Augment your risk data with Capital IQ to identify clash and build unique insights about your risks

The challenge

What’s the parent company of a counterparty?
Where else might I have exposure to them?
What’s their credit risk?
How has their profitability changed over time?

Joining your incoming risks to data from a financial intelligence platform such as S&P Capital IQ can answer these questions.

What’s stopping most insurance companies from doing this? We’ve spoken to re/insurers across the market and the same two challenges recur:

Standardising company names to match Capital IQ
When you have multiple sources of policy data, large-scale standardisation of company names to match Capital IQ records is a challenge.

Automating the Capital IQ connection
Whilst the Capital IQ database can be queried via an Excel plugin, re/insurers have a need for more scalable, automated and auditable workflows.

How Quantemplate helps

Standardising company names to match Capital IQ

Joining risk data to Capital IQ requires consistent naming of insureds in order to locate the correct Capital IQ record. Quantemplate’s Company Name Matching solution combines word frequency analysis with intelligent fuzzy matching to efficiently standardise names and map them to Capital IQ. For a technical deep-dive on the techniques and pipeline architecture, check out our webinar.

Automating the Capital IQ connection

Now you have Capital IQ IDs for your risks in Quantemplate, our API connectors and Capital IQ orchestration tool will automate the query to the database. We’ve put together a couple of technical tutorials showing how to set up a connection.

Data across categories

In the first tutorial we run through how to set up a query to pull down the most recent data on Revenue, Market Cap, Net Income, Total Employees and Ultimate Parent for a batch of 90 companies. This data could then automatically feed a risk or pricing model.

Read the documentation

Time series data

In the second tutorial, we pull down 32 years of Revenue data for 19 companies.

Read the documentation

Quantemplate helps you bring Capital IQ data into your workflow, enabling you to identify clash, and build a more complete picture of your risks.

See the Aggregation and Clash use case.