About a-team Marketing Services
The knowledge platform for the financial technology industry
The knowledge platform for the financial technology industry

A-Team Insight Blogs

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

Subscribe to our newsletter

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.

Subscribe to our newsletter

Related content

WEBINAR

Upcoming Webinar: How to organise, integrate and structure data for successful AI

25 September 2025 10:00am ET | 3:00pm London | 4:00pm CET Duration: 50 Minutes Artificial intelligence (AI) is increasingly being rolled out across financial institutions, being put to work in applications that are transforming everything from back-office data management to front-office trading platforms. The potential for AI to bring further cost-savings and operational gains are...

BLOG

Data Concern Over EU’s Streamlining of Green Regulations

Financial institutions may have to rely more heavily on their data teams and vendors to surface sustainability risks in their portfolios after the European Union watered down some of its key corporate ESG reporting regulations. The EU’s Omnibus package announced earlier this year is intended to streamline the compliance processes for regulations including the Corporate...

EVENT

AI in Capital Markets Summit New York

The AI in Capital Markets Summit will explore current and emerging trends in AI, the potential of Generative AI and LLMs and how AI can be applied for efficiencies and business value across a number of use cases, in the front and back office of financial institutions. The agenda will explore the risks and challenges of adopting AI and the foundational technologies and data management capabilities that underpin successful deployment.

GUIDE

AI in Capital Markets: Practical Insight for a Transforming Industry – Free Handbook

AI is no longer on the horizon – it’s embedded in the infrastructure of modern capital markets. But separating real impact from inflated promises requires a grounded, practical understanding. The AI in Capital Markets Handbook 2025 provides exactly that. Designed for data-driven professionals across the trade life-cycle, compliance, infrastructure, and strategy, this handbook goes beyond...