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…
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'
Related Posts -
Prosper Debt Sale Percentages 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...... -
RateLadder Loan And Portfolio Plan Power My Prosper Listing has 1 day left in the auction. I reached 100% funding late afternoon last Wednesday. Today is the final day to bid on my loan request. Short of an Act of God this loan is as safe as they come. My listing fell into the the conservative...... -
Prosper 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...... -
Prosper Upgrade Last Night 9/13/2007 From Prosper Andrew in the Forumns... Hi everyone, This release is going to be a little different than previous ones.... we have a few features/changes tonight, and then a few more dribbling in over the next couple of weeks. Changes include... Instant Transfers for Lenders After several months of beta...... - Prosper in May Set a New Monthly Loan Origination Volume High Water Mark (sql to produce statistics at the end of post) In May, Prosper originated more loan volume than in any previous month roughly 9.6M loans the vast majority were credit grades AA-C. This is great news for Prosper on 2 fronts: total volume and loan quality. Here is the breakdown... May......
Categories:
Uncategorized
Tags:
2 comments ↓
What are the units for the X axis?
Days Since Origination.
Leave a Comment