Friday, April 29, 2011

Playing with the numbers...

I've been experimenting with downloading the data from Lending Club.  (Warning - the data has to be scrubbed a bit before you can use the XML or CSV file) I've been interested in breaking down the numbers available on the website.

In particular the statistics on this page:

https://www.lendingclub.com/info/demand-and-credit-profile.action


So far, I have been unable to come up with numbers on this page using the downloaded data.  One item that has me a bit confused is the outstanding loans numbers.  It seems to include the "paid" loans.

It's weird, if you total up the paid, current, late, and default numbers it equals the outstanding loans number.  For example, on 4/28/2011, 5907 (Outstanding) = 852 (Paid) + 4938 (Current) + 50 (Late) + 67 (Default).  I would think the Outstanding loans would not include the Paid ones.

Also note, the number of grade F and G loans - barely a thousand between the two of them, with default rates over a 10% of outstanding.

Your thoughts?
 

No comments:

Post a Comment