|
Post by MoneyThing on Mar 26, 2016 14:21:44 GMT
Just been through my spreadsheet to apply the new codes on renewable loans and found this (MT215) RENEWAL of (MT215) Collection of Seven Cars - No code change applied. Thanks. Now corrected to "(MT281) RENEWAL of (MT215) Collection of Seven Cars". Regards, Ed.
|
|
|
Post by MoneyThing on Mar 26, 2016 14:30:15 GMT
Just been through my spreadsheet to apply the new codes on renewable loans and found this (MT215) RENEWAL of (MT215) Collection of Seven Cars - No code change applied.
|
|
|
Post by MoneyThing on Mar 26, 2016 14:39:22 GMT
Ed Now the renewal opt ins are visible, I've noticed that some loans are "renewable" that I wasn't aware fell into this category. I use a spreadsheet for keeping tabs on all of this and for those that are renewable, I add 6 months to the end date. Could you please pretty please add some text (e.g. "rolling") to the loan details to indicate that they will be renewable. The spreadsheet could then search for this term and add 6 months if it sees it. Unfortunately because the tick box is an object, nothing copies across that the spreadsheet sees. Thanks Afternoon, We have the option to toggle whether the tick-box should be present against each loan individually. Some loans are structured so that they can't renew (A), others have the option where they can be (however will unlikely be renewed) (B), and then the 3rd category where they will likely renew (e.g. the MPs) (C). I have been in two minds whether to include the opt-in toggle for the (B) loans and for the moment have kept this in place. We could switch this off for these loans and then switch on (and email lenders), in the event that the borrrower is wanting to renew? Happy to go with the consensus in this. Kind regards, Ed
|
|
|
Post by MoneyThing on Mar 26, 2016 14:40:25 GMT
Minor bug spotted: The LTV field in the "My Live Loans" export file is exported as a number that is 100 times too large. ie. "50%" is exported as 50 (so, when reformatted as a % in Excel, turns into 5000%) rather than as 0.50 [Actually the Rate field suffers the same problem: 12% comes through as 12, which Excel reads as 1200%] Acknowledged. Just looking into this now. Regards, Ed.
|
|
|
Post by MoneyThing on Mar 26, 2016 14:54:32 GMT
MoneyThing Ed, I only now spotted the "Borrower code" field in the "My Live Loans" export to Excel (as it doesn't appear on the web-page). Fantastic addition, but could you please provide some greater resolution on the MT loans? For example, those to SD (property developer) could be MT - SD, those to the same car dealer could be MT - C1, those to the art collector MT - A, etc. [As per the way that CS managed portfolio loans are coded CSP, whilst the original standalone CS pawn items in "My Repaid Loans" are just coded CS] We have been discussing best way to achieve this. Would welcome some feedback. My suggestion at the moment is to retain 'MT' (standalone), for all loans with a unique borrower. Then for all loans with the same borrower to go in the format 'MTAA', 'MTAB', 'MTAC', .... Would welcome some feedback before this is implemented. Regards, Ed
|
|
|
Post by solicitorious on Mar 26, 2016 15:08:09 GMT
Small request. Could we have the option to display 200 parts on MyLoans and LiveLoans? I have 101 parts!
|
|
SteveT
Member of DD Central
Posts: 6,874
Likes: 7,919
|
Post by SteveT on Mar 26, 2016 15:45:13 GMT
MoneyThing Ed, I only now spotted the "Borrower code" field in the "My Live Loans" export to Excel (as it doesn't appear on the web-page). Fantastic addition, but could you please provide some greater resolution on the MT loans? For example, those to SD (property developer) could be MT - SD, those to the same car dealer could be MT - C1, those to the art collector MT - A, etc. [As per the way that CS managed portfolio loans are coded CSP, whilst the original standalone CS pawn items in "My Repaid Loans" are just coded CS] We have been discussing best way to achieve this. Would welcome some feedback. My suggestion at the moment is to retain 'MT' (standalone), for all loans with a unique borrower. Then for all loans with the same borrower to go in the format 'MTAA', 'MTAB', 'MTAC', .... Would welcome some feedback before this is implemented. Regards, Ed I'd be OK with that as my main interest is to understand my exposure to a single borrower (since risk of default could be correlated).
|
|
star dust
Member of DD Central
Posts: 2,998
Likes: 3,531
|
Post by star dust on Mar 26, 2016 16:00:53 GMT
I have been in two minds whether to include the opt-in toggle for the (B) loans and for the moment have kept this in place. We could switch this off for these loans and then switch on (and email lenders), in the event that the borrrower is wanting to renew? I'd prefer the opposite. Keep the (B) loans renewal tick box, and email if this does not renew. That way I can make the decision to renew ahead of time, but am alerted if anything repays instead. We have been discussing best way to achieve this. Would welcome some feedback. My suggestion at the moment is to retain 'MT' (standalone), for all loans with a unique borrower. Then for all loans with the same borrower to go in the format 'MTAA', 'MTAB', 'MTAC', .... Would welcome some feedback before this is implemented. Regards, Ed Don't mind as long as there is some standout abbreviation (preferably at the beginning) that helps identify the loan partners. Get a bit brain boggled trying to sort them, especially on-line! Good work on the renewal tick boxes though MoneyThing, Ed and presumably most important Shaung. .
|
|
SteveT
Member of DD Central
Posts: 6,874
Likes: 7,919
|
Post by SteveT on Mar 26, 2016 16:09:35 GMT
Agree with star dust on the tick boxes. It matters not if there's an opt-in tick box for a loan that doesn't renew (FS put one on every loan as standard). However if you don't have one on a loan that later decides to renew, some lenders may not notice / react and then miss out.
|
|
|
Post by MoneyThing on Mar 26, 2016 16:20:25 GMT
Fine. Happy to keep the tick-box for the (B) loans also. Many thanks, Ed.
|
|
|
Post by MoneyThing on Mar 26, 2016 16:26:30 GMT
Small request. Could we have the option to display 200 parts on MyLoans and LiveLoans? I have 101 parts! Sortable tables now have an option to show 200 lines per page (which only appears when there are over 100 records). Regards, Ed.
|
|
|
Post by MoneyThing on Mar 26, 2016 16:27:26 GMT
Minor bug spotted: The LTV field in the "My Live Loans" export file is exported as a number that is 100 times too large. ie. "50%" is exported as 50 (so, when reformatted as a % in Excel, turns into 5000%) rather than as 0.50 [Actually the Rate field suffers the same problem: 12% comes through as 12, which Excel reads as 1200%] Export is now showing % for LTV & Rate. Regards, Ed.
|
|
spiral
Member of DD Central
Posts: 962
Likes: 484
|
Post by spiral on Mar 26, 2016 17:04:52 GMT
I have been in two minds whether to include the opt-in toggle for the (B) loans and for the moment have kept this in place. We could switch this off for these loans and then switch on (and email lenders), in the event that the borrrower is wanting to renew? Hi Ed Unfortunately this isn't addressing the issue I have. I suppose the angle I'm coming from is that for loans that are going to renew, the end date isn't the true end date. I therefore add 6 months to this date (through a formula) in excel. Previously I added this to loans with the word "managed" in the title. Now that the tick box is present, I see that I have other category loans for which this is also an option (and in fact I can only see it for loans that I'm invested in). I originally suggested adding a key word to the title to indicate that they are rolling but accept that although a quick and easy fix, would increase the length of an already long field. I create my spreadsheet by copy and pasting the loan page into excel which previously used 7 columns but with the added opt in field, now uses 8 so any indicator in any of these fields would suffice. My second suggestion was a character in the new opt in column but am unsure if that would interfere with the tick box. If this was possible you could probably even use this to identify renewed loans rather than the text added to the loan description thus shortening this field for those that had renewed.
|
|
SteveT
Member of DD Central
Posts: 6,874
Likes: 7,919
|
Post by SteveT on Mar 26, 2016 17:51:27 GMT
I have been in two minds whether to include the opt-in toggle for the (B) loans and for the moment have kept this in place. We could switch this off for these loans and then switch on (and email lenders), in the event that the borrrower is wanting to renew? Hi Ed Unfortunately this isn't addressing the issue I have. I suppose the angle I'm coming from is that for loans that are going to renew, the end date isn't the true end date. I therefore add 6 months to this date (through a formula) in excel. Previously I added this to loans with the word "managed" in the title. Now that the tick box is present, I see that I have other category loans for which this is also an option (and in fact I can only see it for loans that I'm invested in). I originally suggested adding a key word to the title to indicate that they are rolling but accept that although a quick and easy fix, would increase the length of an already long field. I create my spreadsheet by copy and pasting the loan page into excel which previously used 7 columns but with the added opt in field, now uses 8 so any indicator in any of these fields would suffice. My second suggestion was a character in the new opt in column but am unsure if that would interfere with the tick box. If this was possible you could probably even use this to identify renewed loans rather than the text added to the loan description thus shortening this field for those that had renewed. The only loans that have deliberately been set up with renewal in mind all have "Managed Portfolio" in the title, so why not use that in your spreadsheet? Seems a slightly strange thing to want to do anyway IMO. The loans in question WILL end on the date shown, since renewals get a new loan number. And why add 6 months? Why not 12, 18, 24, ?
|
|
spiral
Member of DD Central
Posts: 962
Likes: 484
|
Post by spiral on Mar 26, 2016 18:50:50 GMT
The only loans that have deliberately been set up with renewal in mind all have "Managed Portfolio" in the title, so why not use that in your spreadsheet? Seems a slightly strange thing to want to do anyway IMO. The loans in question WILL end on the date shown, since renewals get a new loan number. And why add 6 months? Why not 12, 18, 24, ? The simple answer is, I don't actively purchase (although I will hold) loans with < 6 months remaining, it just bumps the end date in my spreadsheet so that I know they have longer than this to run and puts them on my want list. I do currently use the word "managed" as my key word but as I said in my post, there appear to be some others that have a renew option without the word managed, some of the car loans for example. From your post, I take it that these are not intentionally set out from the outset to renew in which case, I may have misunderstood the whole issue although if I don't currently hold a loan that appears to only have say one month to run but is due to renew for a further 6 months, I would not know should this appear on the SM.
|
|