Gaussian copula modelling

daweinzettl

New Member
Dear All,

I am referring to the BIONIC Gaussian copula video on youtube. Can someone please explain (I need the formula and its derivation) how to get to the joint cumulative distribution function of 0.71 for two bonds with marginal cum. dist. function of 5% each and a correlation of 0.3?

Many thanks!
 
Last edited:

David Harper CFA FRM

David Harper CFA FRM
Subscriber
hi @daweinzettl

We have a copula XLS in a learning spreadsheet, but Meissner has a (better) one associated with his new book http://www.amazon.com/dp/111879690X/?tag=bt077d-20 (FRM assigned) and I noticed that, as it should, his gives the same result of 0.71% for these assumptions.

Here is the his spreadsheet https://www.dropbox.com/s/uc47aaaomyqjc6s/2-asset_default_time_Copula.xlsm?dl=0
It's a bivariate cumulative normal distribution and mine follows John Hull @ http://www-2.rotman.utoronto.ca/~hull/technicalnotes/TechnicalNote5.pdf

I hope that helps
 

daweinzettl

New Member
David, I appreciate your answer, but I still do not know how the joint default prob. in your and Meissner's spreadsheet is derived. His spreadsheet "2-asset default time" contains a subroutine "bnc" and in the book ("Correlation Risk Modelling", page 81) there is no math or explanation about the formula of the subroutine.
 

David Harper CFA FRM

David Harper CFA FRM
Subscriber
Last edited by a moderator:
Top