webwiz
Posts: 1,133
Likes: 210
|
Post by webwiz on Jun 16, 2015 16:48:10 GMT
I downloaded the Loan Book - just "because it was there" I suppose. Is there anything I can do with it?
|
|
|
|
Post by westonkevRS on Jun 17, 2015 17:43:56 GMT
I downloaded the Loan Book - just "because it was there" I suppose. Is there anything I can do with it? Win a prize if you can find my personal loan, and extra bonus if you find the loans I've lent into! Seriously I suppose its quite interesting to the analytical minds who simply like to create pivots and look for patterns, or look for the extreme loans (size, price, returns, etc). The issue is that the data doesn't include some important fields such as the Provision Fund contribution or an accurate measure of security, for example CommuterClub loans are secured. I personally didn't want to release the data, only because I knew it would raise more questions than answers and provide competitors with some insight. But the fans of transparency won the day! @ westonkevRSlink.ratesetter.com/8Ls46jswww.linkedin.com/profile/view?id=19236219
|
|
spiral
Member of DD Central
Posts: 908 
Likes: 455
|
Post by spiral on Jun 17, 2015 17:54:03 GMT
Seriously I suppose its quite interesting to the analytical minds who simply like to create pivots and look for patterns I thought I'd have ago this morning to try some crude "modelling" of the MR change. I had the bright idea that I could group all of the loans on a particular day and weight their interest rate before comparing with the trended daily rates. Wow I thought, MR is way below the weighted rate of the daily loans. The I had my Doh! moment. The rates on the spreadsheet were what the borrower paid and not what the lender got.
|
|
|
|
Post by westonkevRS on Jun 17, 2015 21:41:50 GMT
You can download the daily MR rates within the four markets directly from the stats page. I quite like this data as it allows you to compare MR within specific days in a month, and compare the across other months or previous years. For the record (AND NOT A RECOMMENDATION OR PROMISE, JUST A HISTORICAL ANALYSIS) day 21 of the month has the highest MR within the month, typically. So if you are a regular lender with a standing order to lend at the Market Rate, historical analysis indicates day 21 rather than start or end of month is the best recurring day in the month. westonkevRSlink.ratesetter.com/8Ls46js www.linkedin.com/profile/view?id=19236219 |
|
oldgrumpy
Member of DD Central
Posts: 5,087
Likes: 3,233
|
Post by oldgrumpy on Jun 18, 2015 7:53:59 GMT
Yep!! I reckon Sunday 21 June should be matching 5 yr at around 6.8-6.9% ... even 7%!  * <all pile in .... all undercut by 0.1% .... down we go to 6.4% ..... along comes Mr Fivenine with his £100K .... the whole prediction collapses, with a new MR of 5.9% on Monday>  * yeah but don't let your monthly lending go ahead on the 21st if it is a Monday or Tuesday .... |
|
jonah
Member of DD Central
Posts: 2,031
Likes: 1,113
|
Post by jonah on Aug 16, 2015 8:53:44 GMT
Is it me, or is the term length of the loan missing from these stats? I know that it can be repaid by the borrower sooner etc, but as some terms now have rates very close together, potentially even the same rate at different times in the same day but for different terms, this limits the analysis possible?
|
|
spiral
Member of DD Central
Posts: 908
Likes: 455
|
Post by spiral on Aug 16, 2015 11:35:50 GMT
Is it me, or is the term length of the loan missing from these stats? Term is the 5th column in my download!
|
|
jonah
Member of DD Central
Posts: 2,031
Likes: 1,113
|
Post by jonah on Aug 16, 2015 11:53:59 GMT
For me the 5th column is loan status, with repaid, late or similar. If it is repaid, then the 6th column shows when the last payment was made.
I do get an error about unreadable content and recovering the contents, so I wonder if that is the issue?
|
|
spiral
Member of DD Central
Posts: 908
Likes: 455
|
Post by spiral on Aug 16, 2015 17:19:02 GMT
For me the 5th column is loan status, with repaid, late or similar. Actually we may be talking at cross purposes here. I assumed that the loan book to which you referred was that which was available via AltFi which I assumed was one and the same as available from RS. Perhaps that isn't the case.
|
|
|
|
Post by nickthefool on Aug 17, 2015 9:01:26 GMT
I can confirm that the one you can download from the RS website (I did it last week too) has no info on term/market. Which does make it pretty useless.
|
|
|
|
Post by westonkevRS on Aug 21, 2015 20:02:19 GMT
For me the 5th column is loan status, with repaid, late or similar. Actually we may be talking at cross purposes here. I assumed that the loan book to which you referred was that which was available via AltFi which I assumed was one and the same as available from RS. Perhaps that isn't the case. None of the data books can be directly directly from AltFi anymore. RateSetter data was there, but some other platforms only allowed people to download the data from their own web sites and wouldn't put it onto AltFi.com. So in the end, all the platforms within this transparency initiative decided to only allow the downloads from their own sites. For RateSetter (and probably all of the platforms) it was easier to manage, we could ensure the data was accurate and obtain insight into how many people were interested. Some fields were removed (e.g. term), although I've never been involved in this process or decision. @ westonkevRS.
|
|
*
