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 exchangeConvert Prosper XML to CSV Many, Many people have asked me if there was an easy way to get the Prosper XML files as CSV (comma separated values).  In response, I have build a utility that does just that.  I contributed the utility to the Prosper API Open Source Project on SourceForge. With CSV files......
  • RateLadder.com Loan2 New Loans (Part 1/2) -- CCSJ Marketing Acquisition & Expansion -- $20,000 at 15.65% -- C Credit -- DTI 14% A new loan funded this afternoon (CCSJ Marketing Acquisition & Expansion   (Loan #6383) — $20,000 at 15.65%).  I participated via my standing order: Low DTI -- AF.  Which is this loan was funded as a low debt to income ratio and was an auto-funding loan.  The borrow had C......
  • 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 exchangeProsper 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......
  • 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 Exchange Related Websites
  • DOW JONES Index Fibonacci Review This week we look at the chart for The Dow Jones Index as our example of using the Fibonacci series. Most Stock market technical analysts/traders commonly use tools such as Fibonacci & Gann analysis methods as part of their investment strategy, as they prove useful in showing points of high......
  • snowboardBear Mountain Ski Resort, Big Bear Lake, CA Bear Mountain Ski Resort is located in: Big Bear Lake, CA Phone: (909) 585-2519 Website: http://www.bearmountain.com/index_winter.php About the Resort: Bear Mountain Ski Resort is sumptuously appointed, and it is a true skiers paradise. This resort is known for their terrain parks and snowboarders from all over the world flock here......
  • blog traffic exchangeMigraine help, what do you think? I am a 17 year old caucasian male, I reside in South Carolina. I have had several problems this year with migraines, but this one by far has been the worst. I was hospitalized back in October for a migraine that lasted for 2 weeks. The objective of the hospitalization......
  • blog traffic exchangeWednesday Lotto AU 1.5million No change in strategy today, as both aspects look strong, under 33 mainly or all, and within recent 4-7 draws. Due mainly to Saliu ION Filters being fairly low for a few draws, and having ANY 6 Filters of 43 and 35 in draw 7 and draw 9, all point......
  • widgicreekgcWidgi Creek Golf Club, Bend, OR Widgi Creek Golf Club is located in: Bend, OR Phone: (541) 382-4449 Website: http://www.widgi.com/golf/hours.cfm Course History: This is a great place to stop if you will be in the Bend, OR area. We fell in love with this course and can't wait to go back. It is extremely beautiful and......
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