- Joined
- 5/6/06
- Messages
- 384
- Points
- 28
I have a question when trying to find the continuous function between credit spread and probability. Say, we have about 50 issuers bond and CDO in a portfolio. And I can get the credit spread for each of the issuer. I try to get a continuous function or a curve, if given spread, then I can calculate default probability. From the rating of each issuer, I get the default probability.
After plot the default and spread, I did regression analysis using Excel. I ended up with two functions: one is a 3rd degree polinomial with very small coefficients, the other is an exponential function. The residual for both are all small enough, but R-square of exponential is much higher...like .975. But regression from MATLAB shows poly graph fits better.
With only spread as one independent, did I get the correct function ? Or any good idea about how can I get the good curve ? :-k:-k:-k
Thanks a lot. :smt024
After plot the default and spread, I did regression analysis using Excel. I ended up with two functions: one is a 3rd degree polinomial with very small coefficients, the other is an exponential function. The residual for both are all small enough, but R-square of exponential is much higher...like .975. But regression from MATLAB shows poly graph fits better.
With only spread as one independent, did I get the correct function ? Or any good idea about how can I get the good curve ? :-k:-k:-k
Thanks a lot. :smt024