duck
Member of DD Central
Posts: 2,594
Likes: 5,793
|
Post by duck on Jan 22, 2016 10:51:57 GMT
MoneyThing ..... For me, the ideal would be to show the amount that I have already invested with the borrower so that I don't have to search for each loan in the loan list and add the values together to calculate total existing exposure. I can see where you are coming from Steerpike but I take a slightly different position.
I run spreadsheets for all platforms that I invest through and do indeed produce a £ figure for each borrower, but more important to me is the % for each borrower with respect to the total holding in each platform. So as the amount invested in the platform increases (or indeed decreases) the exposure follows the trend.
I am not suggesting that MT need to show these figures since they are so easy to produce. The point that I am making is that running a spreadsheet takes so little effort and allows you to produce the information that you desire and this in turn allows MT to keep things simple ...... which has to be of benefit to both MT and ourselves.
EDIT obviously lots of typing going on as I was composing this response but I still feel my point is valid
|
|
|
Post by MoneyThing on Jan 22, 2016 11:06:30 GMT
Morning,
For those who are trying to get a feel as to what appetite there might be on the two Portfolio's this afternoon, with 5 hours to go, as of 11am we have received circa £180,000 of new deposits since we sent out the email notification. (Note that some of this will be for the renewals as well).
Regards,
Ed
|
|
Steerpike
Member of DD Central
Posts: 1,962
Likes: 1,680
|
Post by Steerpike on Jan 22, 2016 11:10:15 GMT
MoneyThing ..... For me, the ideal would be to show the amount that I have already invested with the borrower so that I don't have to search for each loan in the loan list and add the values together to calculate total existing exposure. I can see where you are coming from Steerpike but I take a slightly different position.
I run spreadsheets for all platforms that I invest through and do indeed produce a £ figure for each borrower, but more important to me is the % for each borrower with respect to the total holding in each platform. So as the amount invested in the platform increases (or indeed decreases) the exposure follows the trend.
I am not suggesting that MT need to show these figures since they are so easy to produce. The point that I am making is that running a spreadsheet takes so little effort and allows you to produce the information that you desire and this in turn allows MT to keep things simple ...... which has to be of benefit to both MT and ourselves.
EDIT obviously lots of typing going on as I was composing this response but I still feel my point is valid
In my opinion, hundred or thousands of users maintaining simple spreadsheets is not the optimum solution to understanding at a glance how much is invested with a given borrower, I think it is far better for this information to be displayed with the loan information as is implemented on other sites.
|
|
paulg
Member of DD Central
Posts: 312
Likes: 189
|
Post by paulg on Jan 22, 2016 11:16:27 GMT
Morning, For those who are trying to get a feel as to what appetite there might be on the two Portfolio's this afternoon, with 5 hours to go, as of 11am we have received circa £180,000 of new deposits since we sent out the email notification. (Note that some of this will be for the renewals as well). Regards, Ed This is one of the things I like so much about MoneyThing - The openness and helpful interaction with their investors, and invariably in a timely manner. Always going the extra mile. Thanks Ed.
|
|
SteveT
Member of DD Central
Posts: 6,873
Likes: 7,918
|
Post by SteveT on Jan 22, 2016 11:17:29 GMT
MoneyThing ..... For me, the ideal would be to show the amount that I have already invested with the borrower so that I don't have to search for each loan in the loan list and add the values together to calculate total existing exposure. I can see where you are coming from Steerpike but I take a slightly different position.
I run spreadsheets for all platforms that I invest through and do indeed produce a £ figure for each borrower, but more important to me is the % for each borrower with respect to the total holding in each platform. So as the amount invested in the platform increases (or indeed decreases) the exposure follows the trend.
I am not suggesting that MT need to show these figures since they are so easy to produce. The point that I am making is that running a spreadsheet takes so little effort and allows you to produce the information that you desire and this in turn allows MT to keep things simple ...... which has to be of benefit to both MT and ourselves.
EDIT obviously lots of typing going on as I was composing this response but I still feel my point is valid
I agree that the MT website should avoid adding additional data that can easily be calculated offline. However the oft-requested "Download to CSV" button would make the loan-parts data extract process simpler and including a separate 2 or 3 letter "Borrower ID" field (eg. CS / AE / AS / BO / MT) would avoid the need to add this identifier manually to each loan-part. It's hard to extract the Borrower identifier from the loan name using an Excel formula as renewal loans now have the word "RENEWAL" after the loan number. If anyone's managed an Excel formula that does it consistently, please share it!
|
|
duck
Member of DD Central
Posts: 2,594
Likes: 5,793
|
Post by duck on Jan 22, 2016 11:31:11 GMT
Ignore the actual line/cell references in the example below (I just grabbed it from my partners AC account)
Assume the entry was Managed Portfolio (Electronics) (CSP232) - RENEWAL
=IF(ISNUMBER(SEARCH("CSP",D3996)), E3996,0)
would check the loan name cell (checking in this case D3996 for CSP) and then return the value in E3996 or zero ..... so it just finds the value that you are interested in and ignores the rest.
|
|
SteveT
Member of DD Central
Posts: 6,873
Likes: 7,918
|
Post by SteveT on Jan 22, 2016 11:36:56 GMT
That's fine to seek a specific borrower but I dump the loan parts data into a Pivot Table which totals all holdings by borrower. To do so, I have to maintain a manual "Borrower ID" field currently and edit it as old parts disappear and new ones are added
|
|
Investboy
Member of DD Central
Trying to recover from P2P revolution
Posts: 564
Likes: 201
|
Post by Investboy on Jan 22, 2016 13:37:40 GMT
I must disagree with SteveT and duck on the spreadsheet thing. MT have many loans but few borrowers: CS managed portfolios, AE managed portfolio, art pieces. All of them in reality are like one big loan to respective borrower. If one defaults its quite probable the rest will follow. So knowing exposure immediately on the site would be good. Maybe the simplest way would be just adding another column to loans listing with the name so we can sort / filter on that. Having an aggregate sum would be a next step. Rest of this post I've put to Web suggestions thread where it is more appropriate do discuss proposed new features.
|
|
|
Post by solicitorious on Jan 22, 2016 14:16:39 GMT
I can see where you are coming from Steerpike but I take a slightly different position.
I run spreadsheets for all platforms that I invest through and do indeed produce a £ figure for each borrower, but more important to me is the % for each borrower with respect to the total holding in each platform. So as the amount invested in the platform increases (or indeed decreases) the exposure follows the trend.
I am not suggesting that MT need to show these figures since they are so easy to produce. The point that I am making is that running a spreadsheet takes so little effort and allows you to produce the information that you desire and this in turn allows MT to keep things simple ...... which has to be of benefit to both MT and ourselves.
EDIT obviously lots of typing going on as I was composing this response but I still feel my point is valid
I agree that the MT website should avoid adding additional data that can easily be calculated offline. However the oft-requested "Download to CSV" button would make the loan-parts data extract process simpler and including a separate 2 or 3 letter "Borrower ID" field (eg. CS / AE / AS / BO / MT) would avoid the need to add this identifier manually to each loan-part. It's hard to extract the Borrower identifier from the loan name using an Excel formula as renewal loans now have the word "RENEWAL" after the loan number. If anyone's managed an Excel formula that does it consistently, please share it! The first thing MoneyThing should do is ensure that only the Loan ID appears within (). So (Electronics), (Gone Fishin') for example are invalid, and should be changed to Electronics, Gone Fishin', etc. Then the formula =MID(A1,FIND("(",A1)+1,2) will consistently return the first two characters of the Loan ID, for use in a Pivot Table, etc....
|
|
SteveT
Member of DD Central
Posts: 6,873
Likes: 7,918
|
Post by SteveT on Jan 22, 2016 14:19:11 GMT
That would certainly be a quicker change than adding a new "Borrower ID" column. Good thought!
|
|
|
Post by MoneyThing on Jan 22, 2016 14:24:27 GMT
I agree that the MT website should avoid adding additional data that can easily be calculated offline. However the oft-requested "Download to CSV" button would make the loan-parts data extract process simpler and including a separate 2 or 3 letter "Borrower ID" field (eg. CS / AE / AS / BO / MT) would avoid the need to add this identifier manually to each loan-part. It's hard to extract the Borrower identifier from the loan name using an Excel formula as renewal loans now have the word "RENEWAL" after the loan number. If anyone's managed an Excel formula that does it consistently, please share it! The first thing MoneyThing should do is ensure that only the Loan ID appears within (). So (Electronics), (Gone Fishin') for example are invalid, and should be changed to Electronics, Gone Fishin', etc. Then the formula =MID(A1,FIND("(",A1)+1,2) will consistently return the first two characters of the Loan ID, for use in a Pivot Table, etc.... Extra '()'s now removed. Ed
|
|
SteveT
Member of DD Central
Posts: 6,873
Likes: 7,918
|
Post by SteveT on Jan 22, 2016 14:35:25 GMT
The first thing MoneyThing should do is ensure that only the Loan ID appears within (). So (Electronics), (Gone Fishin') for example are invalid, and should be changed to Electronics, Gone Fishin', etc. Then the formula =MID(A1,FIND("(",A1)+1,2) will consistently return the first two characters of the Loan ID, for use in a Pivot Table, etc.... Extra '()'s now removed. Ed Excellent. That now automates the identification of all the CS / AE / BP loan parts. Only problem now is that the rest all begin MT, whereas we really need to be able to discriminate between the supercars, the property developer, the used car dealer, the classic car rental firm, the art collector, etc.
|
|
|
Post by MoneyThing on Jan 22, 2016 14:45:48 GMT
Extra '()'s now removed. Ed Excellent. That now automates the identification of all the CS / AE / BP loan parts. Only problem now is that the rest all begin MT, whereas we really need to be able to discriminate between the supercars, the property developer, the used car dealer, the classic car rental firm, the art collector, etc. Erm... any suggestions?
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Jan 22, 2016 14:52:07 GMT
Extra '()'s now removed. Ed Excellent. That now automates the identification of all the CS / AE / BP loan parts. Only problem now is that the rest all begin MT, whereas we really need to be able to discriminate between the supercars, the property developer, the used car dealer, the classic car rental firm, the art collector, etc. Agreed! Thanks MoneyThing. I was running a quick 'replace' to edit these fields down to one set of '()'s only. My version as a variation on a theme extracts the full Loan ID (whether 5 or 6 digit) if it's useful to anyone: =MID(F7,FIND("(",F7)+1,FIND(")",F7)-FIND("(",F7)-1) The only other one I have to manually work with is combined 'capital (& interest) repayment' entries. MoneyThing. Any chance of 2 seperate lines/entries? And no extra '()'s Though in this case the formula above successfully extracts the Loan ID as it is closest to the MID point of the string...........
|
|
SteveT
Member of DD Central
Posts: 6,873
Likes: 7,918
|
Post by SteveT on Jan 22, 2016 14:52:32 GMT
Excellent. That now automates the identification of all the CS / AE / BP loan parts. Only problem now is that the rest all begin MT, whereas we really need to be able to discriminate between the supercars, the property developer, the used car dealer, the classic car rental firm, the art collector, etc. Erm... any suggestions? Well, one option (without relabelling all the MT loans, causing mass confusion) would be to add a second identifier into the title of the MT loans in square brackets, so it can be picked up separately For example, MT308 (one of the supercar loans) could be titled: 2015 Ferrari 458 Speciale (MT308) [SC]
|
|