Linkedin    Twitter   Facebook

Get Started
Log In

Linkedin 

Articles Tagged with: General

Connect with us at SFVegas 2024

Click Here to book a time to connect

RiskSpan is delighted to be sponsoring SFVegas 2024!

Connect with our team there to learn how we can help you move off your legacy systems, streamline workflows and transform your data.

Click Here to book a time to connect

Don’t miss these RiskSpan presenters at SFVegas 2024

Bernadette Kogler

Housing Policy:
What’s Ahead
Mon, Feb 26th, 1:00 PM

Tom Pappalardo

Future of Fintech
Wed, Feb 28th, 9:15 AM

Divas Sanwal

Big Data & Machine Learning: Impacts on Origination
Wed, Feb 28th, 11:05 AM

Can’t make the panels?

Click here to make an appointment to connect. Or just stop by Booth 13 in the exhibit hall!


Watch Suhrud Dagli Discuss AI in Securities Analytics at Chartis Research RiskTech100 Conference

Watch Recording

(Register for Day 3)

Register to watch: www.risktech100.com


Snowflake Tutorial Series: Episode 3

Using External Tables Inside Snowflake to work with Freddie Mac public data (13 million loans across 116 fields)

Using Freddie Mac public loan data as an example, this five-minute tutorial succinctly demonstrates how to:

  1. Create a storage integration
  2. Create an external stage
  3. Grant access to stage to other roles in Snowflake
  4. List objects in a stage
  5. Create a format file
  6. Read/Query data from external stage without having to create a table
  7. Create and use an external table in Snowflake

This is the third in a 10-part tutorial series demonstrating how RiskSpan’s Snowflake integration makes mortgage and structured finance analytics easier than ever before.

Episode 1, Setting Up a Database and Uploading 28 Million Mortgage Loans, is available here.

Episode 2, Using Python User-Defined Functions in Snowflake SQL, is available here.

Future topics will include:

  • OLAP vs OLTP and hybrid tables in Snowflake
  • Time Travel functionality, clone and data replication
  • Normalizing data and creating a single materialized view
  • Dynamic tables data concepts in Snowflake
  • Data share
  • Data masking
  • Snowpark: Data analysis (pandas) functionality in Snowflake

RiskSpan’s Snowflake Tutorial Series: Ep. 2

Learn how to use Python User-Defined Functions in Snowflake SQL

Using CPR computation for a pool of mortgage loans as an example, this six-minute tutorial succinctly demonstrates how to:

  1. Query Snowflake data using SQL
  2. Write and execute Python user-defined functions inside Snowflake
  3. Compute CDR using Python UDF inside Snowflake SQL

This is this second in a 10-part tutorial series demonstrating how RiskSpan’s Snowflake integration makes mortgage and structured finance analytics easier than ever before.

Episode 1, Setting Up a Database and Uploading 28 Million Mortgage Loans, is available here.

Future topics will include:

  • External Tables (accessing data without a database)
  • OLAP vs OLTP and hybrid tables in Snowflake
  • Time Travel functionality, clone and data replication
  • Normalizing data and creating a single materialized view
  • Dynamic tables data concepts in Snowflake
  • Data share
  • Data masking
  • Snowpark: Data analysis (pandas) functionality in Snowflake

Prepayment Modeling: Today’s Housing Turnover Conundrum

Presenters

Alex Fishbein

Director, TD Securities

Divas Sanwal

Head of Modeling, RiskSpan

Raj Dosaj

Chief Revenue Officer, RiskSpan

Recorded: Thursday, June 22

Accurately modeling the lock-in effect on housing turnover presents some unique challenges.

Join TD’s Alex Fishbein and RiskSpan’s Divas Sanwal as they discuss various approaches available to modelers for tackling these challenges.



Webinar Recording: An Investor’s Guide to America’s Housing Supply Crisis

Presenters

Amy Crews Cutts

President, AC Cutts and Associates and Chief Economist, NACM

Michael Neal

Equity Scholar and 
Principal Research Associate, Urban Institute

Janet Jozwik

Senior Managing Director and Head of Climate Analytics, RiskSpan

Divas Sanwal

Managing Director and Head of Modeling, RiskSpan

Recorded: Wednesday, March 29th

An informative webinar on the nation’s current “out-of-whack” housing supply and what it means for mortgage investors, homeowners, prospective homebuyers, and renters alike!

Housing economists Amy Crews Cutts and Michael Neal join RiskSpan credit and prepayment modelers Janet Jozwik and Divas Sanwal as they explore the factors that contribute to the current housing supply imbalance, including the cost of building, the impact of permits and zoning, and the emergence of the “missing middle.” They discuss how high interest rates and rental prices are incentivizing owners who relocate to hold old on to their old properties and become landlords. They also examine the impact of ADUs, zoning issues, and the availability of renovation financing.

Mortgage loan and security investors will learn about what housing supply means for prepay speeds. The panelists will consider the role of financing in addressing housing supply issues, including the market for low-balance loans and unconventional options like contracts for deed and lease-to-own arrangements.

