Listings, Unique Bidders, Loans, Average Interest Rate, and Total Amount Lent

Some of these are leading indicators and some are trailing. Do you see a pattern?

Month # Listings # Unique Bidders # Loans Average Interest Rate Total Lent
11/2005  39 12  13  10.56%  $47,800
12/2005  20 17  9  7.57%  $30,887
1/2006  48 21  8  8.23%  $45,120
2/2006  832 266  75  11.45%  $457,934
3/2006  3,607 901  241  15.71%  $1,083,283
4/2006  5,485 1,206  294  17.52%  $1,533,595
5/2006  6,997 1,850  461  16.64%  $2,088,589
6/2006  5,381 2,319  521  17.84%  $2,140493
7/2006  5,550 2,655  551  17.91%  $2,351,747
8/2006  7,430 3,318  772  18.82%  $3,921,513
9/2006  6,799 3,625  615  18.69%  $3,147,256
10/2006  10,942 4,425  743  18.56%  $3,794,644
11/2006  11,267 5,118  701  18.45%  $3,316,355
12/2006  9,455 7,036  969  17.72%  $4,505,572

 

Here is the Sql (Jan 2006 as example month):

# Listings:

select count(distinct [key]) from listing where creationdate>=’1/1/2006′ and creationdate<'2/1/2006'

# Unique Bidders:

select count(distinct memberkey) from bid where creationdate>=’1/1/2006′ and creationdate<'2/1/2006'

# Loans:

select count(distinct [key]) from loan where creationdate>=’1/1/2006′ and creationdate<'2/1/2006'

Average Interest Rate: I did this as a crystal report using a weighted average for amount borrowed

Total Lent:

select sum(amountborrowed) from loan where creationdate>=’1/1/2006′ and creationdate<'2/1/2006'

 

Blog Traffic Exchange Related Posts
  • blog traffic exchangeProsper vs Lending Club -- The First 100 Days Last week Lending Club had a post about their first 100 days -- 100 Days and a Million Dollars in Loans!...  This got me thinking, how does that compare with Prosper's first 100 days? Here are the Lending Club loans from that article... Loans issued   172 for $1,046,000 On......
  • blog traffic exchangeMeasuring Social Capital So my loan on Prosper closed at a final rate of 9%.  What was my social capital worth?  Did being a known quantity in the Prosper community help? To start with I decided to try and measure the average loan rate and standard deviation... I used the ProProsper Loan Rate......
  • blog traffic exchangeState Default Rates -- A Publishable Application of the RateLadder ListingKey In the past I have talked about my technique for adding a ListingKey to the Loan table of the Prosper.com data export.  While I had successfully added the key several weeks ago I hadn't found an application of the key that I could publish until recently.  A fellow Princetonian and prosper lender......
  • blog traffic exchangeProsper Facilitates 60 Million in Loans From People to People Here is today's marketplace data...   Date: Principal Closed: # Loans: # Registrations: # Lenders: # Borrowers: # Groups: # GLs: Historical Interest Rates Credit Grade Group Member Average Rate Less Than 5K Average Rate 5K to 10K Average Greater Than 10K NC 0       HR 0 0.26008......
  • blog traffic exchangeMy Prosper Internal Rate of Return Update (End of Jly 07) = 0.57% This is a RateLadder only IRR update. (An IRR lender “game” update is in the works.) I saw a big spike in loan 1 month late or more. Here is my permanent tracking page: http://rateladder.com/my-prosper-irr/ My Prosper IRR is defined as: Monthly cash flows with one extra month using the......
Blog Traffic Exchange Related Websites
  • blog traffic exchangeMonday Lotto AU 1million Once again, sticking to the same strategy followed the last few draws, small numbers under 33, and derived from previous 7 draws or less. These are the 2 factors due to come into play, maybe seperately, maybe together. It is taking a bit of a punt, but using both factors......
  • blog traffic exchangeMonday Lotto AU 2million Today's Lotto looks the best prospect so far, for a narrow ANY 6 draw. All numbers should be derived from those of the previous 5 draws, if not, it will probably blow out and the next draw will be the tight one. The Saliu Filters look extremely favorable. This reduces......
  • blog traffic exchangePowerball AU 40 million Tonight's Powerball Jackpot of AU $40 million is the biggest ever offered on Australian Powerball. If one person wins the entire $40 million Jackpot, they will become Australia’s largest ever lottery winner! It is good value to have a go today, even if they are hard to pick. The Saliu......
  • Law School Rankings photoLaw School Rankings If you are an aspiring law student and you are looking for the top law school around, you might already have a vague ides on what schools those are. But according to reports and according to the Top Law Schools website, here is the 2010 law school rankings: 2010......
  • blog traffic exchangeSchindler's Actual List In 1980, a writer named Thomas Keneally was buying a new briefcase in Beverly Hills, California. The shopkeeper, Leopold Pfefferberg, was a Polish Jew who had an interesting personal story of how a man named Oskar Schindler saved him and over a thousand other Jews from Nazi extermination in World......
Online Stores If you liked this article, vote for it on del.icio.us and stumbleupon.


Categories:

Prosper.com, Tools



Tags:

,


0 comments ↓

There are no comments yet...Kick things off by filling out the form below.

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