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: Entity identification and client lifecycle management – How financial institutions can drive $4 billion in cost savings

A new model in Legal Entity Identifier (LEI) issuance has created significant opportunities for financial institutions to capitalise on their KYC and AML due diligence. By becoming Validation Agents and obtaining LEIs on behalf of their clients, financial institutions can enhance their client onboarding experience, streamline their internal operations, and open the door to new,...

BLOG

SmartStream Adds API Suite to Reference Data Utility

SmartStream Technologies has made its first move since rebranding at the end of last year and bringing its Reference Data Utility (RDU) into the mainstream of its product line-up, with the addition of an API suite for the RDU. The APIs are designed to provide faster access to accurate data, operational efficiency, greater agility, and...

EVENT

Data Management Summit New York City

Now in its 10th year, the Data Management Summit (DMS) in NYC explores the shift to the new world where data is redefining the operating model and firms are seeking to unlock value via data transformation projects for enterprise gain and competitive edge.

GUIDE

MiFID II handbook, third edition – How compliant are you?

Six months after Markets in Financial Instruments Directive II (MiFID II) went live, how compliant is your organisation? If you took a tactical approach to cross the compliance line on January 3, 2018, how are you reviewing and renewing systems to take a more strategic approach and what are the business benefits of doing so?...