Portfolio Management

Loan Level Templates Using Python

Loan Level Templates Using Python

Loan Level Templates Using Python

Reading Time: 0 min.

Loan Level Templates Using Python

In this Open Risk Academy course we figure step by step how to use python to work with Loan Level Templates, using the ECB SME template as an example.

  • Overview of the loan level template
  • Manipulating spreadsheets with Python
  • The Python Dictionary
  • Organization of Portfolio Data
  • Generating Test Portfolios

Get an Open Risk Academy account and get started with the course here

07, Risk Capital for Non-Performing Loans

07, Risk Capital for Non-Performing Loans

Reading Time: 1 min.

Open Risk White Paper 7: Risk Capital for Non-Performing Loans

We develop a conceptual framework for risk capital calculation for portfolios of non-performing loans. In general banking practice, loans that pass a threshold of delinquency are declared non-performing and are provisioned. Yet there is a residual risk that the provisioning is not sufficient. This risk must be covered by capital buffers. The literature for risk capital requirements for NPL portfolios is very limited, which implies that Stress Testing and Internal Capital Adequacy Assessment (ICAAP) requirements for non-performing loans are harder to meet. Our framework builds on tools used in portfolio credit risk modeling and provides a structured approach to address the risk profile that is specific to non-performing loans.

Unbundling the Banks: A How To Guide

Unbundling the Banks: A How To Guide

Reading Time: 5 min.

Talk of unbundling the banks is all the rage these days (if we believe the chatter coming from fintech startups). Yet upon closer inspection one gets the feeling that these optimistic people might not necessarily know exactly what they are trying to unbundle, the true complexity of a medium-to-large bank, which in turn reflects, at least in part, the complexity of our modern Financial System .

Open Source Risk Data with MongoDB and Python

Open Source Risk Data with MongoDB and Python

Reading Time: 3 min.

Open source software is all the rage those days in IT and the concept is making rapid inroads in all parts of the enterprise. An earlier comprehensive survey by Gartner, Inc. found that by 2011 more than half of organizations surveyed had adopted open-source software (OSS) solutions as part of their IT strategy. This percentage may have currently exceeded the 75% mark according to open source advisory firms.

02, Confidence Capital - The Principle

02, Confidence Capital - The Principle

Reading Time: 1 min.

Open Risk White Paper 2: Confidence Capital: The Principle

We review the structure of economic capital frameworks commonly used within financial institutions and identify why the derived capital metrics do not explicitly address the needs for maintaining ongoing confidence on the soundness of the firm. In the follow-up to the financial crisis the need for more explicit such tests has been highlighted by regulatory stress testing methodologies.

The mystery of the collapsed cathedral

The mystery of the collapsed cathedral

Reading Time: 6 min.

The mystery of the collapsed cathedral

You walk to the center of an old city, and you see its glorious cathedral lying in ruins. What in the world has happened here? Your investigative instinct goes into overdrive. This is not supposed to happen. Not in peacetime anyway. How can it be that this magnificent edifice, after gracing the town’s central square for who knows how many centuries, is now little more than a rubble pile in the center of town?

Revisiting simple concentration indexes

Revisiting simple concentration indexes

Reading Time: 1 min.

Revisiting simple concentration indexes

Our white paper Revisiting simple concentration indexes reviews the definitions of widely used concentration metrics such as the concentration ratio, the HHI index and the Gini and clarify their meaning and relationships.

01, Revisiting Simple Concentration Indexes

01, Revisiting Simple Concentration Indexes

We review the definitions of widely used concentration metrics such as the concentration ratio, the HHI index and the Gini and clarify their meaning and relationships.

Reading Time: 1 min.

Open Risk White Paper 1: Revisiting Simple Concentration Indexes

We review the definitions of widely used concentration metrics such as the concentration ratio, the HHI index and the Gini and clarify their meaning and relationships. This new analytic framework helps clarify the apparent arbitrariness of simple concentration indexes and brings to the fore the underlying unifying concept behind these metrics, thereby enabling their more informed use in portfolio and risk management applications. We also propose that the sensitivity of concentration indexes to growing concentration should be a defining criterion for adopting an index and explore the sensitivity of common indexes to changing portfolio concentrations. We show that this sensitivity can vary significantly between indexes for parametric families of portfolio distributions and hence selecting and using a simple concentration index should take this aspect carefully into consideration

FuriousBanker: The Credit Detox Challenge

FuriousBanker: The Credit Detox Challenge

Reading Time: 2 min.

FuriousBanker(TM) helps you learn risk management concepts in a fun and engaging way. This educational game series for mobiles and tablets is developed by Open Risk to enable modern interactive elearning for people working (or aspiring to work) in financial risk management.

The first episode sees FuriousBanker facing The credit detox challenge: