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-play

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-play

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

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-play

Now, what do we have to sell?

Run
Open in xt-play

Okay, that’s a lot, but we can manage.

The question our own investors are now demanding an answer to, though, is how much we just lost because of those products compared with selling 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-play

Just to double-check that hasn’t changed our current view of the exposure:

Run
Open in xt-play

Nope!

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

Run
Open in xt-play

Okay, 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.


If, a year from now, a prospective investor asks why we did not sell these XY Bank products earlier, we can quickly produce the answer, even if we have long since forgotten the details of the situation.

Run
Open in xt-play

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