Daily Late 0 DQ Vintage Curves

You may have seen my Prosper vintage curves… While they were hard to make since the data had to be pulled off the Prosper Loan Performance page. These are now much easier with the private lender data (see the sql at the end of the post for those that are so inclined.)  Here is a post for the general population daily vintage curves.

Check out the Daily Count Late Percentage Vintage curve for 0 current DQ…

Daily Late Vintage Curves 0 DQ Count Percentage 

Using this sql:

(You need a table alldays with 1 column aday and a row for every day). (Unfortunately this sql takes a long time to run (10 minutes) so you won’t be able to run it on ProProsper as the query timeout is set to 30 seconds).

DECLARE @DTD int
SET @DTD=30
SELECT
cast(aday-originationdate as int) as 'PIT',
l.creditgrade,
sum(PrincipalBalance+NetDefaults) as 'Amount',
count(l.[key]) as 'Count',
sum(case WHEN (mld.DPD!=0 and (mld.DPD+(aday-observationdate))>@DTD) THEN PrincipalBalance+NetDefaults ELSE 0 END) as 'AmountLate',
sum(case WHEN (mld.DPD!=0 and (mld.DPD+(aday-observationdate))>@DTD) THEN PrincipalBalance+NetDefaults ELSE 0 END)/sum(PrincipalBalance+NetDefaults) as AmountLatePercentage,
sum(case WHEN (mld.DPD!=0 and (mld.DPD+(aday-observationdate))>@DTD) THEN 1 ELSE 0 END) as 'CountLate',
sum(case WHEN (mld.DPD!=0 and (mld.DPD+(aday-observationdate))>@DTD) THEN 1.0 ELSE 0.0 END)/count(l.[key]) as 'CountLatePercentage'
FROM
loan l
inner join creditprofile cp on cp.listingkey=l.listingkey
inner join LoanPerformance mld on l.[key]=mld.loankey cross join alldays
where
mld.observationdate = ( select top 1 observationdate from LoanPerformance sub where sub.observationdate < aday and sub.loankey=mld.loankey order by sub.observationdate DESC )
and aday < getDate()
and aday >= '02/01/2006'
and l.creditgrade!='NC'
and cp.currentdelinquencies=0
group by
cast(aday-originationdate as int),
l.creditgrade
having
count(l.[key])>250 and
sum(PrincipalBalance+NetDefaults)>0
order by
'PIT'

Blog Traffic Exchange Related Posts
  • General Loan Population Vintage Curves Amount LateProsper Vintage Curve Update -- 1/1/2008 Continuing the theme of tracking the late or worse vintage curves.  Each curve lasts only as long as there are 250 loans in the bucket.  The curves progress in time from the loan origination date.  The measurement is the percentage of money late or worse.  After a debt is defaulted......
  • blog traffic exchangeLending Club Liquidity and Capital Resources I read through the Lending Club S1 finally...  I found a few parts of the S1 interesting...  Over the next few day I will lighlight a few of my favorite sections.  I am not a lawyer nor do I claim to fully understand everything that I am reading.   I am simply copying......
  • blog traffic exchangeBidding With the Prosper API Code Example QuickSnipe.java For my ProsperDays presentation this year I will demonstrating bidding with the Prosper API...  I have built a quick and dirty bid snipping java program.  (This program is not ready for primetime as bid sniping tool, but it is very close and a very effective demo.  The reason I say......
  • General Loan Population Vintage Curves Count LateProsper Vintage Curves From Private Data You may have seen my Prosper vintage curves...  While they were hard to make since the data had to be pulled off the Prosper Loan Performance page. With the new private lender data these vintage curves can be pulled with sql and excel greatly expediting the process. Check out the......
  • Vintage Curves 12/2007Prosper Vintage Curves 12/1/2007 Today we are updating the vintage curves for 12/1/2007.  (Here is the original explanation.) The number of loans required for display is 250. There are 3 different populations shown across both count late % and amount late %. General population. All loans in credit grade. Loan Count Late % Dollar......
Online Stores If you liked this article, vote for it on del.icio.us and stumbleupon.


Categories:

Uncategorized



Tags:

,


2 comments ↓
#1 Mike on 12.19.07 at 8:32 pm

What are the units for the X axis?

#2 Kevin on 12.19.07 at 8:39 pm

Days Since Origination.

Leave a Comment

aa algorithm axis azerbaijan banks benefit blog borrowers ceo Collections credit grade credit history credit information credit score curves doug fuller email friends and family good luck google income borrowers interest rate interest rates investments launch lenders lending institutions liquidity loans marketplace money mozambique peer to peer lending portfolio plan private data promissory notes quiet period registration statement risk securities and exchange securities and exchange commission spreadsheets sql student loans Zopa