aju
Member of DD Central
Posts: 3,500 
Likes: 924
|
Post by aju on Nov 19, 2019 16:36:11 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!
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. I was initially basing this comment on my Invest account having now delved into my much larger ISA loanbook I can now see that these values are not always the same as I originally was seeing in the invest data. I think they are either my sales or my purchase dates and prices. Until Zopa makes their uses clearer who knows what they mean. The price item seems may be related to differing interest rates when selling or buying I'm still digging. Sorry for the bum steer on that one.
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Nov 19, 2019 16:48:29 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.
Yes the rearrangement of columns is a bit of a pain in excel anyway. On the comments field itself I can't understand why they have removed it if it wasn't hurting anyone and you are right it can be useful for me at least as follows 1. IVA, BANKRUPT etc notes are sometime useful to see if only to realise that they are potentially dead loans 2. In the online loanbook one can use certain strings to see new defaults eg search string "11/2019] Set" (without the quotes) for prizing out this months new defaults - its not perfect but it does mean I only have to download the loanbook once a month for my offline tools etc. 3. I also used them for collections and arrangement info eg missed payments especially when a borrower is making manual payments. 4. I used them also to see if missed payments are going to turn in to a default soon I'm hoping the don't remove it on the online loanbook screen for item 2 alone its very powerful for me. I'm one of the more pedantic types and have a full statement generator that can see some of this stuff if I care to especially missed payments and the like. Or in the case of settled's that are still paying and Zopa gets a query relating to why they sold the loan etc. The comments field can sometimes suggest spurious payments as well that are not easy to see unless one can see a full statement. I'm sure you use them and others as well feel free to tell us what you use the comments for it may be useful for others'
|
|
|
|
Post by ruth77 on Nov 20, 2019 13:56:14 GMT
I think you've covered most of my reasons aju, I use the comments to:
• identify missed payments • identify those loans in arrears for which repayments are pending
• differentiate between loans in arrears for the first time, and those where there is a regular pattern of missed/late payments • identify defaulted loans where there is an IVA, bankruptcy etc.
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Nov 20, 2019 14:40:50 GMT
I think you've covered most of my reasons aju , I use the comments to:
• identify missed payments • identify those loans in arrears for which repayments are pending
• differentiate between loans in arrears for the first time, and those where there is a regular pattern of missed/late payments • identify defaulted loans where there is an IVA, bankruptcy etc. I had some new defaults today and the online loanbook still has the comments so i was still able to search on the text "/11/2019] default" its quite clever in that the space before default seems to mean it finds both pieces of text. Again the "" are not required in the search field. I'm struggling with its not being useful especially if it's still online and as I say just being able to search for a particular months defaults is quite useful. Of course if they were to replace the comments with the default date field then it would be less of a use but hopefully they will see the errors of their ways. I wonder though if the real reason they perhaps are removing it is the freeform nature of the field and as a result the data in it can be a little unstructured etc.
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Nov 22, 2019 23:34:23 GMT
A loan book glossary is online ( link). thanks @jaan, someone at Zopa must think that the longer these documents look the better - there is so much spacing between each page on Mrs Aju's laptop we are lucky if we can see two items per screen.
|
|
|
|
Post by ruth77 on Jan 11, 2020 8:44:54 GMT
Looks that way! Back in their old position immediately after the Safeguard status.
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Jan 11, 2020 15:31:36 GMT
The original loanbook cross reference table has changed as follows from the old removed comments section that's been added back in. Old Name and Column Position New name and Column position
------------------------------------ -------------------------------------
>>>>>>>>>> (Comments removed previously but re-instated Jan 2020) <<<<<<<<
R 18. Comment (25) Y 25. Comment (18)
S 19. Loan start date (26) Z 26. Loan start date (19)
T 20. Scheduled end date (27) AA 27. Last repayment date (20)
AB 28. Default price (--)
U 21. Default date (29) AC 29. Default date (21)
V 22. Expected Repayment (30) AD 30. Monthly repayment amount (22)
AE 31. Type of asset (--)
W 23. Loan purpose (32) AF 32. Loan purpose (23)
X 24. Repaid % (33) AG 33. Percentage repaid (24)
as before the numbers are the column positions, the letters are Excel columns I have added into my tables. Hope this helps
Apologies if the tables don't line up its not that easy to post in from my text editor and copying from above seems to have messed it up so I just added in the changed section.
|
|
