Skip to content

Analysing counterparty risk

Let’s imagine that we operate a simple portfolio risk system which only tracks very limited information about the products we’ve bought from various sources:

2001-01-01
Run
Open in xt-fiddle

The system has only ever been required to hold a basic set of data for risk reporting because the trade execution platform kept its own rules for when to buy and sell stocks, and the extra integration work always seemed unnecessary.

Unfortunately however, a lack of easily accessible information combined with a severe market event can easily present a serious risk.

Imagine we just found out that a (fictional) major bank has collapsed: XY Bank.

Oh gosh, does our portfolio include any products managed by XY Bank?

Run
Open in xt-fiddle

Right, we probably should have done that integration work to keep track of what we bought from who owned what…

Not to worry, with a bit of manual effort and research we can add a table of which products are owned by various entities:

Run
Open in xt-fiddle

Now, what do we have to sell?

Run
Open in xt-fiddle

Ok, that’s a lot. But we can manage.

The question our own investors are now demanding an answer to though, is: how much did we just lose because of those products compared to if we had sold them before they ended up on XY Bank’s balance sheet? We didn’t keep track of when that happened!

Let’s add that in:

Run
Open in xt-fiddle

Just to double-check that’s not changed our current view of the exposure:

Run
Open in xt-fiddle

Nope!

Let’s start with figuring out when was each product last not owned by XY Bank:

Run
Open in xt-fiddle

Ok, now we know when we should have ideally sold and we can combine that with our prices to calculate how much we lost because of XY Bank’s collapse.

With our new and improved approach to historical record-keeping we’ll also now be in a better position to keep track of when products change ownership, and understand other impacts of corporate actions, so that we can more easily answer key investor questions in the future.


Should a prospective new investor a year from now ask why did we not sell these XY Bank products earlier - and having long since forgotten the details of the situation - we can quickly produce the answer:

Run
Open in xt-fiddle

Ah, see there. The audit information shows that we only started recording product owner changes recently. No wonder we didn’t sell earlier!