treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Jan 22, 2016 14:53:32 GMT
Possibly add an extra identifying letter after the MT bit?
Too much work / implications?
|
|
alanp
Member of DD Central
Posts: 168
Likes: 72
|
Post by alanp on Jan 22, 2016 14:58:03 GMT
I'd prefer a simple, unique Borrower Identifier in it's own field and the same for the loan identifier.
Without a lot of hassle I couldn't work out what any of the earlier suggested Excel formulas are attempting to do or how they work and have no idea how or what a pivot table is.
KISS is my motto.
|
|
|
Post by MoneyThing on Jan 22, 2016 15:05:29 GMT
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]Perhaps it is best (to avoid ostracising the non-Excel experts), that we look at implementing a 'Borrower ID' identifier & perhaps an Excel/CSV export feature. Will revert back. Ed.
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Jan 22, 2016 15:07:54 GMT
I would be MORE than happy to have it all done for me!
|
|
paulg
Member of DD Central
Posts: 312
Likes: 189
|
Post by paulg on Jan 22, 2016 15:07:56 GMT
Possibly add an extra identifying letter after the MT bit? Too much work / implications? With the extra identifying letter in lower case.
|
|
|
Post by solicitorious on Jan 22, 2016 15:15:04 GMT
I'd prefer a simple, unique Borrower Identifier in it's own field and the same for the loan identifier. Without a lot of hassle I couldn't work out what any of the earlier suggested Excel formulas are attempting to do or how they work and have no idea how or what a pivot table is. KISS is my motto. As an aside, Excel is a skill well worth having, and there is a wealth of teach-yourself stuff on the internet. (Google is your friend) The basics are fairly easy to get into. I'd probably go as far as to say that anyone investing in hands-on type investments such as P2P will be at a serious disadvantage without at least a modicum of spreadsheet skills.
|
|
alanp
Member of DD Central
Posts: 168
Likes: 72
|
Post by alanp on Jan 22, 2016 15:51:30 GMT
solicitorious - Point taken and I agree. My "basic" Excel skills are fine and I have various spreadsheets to manage and project household budget, SIPP / ISA, overall pension planning and the like as well as a "simple" list of P2P investments by platform. I create these manually and if I am honest probably do may of the calculations in a roundabout, long-winded manner (but at least I understand them when I refer back to them and my OH can see my logic - even if she fails to agree with it). I know I really should get into it more but there are so many other more interesting things to do .
|
|
caesium
Member of DD Central
Posts: 86
Likes: 35
|
Post by caesium on Jan 22, 2016 16:02:32 GMT
Offtopic. moved to correct thread.
|
|
james
Posts: 2,205
Likes: 955
|
Post by james on Jan 22, 2016 16:18:02 GMT
MoneyThing Pretty sluggish again today at loan launches, from 16:00:00; seemed to recover at about 16:01:30. Just an observation, mind, not a complaint. It's a sort of informal feedback for MoneyThing, the collective opinion of investors about the bid limit prospective effectiveness: the higher the peak load, the less they trust that it will be sufficient. Though in this case the renewals complicated things because those were sure to go quickly and fast fingers was clearly going to be the only way in. Loan 235, the watches renewal, lasted 33 seconds. Loan 234, the electronics renewal, had a surprisingly large amount available and lasted for 78 seconds. At ten minutes in there's still £16,076 from £150,000 of loan 326 available. At 16 minutes £6,782. At 22 minutes £6,382. All sold at 62:45. At ten minutes in there's still £14,117 from £150,000 or loan 325 available. At 16 minutes £5,962. At 22 minutes £5,762. All sold at 62:35.
|
|
spiral
Member of DD Central
Posts: 910
Likes: 456
|
Post by spiral on Jan 25, 2016 9:24:13 GMT
Excellent. That now automates the identification of all the CS / AE / BP loan parts. Just looking at the detail on this. Although grouping them like this is useful, there is a further subdivision in some groups which relates to their specific borrowers. I can see that level of detail is irrelevant for CS loans but the property loans are more individual and just having them grouped by their "introducer" doesn't help much if they go on to borrow more funds. I think that any grouping needs to identify specific entities where their borrowings exceed a certain sum.
|
|
james
Posts: 2,205
Likes: 955
|
Post by james on Jan 25, 2016 10:21:28 GMT
Excellent. That now automates the identification of all the CS / AE / BP loan parts. Just looking at the detail on this. Although grouping them like this is useful, there is a further subdivision in some groups which relates to their specific borrowers. I can see that level of detail is irrelevant for CS loans but the property loans are more individual and just having them grouped by their "introducer" doesn't help much if they go on to borrow more funds. I think that any grouping needs to identify specific entities where their borrowings exceed a certain sum. Not sure that introducer is really the best term. The general structure is: 1. All loans by lenders are to MoneyThing directly. Every time we're discussing a loan here we're identifying the borrower, because it's always MoneyThing. 2. Moneything has already lent the money to their customer. The CS, AE and BP prefixes on a loan identify MoneyThing's customer in some cases, in others they use the generic MT prefix (supercars, for example). 3. In some cases their customer has or will also lend the money to someone else. Pawn and car HP/lease, for example, or the new loan to top up mortgage case. I don't think there are any cases where there is just an introducer relationship, with our money directly lent to the party that MoneyThing has lent to. In all three cases there is some security and an interest in that security is assigned to us as lenders to MoneyThing. So there are two groupings that need identifying for risk management: the MoneyThing borrower and where one exists, the borrower's borrower. In the case of many loans where there are lots of low value items or where it is in practice only going to be one loan per ultimate customer there's no issue with the borrower's borrower. The cases where identification of the borrower's borrower is needed are where it's viable for significant amounts to be borrowed across multiple loans, typically in the case of commercial property development, where there is both multiple borrowing from MoneyThing and potential borrowing buy the same borrower from or via a different platform (from in the MoneyThing case, via in the SavingStream case assuming they are now 36H compliant and the introducer, not the lender). However, I'm not sure that at present there are any cases where borrower's borrower information is needed. Do you have a specific example that's of interest, without naming MoneyThing's borrower?
|
|
spiral
Member of DD Central
Posts: 910
Likes: 456
|
Post by spiral on Jan 25, 2016 12:15:02 GMT
However, I'm not sure that at present there are any cases where borrower's borrower information is needed. Do you have a specific example that's of interest, without naming MoneyThing's borrower? The only example I can think of off the top of my head is a MT loan anyway so that prefix is already a problem in separating parts. Also there is one coming back for a second tranche this week.
|
|
|
Post by MoneyThing on Jan 25, 2016 13:55:21 GMT
Afternoon, As promised, please find attached the bids against these two loans. Kind regards, Ed Attachments:AE325 AE326 - BIDS.xls (55.5 KB)
|
|