The panel discusses the evolving housing needs of the population, including the desire to age in place, the challenges posed by multigenerational living arrangements, and the viability of several proposed solutions, including the potential for converting unused commercial properties into housing.



RiskSpan Incorporates Flexible Loan Segmentation into Edge Platform

ARLINGTON, Va., March 3, 2023 — RiskSpan, a leading technology company and the most comprehensive source for data management and analytics for residential mortgage and structured products, has announced the incorporation of Flexible Loan Segmentation functionality into its award-winning Edge Platform.

The new functionality makes Edge the only analytical platform offering users the option of alternating between the speed and convenience of rep-line-level analysis and the unmatched precision of loan-level analytics, depending on the purpose of their analysis.

For years, the cloud-native Edge Platform has stood alone in its ability to offer the computational scale necessary to perform loan-level analyses and fully consider each loan’s individual contribution to a mortgage or MSR portfolio’s cash flows. This level of granularity is of paramount importance when pricing new portfolios, taking property-level considerations into account, and managing tail risks from a credit/servicing cost perspective.

Not every analytical use case justifies the computational cost of a full loan-level analysis, however. For situations where speed requirements dictate the use of rep lines (such as for daily or intra-day hedging needs), the Edge Platform’s new Flexible Loan Segmentation affords users the option to perform valuation and risk analysis at the rep line level.

Analysts, traders and investors take advantage of Edge’s flexible calculation specification to run various rate and HPI scenarios, key rate durations, and other calculation-intensive metrics in an efficient and timely manner. Segment-level results run at both loan and rep line level can be easily compared to assess the impacts of each approach. Individual rep lines are easily rolled up to quickly view results on portfolio subcomponents and on the portfolio as a whole.

Comprehensive details of this and other new capabilities are available by requesting a no-obligation demo at riskspan.com.

This new functionality is the latest in a series of enhancements that further the Edge Platform’s objective of providing frictionless insight to Agency MBS traders and investors, knocking down barriers to efficient, clear and data-driven valuation and risk assessment.

###

About RiskSpan, Inc. 

RiskSpan offers cloud-native SaaS analytics for on-demand market risk, credit risk, pricing and trading. With our data science experts and technologists, we are the leader in data as a service and end-to-end solutions for loan-level data management and analytics. Our mission is to be the most trusted and comprehensive source of data and analytics for loans and structured finance investments. Learn more at www.riskspan.com.


RiskSpan’s Snowflake Tutorial Series: Ep. 1

Learn how to create a new Snowflake database and upload large loan-level datasets

The first episode of RiskSpan’s Snowflake Tutorial Series has dropped!

