Wednesday, February 6, 2008

Overview of Features:

I thought it was time to create another overview of the features my extension provides. Basically, wherever you find a magic wand hover or click to learn more about that feature. Most features popup additional info.

In this blog, click the images to see them larger.



On a listing detail page you will notice two new sections of links.


  • Hide: prevents the listing from showing up on search results

  • Watch: add this borrower to my extension's favorite list. Watching a borrower allows for relists to show up on your favorites list

  • Alert: if you use gmail you can easily receive email alerts as the listing approaches its ending time

  • Notes: you can save notes about the borrower (not the listing) again great for relists or borrowers coming back for a 2nd loan


The Market Analysis is my favorite addition. These links all make use of Prosper's Marketplace performance page. I just plug in the relevant information to limit the search to similar loans. Typically I just click the magic wand on these to see the popup. If you want to see the full page, click on the broad, narrow, specific link to open a new window to Prosper's Marketplace performance page. Here is an example after clicking the Broad magic wand.



So much useful info here. First hover of (details) and it will tell you what criteria is used for this info. Very useful when you click on the Specific magic wand. This average interest rate is more reliable than the one Prosper gives, which is based on huge buckets. Mine is more relevant to the listing you are examining. On this popup I examine the percent of loans that are current. In this example it is 78.77%, that gives a 21.23% chance of defaulting. Historically 85% of loans that go 1 month late default. So I count any loan that is late at any point as defaulted.

I examine the broad and specific market analysis the most. I strive to only bid on listings that have a specific chance of defaulting less than 10%. Not shown, but this particular listing had a specific 19% chance of defaulting.

After examining the chance of defaulting, I will then click on Similar Loans. This opens a new window that shows all the loans that are defaulting that are similar to this listing. This gives you the opportunity, if you wish, to examine every loan to try and determine why it defaulted... and determine if your listing is like those and therefore has an increased chance of defaulting. Depending on the number of loans that are similar this page can take awhile to load... so often I will click it first then go back to the original listing and perform analysis, then go check the similar page.



The loans are displayed in descending origination date... most recent first. See all those magic wands... click on them... do not click on the listing link as this will open the listing in the browser, and the similar loans will have to be reloaded. I'll try and automatically open the listing in a new window. Back to the magic wands... they will display the listing description, the credit info, the borrower description... all in nice popups. For the credit info you have to provide your login information... don't worry I do not keep it. This is required to access the data through Prosper's API.

If you do this enough you will often see the lightning bolts... as I have said before... the lightning bolt increased your chance of getting burned... stay away from them.

Now start clicking on the magic wand next to the loan's credit info. You will quickly start to see trends.... does your listing match these? If so stay away.

There is just so much information in this page hopefully you will take the time to study and learn.

At the very top of the page is a link in big capital letters... VIEW ADDITIONAL INFO. Click it and you get something like this in a new window:

Loan Origination
Year.Month : Total : Late Loans
2006.04 : 2 : 1 : 50.00%
2006.05 : 2 : 2 : 100.00%
2006.07 : 1 : 0
2006.08 : 4 : 1 : 25.00%
2006.10 : 1 : 0
2006.11 : 4 : 1 : 25.00%
2006.12 : 4 : 0
2007.01 : 15 : 3 : 20.00%
2007.02 : 7 : 4 : 57.14%
2007.03 : 8 : 2 : 25.00%
2007.04 : 20 : 9 : 45.00%
2007.05 : 8 : 2 : 25.00%
2007.06 : 16 : 1 : 6.25%
2007.07 : 6 : 0
2007.08 : 8 : 1 : 12.50%
2007.09 : 14 : 3 : 21.43%
2007.10 : 7 : 1 : 14.29%
2007.11 : 19 : 0
2007.12 : 8 : 0
2008.01 : 11 : 0
Thru 2006.6 :4 : 3 : 75.00%
Thru 2006.12:12 : 5 : 41.67%
Thru 2007.6 :86 : 26 : 30.23%
Thru 2007.12:115 : 31 : 26.96%
Total :165 : 31 : 18.79%
Number of similar loans created in the past month: 7

Dates of significant change: Aug-2006 and Feb-2007
Additional credit info was added on these dates


Again you can learn a lot about this data. In this case not a lot of similar loans are created each month. You can see that the trend for the defaulting rate is rising. As you hopefully already know, as loans age the default rate increases. This page attempts to show you how drastic this trend is.

I have also added some quick links to useful information to the borrower info section on the listing detail page.



These next few features are vital to my analysis of the listing... sorry I have not uploaded images of these.

The wand next to the group name will popup a detailed list of this group's default success or failure... number of loans, etc. Click the wand next to the Q&As and you will see all of them, rather than just the first few. Click the wand next to the recent listings and you will see all of the listings... not just recent. Right click in the popup to view the prior listings... you can learn a lot by doing this!

In the Endorsements section I add a link called Verify Bids which will determine if the endorser's bid still stands. Typically GLs bid at the highest rate, get bid off... some even practice pump and dump... bid large, large amounts to attract attention.

Thursday, January 31, 2008

Version 2.1.3: New average rate

