With the release of the new private data I thought I would write most of my posts this week on nuggets on information that can be pulled out of the data…
This first post is on the debt sale amount as a percentage of principal balance at the time of the debt sale… I know you can find previous debt sale figures here, but sometimes you like to check for yourself. (leporello you know who you are.
To create the follow chart I wrote some sql (see sql at the end of the post) and did a simple pivot in excel.
Here is the sql to generate the data… The only remotely tricky part was getting the principal balance on the same line as the net default and filtering out data that I didn’t want. I also linked to the loan object to get the creditgrade… One could take this further and filter the results on any loan or listing column.
cast(datepart(mm,nd.observationdate) as varchar(2))+’/’+cast(datepart(yyyy,nd.observationdate) as char(4)) as obervatiomonth,
min(fp.principalbalance) as PrincipalAtDefault,
(min(fp.principalbalance)-nd.netdefaults)/min(fp.principalbalance) as defaultPercentage
and NOT(nd.status like ‘%bankruptcy%’)
Related PostsRelated WebsitesOnline StoresIf you liked this article, vote for it on del.icio.us and stumbleupon.