The leading knowledge platform for the financial technology industry
The leading knowledge platform for the financial technology industry

A-Team Insight Blogs

S&P Capital IQ Bolsters CMBS Insight with Additions to ABSXchange

S&P Capital IQ has responded to customer demand for greater insight into commercial mortgage-backed securities (CMBS) by adding functionality to its ABSXchange structured finance analytics platform and upgrading its Excel Add-in that can be used across asset classes.

Additions to the CMBS model within ABSXchange are an improved loan assumptions editor that allows users to create liquidation schedules for each underlying loan in a deal, and individual loan cash flow projections that add cash flow projections for each underlying loan in a deal to cash projections for the pool of loans as a whole. These functions are designed to offer more transparency and data granularity when running CMBS queries against ABSXchange. They were made available early this week.

The upgraded Excel Add-In will be in production next week and offers users increased speed, more data fields, flexibility to create reports tailored to a user’s needs and an improved intuitive interface. Capital IQ has also added CMBS, residential mortgage-backed securities (RMBS) and asset-backed securities (ABS) templates to the add-in, helping users set up their own reports quickly and pull in data relevant to specific deals from ABSXchange.

Bruce Christie, director at S&P Capital IQ, explains: “Since the start of the financial crisis the CMBS market has faced a lot of challenges, such as loans due to mature that haven’t matured and loan defaults. These problems are rising and investors want to take these stresses into account in their analysis of deals. They want more control over CMBS models and the types of stresses they want to apply have changed, which is why we have added new features to ABSXchange and will continue to do so.”

With these upgrades in place and ABSXchange already offered as a web service or in-house system built using a C++ application programming interface (API) and incorporating Capital IQ’s models and data, the company is thinking ahead. While the focus of ABSXchange will remain on CMBS and ABS portfolios, Christie envisages the addition of covered bonds and increased coverage of collateralised loan obligations.

Reflecting Bank of England guidelines on making loan level data available that came into effect late last year and the European DataWarehouse initiative around loan level data, Capital IQ also intends to make more loan-level data available than it can currently offer to enhance CMBS analytics.

On the technology front, Christie says the company is working on an improved API and on a longer-term project that will add cash flow analytics to the Excel Add-in. At the moment, add-in users can download and analyse data to determine inputs to the cash flow model, but cannot run the cash-flow model as part of the Excel add-in workflow.

Related content

WEBINAR

Recorded Webinar: Brexit: Reviewing the regulatory landscape and the data management response

With Brexit behind us and the UK establishing its own regulatory regime having failed to reach equivalence with the EU, financial firms face challenges of double reporting, uncertainty about UK regulation, and a potential exodus of top talent. The data management response is not easy and could stretch some firms to the limit as they...

BLOG

Australian Superannuation Fund QSuper Selects Matrix IDM for Integrated Data Management Solution

QSuper, one of Australia’s largest superannuation funds, has selected Matrix IDM’s data management product to provide a fully integrated solution across security, pricing, positions, accounts, risk, performance, and corporate actions data. The fund was looking for an off-the-shelf data warehouse to support a data strategy project that would create a vendor and custodian agnostic data...

EVENT

RegTech Summit London

Now in its 5th year, the RegTech Summit in London explores how the European financial services industry can leverage technology to drive innovation, cut costs and support regulatory change.

GUIDE

Regulatory Data Handbook – Second Edition

Need to know all the essentials about the regulations impacting data management? A-Team’s Regulatory Data Handbook is a great way to see at-a-glance: All the regulations that are impacting data management today A description of each regulation The impact each will have from a data and data management perspective Messages from sponsors with products related to...