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.
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.
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.
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.
Time series data
In the second tutorial, we pull down 32 years of Revenue data for 19 companies.
Quantemplate helps you bring Capital IQ data into your workflow, enabling you to identify clash, and build a more complete picture of your risks.