First - please let me know if you have any issues with this install. I have changed an underlying component that should not impact anyone... but since there are so many window's configurations ... never say never.

I have been placing the average rate on the listing detail page and the listing search page. This of course gives you guidance on the listing's interest rate to determine if you are getting a good rate.

However, I have used Prosper's rolling 30 day average rate which I have long felt was flawed. This rate is based on huge loan buckets, $1000-$5000 and $5001-$9999 and $10,000-$25,0000. In case you don't want to do the math, that is a $15k spread on the large loans and about $5k on the other ones.

To me there is a huge difference between a $10k listing and a $25k listing.

I have added to my Market Analysis popups the average rate for loans that are similar to the listing. So click on the Broad, Specific, Narrow, etc. magic wands and you will see the average lender rate based on that criteria. This will give you a much more realistic average rate.

I utilize Prosper's marketplace performance page to get this info. So sometimes the Specific selection will not return an average rate if the marketplace performance page has none. Use the Broad in this case.

Saturday, January 26, 2008

Version 2.1.2: Updated to similar loans

It once again displays the loans in descending date order. This way it is easier to see the more recent loans and determine why they defaulted. Also on the additional info link on the similar loan page I have added some summary stats like this:

Thru 2006.6 :11 : 2 : 18.18%
Thru 2006.12:48 : 9 : 18.75%
Thru 2007.6 :102 : 15 : 14.71%
Thru 2007.12:102 : 15 : 14.71%
Total :334 : 15 : 4.49%

Basically it shows the number of loans and number of defaulted loans for the various periods. As in this example... even though the average for the entire loan set is 4.4%, you can see a trend as the loans age for the default rate to jump to 14%.

Just another metric I use to look for reasons not to bid on a loan. That is the essence of my advice. The more I study the similar loans prior to bidding, the better I understand what to look for in new listings that I bid... I highly recommend you spend the time as well.

Tuesday, January 22, 2008

Need your help

Prosper's censors on the forums have decided to silence my posts. For the past week I have attempted to post about 10 replies... none have appeared. I was offering my analysis of particular listings posted in the lender forum... utilizing the features of my extension.

Yet my posts did not have links to my sites, this blog. Instead I referred people to my Prosper member page to read further about my strategies.... which I did list my blog there.

I have requested an explanation from support in an email... no response.

If you have been frustrated with Prosper's new censorship policies on the forums please send support a message complaining.

Maybe if enough lenders complain we can bring a more productive forum back to Prosper.

Thursday, January 17, 2008

Version 2.1.1: new feature on similar loans

Some minor fixes around Similar loans. And a new feature. Once you click on Similar Loans on the detail page a new window pops up showing all the defaulting loans similar to the listing you are reviewing. A new link appears at the top of this new page. "View Additional Info" Okay not a very creative title.

This will popup another new window that shows a month by month breakdown of the defaulting loans... showing how many originated in each month and how many of those are now defaulting. Why is this interesting you ask?

You can see the trend of defaults increasing as loans age. In this example the older loans from 2006 are defaulting at 20-30% yet the average is 9%. So I would expect the newer loans to trend up towards the 20%. So over time you have a 20% chance that this listing will default.

Loan Origination
Year.Month : Total : Late Loans
2006.02 : 4 : 1 : 25.00%
2006.03 : 4 : 0
2006.04 : 13 : 4 : 30.77%
2006.05 : 10 : 2 : 20.00%
2006.06 : 20 : 4 : 20.00%
2006.07 : 13 : 3 : 23.08%
2006.08 : 25 : 5 : 20.00%
2006.09 : 26 : 3 : 11.54%
2006.10 : 24 : 3 : 12.50%
2006.11 : 14 : 3 : 21.43%
2006.12 : 14 : 2 : 14.29%
2007.01 : 33 : 0
2007.02 : 36 : 5 : 13.89%
2007.03 : 39 : 3 : 7.69%
2007.04 : 38 : 8 : 21.05%
2007.05 : 54 : 3 : 5.56%
2007.06 : 46 : 6 : 13.04%
2007.07 : 54 : 5 : 9.26%
2007.08 : 50 : 4 : 8.00%
2007.09 : 40 : 1 : 2.50%
2007.10 : 39 : 1 : 2.56%
2007.11 : 36 : 0
2007.12 : 63 : 0
2008.01 : 2 : 0
Total :697 : 66 : 9.47%

Number of similar loans created in the past month: 65

Dates of significant change: Aug-2006 and Feb-2007
Additional credit info was added on these dates

Wednesday, January 9, 2008

Version 2.1.0: Fixes to site changes

Well it has been awhile... a few features had stopped working when Prosper changed their site. This update restores most features. Nothing new was added but minor features had to be removed because of the Prosper changes.

The most useful features I still believe are the Market Analysis popups and Similar Loans. Don't leave home without them!

Also check out my analysis of Member Growth. Basically Prosper's growth has been static.

Tuesday, November 6, 2007

Version 2.0.3: Fix to the crash

Thanks to a couple of users I was able to find two crashes caused by the recent changes to use the new API. I will look for more but these were the two obvious ones.