This six-minute tutorial succinctly demonstrates how to:

  1. Set up a new Snowflake #database
  2. Use SnowSQL to load large datasets (28 million #mortgage loans in this example)
  3. Use internal staging (without a #cloud provider)

This is this first in what is expected to be a 10-part tutorial series demonstrating how RiskSpan’s Snowflake integration makes mortgage and structured finance analytics easier than ever before.

Future topics will include:

  • Executing complex queries using python functions in Snowflake’s SQL
  • External Tables (accessing data without a database)
  • OLAP vs OLTP and hybrid tables in Snowflake
  • Time Travel functionality, clone and data replication
  • Normalizing data and creating a single materialized view
  • Dynamic tables data concepts in Snowflake
  • Data share
  • Data masking
  • Snowpark: Data analysis (pandas) functionality in Snowflake

Agency Social Indices & Prepay Speeds

Do borrowers in “socially rich” pools respond to refinance incentives differently than other borrowers? 

The decision by Fannie and Freddie to release social index disclosure data in November 2022 makes it possible for investors to direct their capital in support of first-time homebuyers, historically underserved borrowers, and people who purchase homes in traditionally underserved areas. Because socially conscious investors likely also have interest in understanding how these social pools are likely to perform, we were curious to examine and learn whether mortgage pools with higher social ratings behaved differently than pools with lower social ratings (and if a difference existed, how significant it was). To the extent that pools rich in social factors perform better (i.e., prepay more slowly) than pools generally, we expect investors to put an even higher premium on them. This in turn should result in lower rates for the borrowers whose loans contribute to pools with higher social scores. 

The data is new and we are still learning things, but we are beginning to discern some differences in prepay speeds.

Definitions 

First, a quick refresher on Fannie’s and Freddie’s social index terminology: 

  • Social Criteria Share (SCS): The percentage of loans in a given pool that meet at least one of the “social” criteria. The criteria are low-income, minority, and first-time homebuyers; homes in low-income areas, minority tracts, high-needs rural areas; homes in designated disaster areas and manufactured housing. As of December 2022, 42.12 percent of loans in the average pool satisfy at least one of these criteria. 
  • Social Density Score (SDS): A measure of how many criteria the average loan in a given pool satisfies. For simplicity, the index consolidates the criteria into three categories – those pertaining to income, those pertaining to the borrower, and those pertaining to the property. A pool’s SDS can be zero, 1, 2, or 3 depending on the number of categories within which the loan satisfies at least one criterion. The average SDS as of December 2022 is 0.62 (out of 3). 

Do social index scores impact prepay speeds? 

While it remains too early to answer this question with a great deal of certainty, historical performance data appears to show that pools with below-average social index scores prepay faster than more “social” bonds. 

We first looked at a high-level, simplistic relationship between prepayments and Social Density Score. In Figure 1, below, pools with below-average Social Density Scores (blue line) prepay faster than both pools with above-average SDS (black line) and pools with the very highest SDS (green line) when they are incentivized by interest rates to do so. (Note that very little difference exists among the curves when borrowers are out of the money to refi.)  


Fig. 1: Speeds by Prepay Incentive and Social Density Score 

See how easy RiskSpan’s Edge Platform makes it for you to do these analyses yourself.

Request a Trial

We note a similar trend when it comes to Social Criteria Share (see Fig. 2, below).  


Fig. 2: Speeds by Prepay Incentive and Social Criteria Share 

Social Pool Performance Relative to Spec Pools 

Investors pay up for mortgage pools with specified characteristics. We thought it worthwhile to compare how certain types of spec pools perform relative to socially rich pools with no other specified characteristics. 

Figure 3, below, compares the performance of non-spec pools with above-average Social Criteria Share (orange line) vs. spec pools for low-FICO (blue line), high-LTV (black line) and max $250k (green line) loans. 

Note that, notwithstanding a lack of any other specific characteristics that investors pay up for, the high-SCS pools exhibit a somewhat better convexity profile than the max-700 FICO and min-95 LTV pools and slightly worse convexity (in most refi incentive buckets) than max-250k pools. 


Fig. 3: Speeds by Prepay Incentive and Social Criteria Share: Socially Rich (Non-Spec) Pools vs. Selected Spec Pools

We observe a similar effect when we compare non-spec pools with an above-average Social Density Score to the same spec pools (Fig. 4, below).   


Fig. 4: Speeds by Prepay Incentive and Social Density Score: Socially Rich (Non-Spec) Pools vs. Selected Spec Pools 

See how social index scores affect speeds relative to other spec pools.

Contact us


Edge Platform Adds Fannie and Freddie Social Index Data

ARLINGTON, Va., January 18, 2023 — RiskSpan, a leading technology company and the most comprehensive source for data management and analytics for residential mortgage and structured products, has announced the incorporation of Fannie Mae’s and Freddie Mac’s Single-Family Social Index data into its award-winning Edge Platform.

Fannie and Freddie rolled out their social index disclosures in November 2022. Consisting of two measures, the Social Criteria Score and the Social Density Score, the social index discloses the share of loans in a given pool that are made to low-income, minority, and first-time homebuyers, as well as mortgages on homes in low-income areas, minority tracts, high-needs rural areas, and designated disaster areas. Manufactured housing loans also contribute to the score.

Rather than classifying each individual bond as “social” or “not social,” the new Agency data available on the Edge Platform assigns every pool two fully transparent scores – one indicating the percentage of loans in a pool that satisfy any of the defined social criteria, the other reflecting how many criteria a pool’s average loan satisfies.

Taken together, these enable Agency traders and investors to view and understand each pool along a full continuum of the social index, as opposed to simply assigning a binary social designation. Because borrowers behave differently at various places along this continuum, traders and investors fine-tune their analytics in ways never before possible to isolate pools with potentially slower prepayment speeds in a way that transcends what has traditionally been available using so-called “spec. pool” stories alone.

Comprehensive details of this and other new capabilities are available by requesting a no-obligation live demo at riskspan.com.

This new functionality is the latest in a series of enhancements that further the Edge Platform’s objective of providing frictionless insight to Agency MBS traders and investors, knocking down barriers to efficient, clear and data-driven valuation and risk assessment.

### 

About RiskSpan, Inc. 

RiskSpan offers cloud-native SaaS analytics for on-demand market risk, credit risk, pricing and trading. With our data science experts and technologists, we are the leader in data as a service and end-to-end solutions for loan-level data management and analytics.

Our mission is to be the most trusted and comprehensive source of data and analytics for loans and structured finance investments.

Rethink loan and structured finance data. Rethink your analytics. Learn more at www.riskspan.com.

Get a Demo

About RiskSpan, Inc. 

RiskSpan offers cloud-native SaaS analytics for on-demand market risk, credit risk, pricing and trading. With our data science experts and technologists, we are the leader in data as a service and end-to-end solutions for loan-level data management and analytics. 

Our mission is to be the most trusted and comprehensive source of data and analytics for loans and structured finance investments. 

Rethink loan and structured finance data. Rethink your analytics. Learn more at www.riskspan.com. 

Media contact: Timothy Willis 


Get Started
Log in

Linkedin