|
Post by chris on Oct 22, 2014 12:03:57 GMT
Please vote via the poll on the amortisation issue. The separation of transactions is the only way to make the site work with separation of funds, which is critical as more and more investment accounts are made available. I would have thought it would make each individual investment account easier to reconcile than one global list. I'd imagine that the man in the street would load statements into excel. Now we have to download multiple statements and manually merge them to a single sheet before being able to see the whole picture. A single CSV with an "account name" column would be an elegant solution. I don't want to have to download 26 statements to find out all the transactions pertaining to a single loan. We'll look into it as a near term possibility.
|
|
|
Post by chris on Oct 22, 2014 12:06:18 GMT
Can you PM me a specific example along with your email address as I've yet to see this happen in any of the examples I've been given. I have a full log of all targets on both old and new system so can tell you why the system has done what it's done. Done, thanks. For everyone else's benefit, I've looked into this for markr and whilst he's fallen foul of the advanced settings import issue that I've previously discussed, he did have AI targets set on all the loans he's mentioned along with a history back to April of them being set and adjusted.
|
|
bigfoot12
Member of DD Central
Posts: 1,817
Likes: 816
|
Post by bigfoot12 on Oct 22, 2014 12:22:11 GMT
Can I request a change to the customise options on the dashboard. Please could the name of 'Interest for UK tax year' be changed to 'Interest for previous UK tax year' and could a new option be added 'Interest to date for current UK tax year'. Exact names aren't important. Already being worked on. Thank you, your interaction and work is much appreciated. Very much looking forward to all of the new features you are still teasing us with.
|
|
niceguy37
Member of DD Central
Posts: 504
Likes: 254
|
Post by niceguy37 on Oct 22, 2014 12:22:48 GMT
Well new site certainly seems to be be very active in buying and selling. I've 142 transactions in just over 24 hours! I can just imagine the size of transaction statement I'll need to check if I'm offline for a week or two. But I have managed to pick up assortments of less-commonly-available loans so helping adjust my portfolio balance. (But I hope only from willing sellers!)
|
|
|
Post by Jack Barlow on Oct 22, 2014 12:26:02 GMT
chris, for mouse users please consider re-setting the dropdown menus on the top bar so that they reveal on hover rather than on click.
|
|
ilmoro
Member of DD Central
'Wondering which of the bu***rs to blame, and watching for pigs on the wing.' - Pink Floyd
Posts: 11,330
Likes: 11,549
|
Post by ilmoro on Oct 22, 2014 13:19:30 GMT
chris loan#31 appears in the list generated by the filter 'loans im not invested in' under Browse Loans but doesnt appear listed if i select 'show all current loans' or if i do a search I get no results. Not sure this loan is still current, has no repayment schedule, no capital or LTV. Might be an extension but no evidence/disclaimer/recent activity to indicate this.
|
|
|
Post by pepperpot on Oct 22, 2014 13:41:58 GMT
chris loan#31 appears in the list generated by the filter 'loans im not invested in' under Browse Loans but doesnt appear listed if i select 'show all current loans' or if i do a search I get no results. Not sure this loan is still current, has no repayment schedule, no capital or LTV. Might be an extension but no evidence/disclaimer/recent activity to indicate this. 31 is now paid off, the current loans are 'Boiler man' t3 and t4 (58 + 63) I think it might be better as a future change to put all the old/paid off/complete loans in a separate searchable list some where so someone can do research if they want to but they don't clog up the current lists.
|
|
is
Posts: 108
Likes: 14
|
Post by is on Oct 22, 2014 14:15:17 GMT
I think the issue here is the way default behaviour has been changed by new site release, leading to potentially unintended investments being made by people who did not review the site immediately. I have had to do as batchboy and switch reinvestment off & clear funds from investment account. This is very manual and time consuming to maintain, unnecessarily so. The default behaviour is the same - it's always remained a static target that didn't amortise. What's changed is the ability of the system to actually process requested sales and purchases. I'll start a poll though as I do want to get this right. Not so Chris, I have not had AI enabled before and did not intend to, but now I cannot simply purchase / sell nominal amounts of loan as before. Two issues: 1) Upon the switch, new targets were set based on existing holdings. Meaning if someone had an amortising loan with no AI enabled, the system will now try to "top up" nominal exposure whenever a payment is made. This is unauthorised by the lender, whether or not they see it as desirable, and the switch did not let people "opt in" but rather converted all to the new system. 2) The way to mimic old behaviour for me is to set all repayments to go to cash account, then manually modify the target on every amortising loan to match the intended nominal holding before I am able to use the cash again to buy more of other loans (otherwise moving cash to the investment account may result in AI trying to top up amortised holdings). Painful, don't you agree?
|
|
|
Post by chris on Oct 22, 2014 14:24:50 GMT
The default behaviour is the same - it's always remained a static target that didn't amortise. What's changed is the ability of the system to actually process requested sales and purchases. I'll start a poll though as I do want to get this right. Not so Chris, I have not had AI enabled before and did not intend to, but now I cannot simply purchase / sell nominal amounts of loan as before. Two issues: 1) Upon the switch, new targets were set based on existing holdings. Meaning if someone had an amortising loan with no AI enabled, the system will now try to "top up" nominal exposure whenever a payment is made. This is unauthorised by the lender, whether or not they see it as desirable, and the switch did not let people "opt in" but rather converted all to the new system. 2) The way to mimic old behaviour for me is to set all repayments to go to cash account, then manually modify the target on every amortising loan to match the intended nominal holding before I am able to use the cash again to buy more of other loans (otherwise moving cash to the investment account may result in AI trying to top up amortised holdings). Painful, don't you agree? I do agree and have instigate the poll and related thread in order to capture user feedback on how best to deal with it. The "always on" nature of manual invest is a side effect of the underlying systems it has been built upon that have to work in an always on way. That I can't change easily but I have a plan with the amortising of the target.
|
|
|
Post by batchoy on Oct 22, 2014 14:42:40 GMT
I am going to scream (again) in a moment. Having switched the MLA to withdraw Repayments and Interest, gone through and reset all the MAI targets to what they should be for amortising loans to amortise and what I actually bought not what I might have put in the AI before it was edited or disabled, put up for sale all the loan parts that the MAI bought that I don't want and had not instructed it to buy plus a few more to release funds for a shadow bid settlement, I note that my Cash holding has increased but not by the expected full amount. Ok thinks me, I will check my statement to see what has and hasn't been sold. So since all yesterdays MAI transactions were in the statement accessed via the three bars Icon on the MLA summary I go there and what do I find absolutely no transaction records beyond those the MAI made yesterday. So I go the the reports tab and click on the statement (which supposedly only reposts CA transactions) and low and behold all the transactions that have taken place today, presumably since I switched off automatic reinvestment, are in this report. This is now a major reconciliation nightmare as it appears that my CA is selling loans in my MLA, and it will potentially only get worse if I stay with AC and dabble in up coming their Green and Automated products. If the CA and MLA are separate accounts then there should be entries for the loan sales in the MLA statement and matching pairs of transfer entries in both the CA and MLA to show the transfer of the funds from the MLA to the CA. After all I have a matching pair of transactions showing cash being transferred from the CA to the MLA
|
|
|
Post by Ton ⓉⓞⓃ on Oct 22, 2014 14:49:20 GMT
I am going to scream (again) in a moment. Having switched the MLA to withdraw Repayments and Interest, gone through and reset all the MAI targets to what they should be for amortising loans to amortise and what I actually bought not what I might have put in the AI before it was edited or disabled, put up for sale all the loan parts that the MAI bought that I don't want and had not instructed it to buy plus a few more to release funds for a shadow bid settlement, I note that my Cash holding has increased but not by the expected full amount. Ok thinks me, I will check my statement to see what has and hasn't been sold. So since all yesterdays MAI transactions were in the statement accessed via the three bars Icon on the MLA summary I go there and what do I find absolutely no transaction records beyond those the MAI made yesterday. So I go the the reports tab and click on the statement (which supposedly only reposts CA transactions) and low and behold all the transactions that have taken place today, presumably since I switched off automatic reinvestment, are in this report which creates a major reconciliation nightmare! If the CA and MLA are separate accounts then there should be entries for the loan sales in the MLA statement and matching pairs of transfer entries in both the CA and MLA to show the transfer of the funs from the MLA to the CA. At the moment it appears that my CA is selling loans in my MLA, this is potentially only going to get worse if I stay with AC and dabble in up coming their Green and Automated products. I think mikeb raised this issue and chris is looking at a solution in the near term, I'll paste chris' below answer if I see it. I'd imagine that the man in the street would load statements into excel. Now we have to download multiple statements and manually merge them to a single sheet before being able to see the whole picture. A single CSV with an "account name" column would be an elegant solution. I don't want to have to download 26 statements to find out all the transactions pertaining to a single loan. We'll look into it as a near term possibility. Mike raised it first then John got the answer
|
|
sl75
Posts: 2,092
Likes: 1,245
|
Post by sl75 on Oct 22, 2014 14:59:27 GMT
I do agree and have instigate the poll and related thread in order to capture user feedback on how best to deal with it. The "always on" nature of manual invest is a side effect of the underlying systems it has been built upon that have to work in an always on way. That I can't change easily but I have a plan with the amortising of the target. With the greatest of respect to the ingeniousness of the new system, a system that doesn't have a "do nothing" option seems to me fundamentally flawed. As mentioned on the other thread, a target represented in the database by a "null" value or an absent record (depending on exact schema and what other fields are in the same record) can be used to represent the "do nothing" option. This should then be the default for any user who had never set an AI target for a loan, nor performed any action on the new system to cause the target to become anything other than the default. Using that solution, a "null" target could, in calculations where "null" isn't valid, be replaced with the actual current investment amount, so that rather than any need to actively amortise the target, it would simply always appear as exactly equal to the current investment. The relevant database queries then need consider (e.g.) only those users who have a target set for the loan under consideration, rather than all users, thereby needing to access fewer records, and potentially improving the overall efficiency of the system. If a target is set for a particular loan (whether manually, or as the result of matching one of the yet-to-launch products), the system should of course seek to maintain that target by buying or selling portions of the loan unit as necessary. However, if no target is set, the system should leave that loan well alone - neither buying nor selling portions of the loan on behalf of the user. To be clear - a brand new user, or a user who never enabled AI on the old site, would have the target for ALL loans initially "not set". Only if they actively opt in to some product that causes a target to be set would they gain a target for any loan.
|
|
|
Post by chris on Oct 22, 2014 15:02:36 GMT
I do agree and have instigate the poll and related thread in order to capture user feedback on how best to deal with it. The "always on" nature of manual invest is a side effect of the underlying systems it has been built upon that have to work in an always on way. That I can't change easily but I have a plan with the amortising of the target. With the greatest of respect to the ingeniousness of the new system, a system that doesn't have a "do nothing" option seems to me fundamentally flawed. As mentioned on the other thread, a target represented in the database by a "null" value or an absent record (depending on exact schema and what other fields are in the same record) can be used to represent the "do nothing" option. This should then be the default for any user who had never set an AI target for a loan, nor performed any action on the new system to cause the target to become anything other than the default. Using that solution, a "null" target could, in calculations where "null" isn't valid, be replaced with the actual current investment amount, so that rather than any need to actively amortise the target, it would simply always appear as exactly equal to the current investment. The relevant database queries then need consider (e.g.) only those users who have a target set for the loan under consideration, rather than all users, thereby needing to access fewer records, and potentially improving the overall efficiency of the system. If a target is set for a particular loan (whether manually, or as the result of matching one of the yet-to-launch products), the system should of course seek to maintain that target by buying or selling portions of the loan unit as necessary. However, if no target is set, the system should leave that loan well alone - neither buying nor selling portions of the loan on behalf of the user. To be clear - a brand new user, or a user who never enabled AI on the old site, would have the target for ALL loans initially "not set". Only if they actively opt in to some product that causes a target to be set would they gain a target for any loan. The problem with a null value is that it already has significance within other investment accounts so can't be reused. I'm sure there's a way to code around it but the "do nothing" option is just one solution to the user feedback we've had not necessarily the right one. To be clear - a brand new user would have no investment and therefore a null amount. As soon as they make any investment they have a record. All existing users who have any investment, regardless of historic AI entries, have a non-null entry.
|
|
|
Post by chris on Oct 22, 2014 15:04:46 GMT
I am going to scream (again) in a moment. Having switched the MLA to withdraw Repayments and Interest, gone through and reset all the MAI targets to what they should be for amortising loans to amortise and what I actually bought not what I might have put in the AI before it was edited or disabled, put up for sale all the loan parts that the MAI bought that I don't want and had not instructed it to buy plus a few more to release funds for a shadow bid settlement, I note that my Cash holding has increased but not by the expected full amount. Ok thinks me, I will check my statement to see what has and hasn't been sold. So since all yesterdays MAI transactions were in the statement accessed via the three bars Icon on the MLA summary I go there and what do I find absolutely no transaction records beyond those the MAI made yesterday. So I go the the reports tab and click on the statement (which supposedly only reposts CA transactions) and low and behold all the transactions that have taken place today, presumably since I switched off automatic reinvestment, are in this report. This is now a major reconciliation nightmare as it appears that my CA is selling loans in my MLA, and it will potentially only get worse if I stay with AC and dabble in up coming their Green and Automated products. If the CA and MLA are separate accounts then there should be entries for the loan sales in the MLA statement and matching pairs of transfer entries in both the CA and MLA to show the transfer of the funds from the MLA to the CA. After all I have a matching pair of transactions showing cash being transferred from the CA to the MLA You have more than one virtual bank account with AC now. One is your cash account, you have one each for each of the products. When you withdraw funds payments can be redirected straight to your cash balance, hence appearing on your cash statement. You have one statement per virtual bank account. We could route everything via the product account and then back to the cash account but no doubt we'd then be criticised for all the extraneous transactions.
|
|
oldgrumpy
Member of DD Central
Posts: 5,087
Likes: 3,233
|
Post by oldgrumpy on Oct 22, 2014 15:08:45 GMT
Listening to bratchoy.
Watching carefully (well, carefully for me). MLIA has sold nothing today, and in has come the [mod: loan 14] payment. A few loans have got minor "top-up" targets set - no one has sold any of those (to me) yet.
|
|