|
|
Post by Deleted on Nov 3, 2019 13:43:21 GMT
I've just downloaded my loan book. It looks like labels for the markets have changed eg C1 is now C and A2 is now A.
Has anyone else noticed? I've got a spreadsheet that summarises my (few remaining) loans and flags up any that are able to be sold. I don't want to amend the formulae if it's just some sort of weekend blip.
|
|
aju
Member of DD Central
Posts: 3,500 
Likes: 924
|
Post by aju on Nov 3, 2019 14:32:56 GMT
I've just downloaded my loan book. It looks like labels for the markets have changed eg C1 is now C and A2 is now A. Has anyone else noticed? I've got a spreadsheet that summarises my (few remaining) loans and flags up any that are able to be sold. I don't want to amend the formulae if it's just some sort of weekend blip. I've just checked my ISA and you are right I've checked it against one from July i'll check against last month and see if it changed more recently. Edit: Just checked last months and it has the old C1 and A2 as you say which are now reporting C and A. Well spotted.
|
|
|
|
Post by Deleted on Nov 3, 2019 14:46:24 GMT
Thanks for the reply. I could previously see A*, A1 and A2 - presumably these aren't separated any more, in the loan book at least.
I've previously analysed actual vs expected default rates by market and duration (which was the catalyst to me selling out as much of Zopa as I could) - this will no longer be possible, or not to the same level of accuracy anyway.
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Nov 3, 2019 15:04:56 GMT
Thanks for the reply. I could previously see A*, A1 and A2 - presumably these aren't separated any more, in the loan book at least. I've previously analysed actual vs expected default rates by market and duration (which was the catalyst to me selling out as much of Zopa as I could) - this will no longer be possible, or not to the same level of accuracy anyway. Yeah I've notice they seem to have stripped out anything with a number, A1, A2, C1. Recently they had changed some of them but I thought it was just to separate the recent Car loan types secured and not secured.
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Nov 3, 2019 15:40:36 GMT
I can still see A* but to be honest its probably that they have been criticised for have different markets to those in their risks docs etc. Anyway I did not see any comms regarding this change so I've sent yet another email to see if any light can be shone on what's happened and why.
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Nov 7, 2019 17:14:13 GMT
Got this response today from zopa today Perhaps we should be grateful we are one of the "Few"  |
|
johni
Member of DD Central
Posts: 369
Likes: 329
|
Post by johni on Nov 16, 2019 10:30:50 GMT
The comments section has been removed so it is now more difficult to see when missed payments have occurred
|
|
|
|
Post by Deleted on Nov 16, 2019 16:39:30 GMT
The comments section has been removed so it is now more difficult to see when missed payments have occurred In my experience the comments field wasn't kept up to date other than to say something like "Set to default".
|
|
|
|
Post by ruth77 on Nov 17, 2019 8:39:05 GMT
I used to use the comments field to check for pending replacements, in an attempt to make my arrears look less intimidating. Even more annoying is that the current loan book, when viewed online, shows part of the Comment with a tip that suggests downloading a csv file in order to see it in full.... I feel a mail to Zopa coming on!
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Nov 17, 2019 9:40:40 GMT
I used to use the comments field to check for pending replacements, in an attempt to make my arrears look less intimidating. Even more annoying is that the current loan book, when viewed online, shows part of the Comment with a tip that suggests downloading a csv file in order to see it in full.... I feel a mail to Zopa coming on! Me too, perhaps i asked too many question they are trying to cut down on mr emails  With all these changes i think i'm going to be busy next month integrating all this into my spreadsheets. I hope they haven't changed the statements as well!
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Nov 17, 2019 9:44:28 GMT
I downloaded my loan books tonight. There’s been some changes to the format with a bit more information available. Additional header labels are: * type of loan * borrower origination fee * loan servicing fee * transaction price * transaction date * interest outstanding * days in arrears * default price * type of asset The comment column has gone. Not sure how useful some these new fields will be to us lenders who use these tables.
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Nov 17, 2019 12:21:28 GMT
Sadly I assumed the new fields would be at the end but now looking at the changes it seems the fields are all over the place. What a mess, I can't believe this is what they intended. Hopefully they will explain the borrower info which seems to suggest that some borrower fees are as high as 20% of the loan amount. £2500 loan was £500 the borrower rate was 10.41% and my cut was 6.81% with a servicing fee of 3.6% Not sure if it helps anyone be here are the changes both by name and by positions. I'm not sure how to change my tables as yet and whether it might be better to provide an additional loader step to force existing layouts. Old Name and Column Position New name and Column position
------------------------------------ ---------------------------------
1. Borrower ( 1) 1. Borrower ID ( 1)
2. Product ( 2) 2. Product ( 2)
3. Acquired ( 3) 3. Acquired ( 3)
4. Market ( 4) 4. Market ( 4)
5. Type of loan (--)
5. Term ( 6) 6. Term ( 5)
6. Loan size ( 7) 7. Loan size ( 6)
7. Status ( 8) 8. Loan status ( 7)
9. Borrower origination fee (--)
10. Borrower rate (-9)
11. Loan servicing fee (--)
8. Investor rate (12) 12. Investor rate ( 8)
9. Borrower rate (10) 13. Transaction price (--)
14. Transaction date (--)
10. Lent (15) 15. Amount invested (10)
11. Outstanding (16) 16. Capital outstanding (11)
17. Interest outstanding (--)
12. Repaid (18) 18. Amount repaid (12)
13. Capital repaid (19) 19. Capital repaid (13)
14. Interest repaid (20) 20. Interest repaid (14)
15. Arrears (21) 21. Amount in arrears (15)
22. Days in arrears (--)
16. Repayment day (23) 23. Repayment day (16)
17. Safeguard (24) 24. Covered by Safeguard (17)
18. Comment (Removed) (18)
19. Loan start date (25) 25. Loan start date (19)
20. Scheduled end date (26) 26. Last repayment date (20)
27. Default price (--)
21. Default date (28) 28. Default date (21)
22. Expected Repayment (29) 29. Monthly repayment amount (22)
30. Type of asset (--)
23. Loan purpose (31) 31. Loan purpose (23)
24. Repaid % (32) 32. Percentage repaid (24)
edit: The table above has changed again now the comments data has been added back in at row 18 you can find the changed sections here. All of the references marked in red have changed from that point onwards. |
|
|
|
Post by ruth77 on Nov 17, 2019 12:54:17 GMT
Thanks for that very helpful chart - I foresee a lot of spreadsheet editing coming on. Only hope I don't finish and then find they've reinstated the Comment column somewhere near the beginning!
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Nov 17, 2019 13:05:14 GMT
Thanks for that very helpful chart - I foresee a lot of spreadsheet editing coming on. Only hope I don't finish and then find they've reinstated the Comment column somewhere near the beginning! Well I've started analysing some initial data against previous loanbooks and it seems to me some new fields like "transaction date" and "transaction price" are not clear where they are useful or not as in both cases there are columns that already provide exactly the same information as far as I can see so far. I've only checked my invest data as yet for myself I will be checking other fields usefulness as well across my ISA and also Mrs Aju products to get a better feel. At present I'm hoping that I can have an interim loader tab (excel 2007) with my original loader tabs and just use my original loanbook loader tab as the data source and copy the new loader across based on whqat I need rather than what Zopa wants me to have. Any other ideas gratefully received.
|
|
|
|
Post by ruth77 on Nov 19, 2019 16:19:56 GMT
I have just had a reply from Zopa regarding the changes to the loan book extract. Apparently the changes were made in order to comply with new FCA regulations, and I was far from the first to complain about the new layout with insertion/renaming of fields breaking all uploads.
The Comments field however is no more as they felt "... it didn't add any more information than the table already provided".I shall give them a list of things I used it for, and ask how I am expected to determine these from the table.
|
|
