|
|
Post by Jack Barlow on Dec 23, 2014 12:42:49 GMT
Try the "Your Loans" download?
|
|
mikeb
Posts: 1,072 
Likes: 472
|
Post by mikeb on Dec 23, 2014 19:09:40 GMT
... c) you admit you aren't keep track per-loan  Have you started yet? No, I'm afraid I haven't, mainly because I haven't worked out an easy way to do that. How do you do it? Spreadsheet that reflects what should be shown, versus the output of www.assetzcapital.co.uk/loans?view=list -- and MK I Eyeball. Spreadsheet body has one line per loan:- Rate (%), Holding (£), Accrued (as of now), Accrued (predicted for tomorrow), Daily delta (pence, from rate and holding, used to create prediction), and Loan's pro-rata partial contribution to account total AER (%) ... Each morning, the yesterday's-predicted-accrued should be what today's-shown-on-site accrued is. If not, something's up ... either no accrual, a jump up or down that is not expected, or a repayment has occurred wiping it out (see statement to verify). Takes only a couple of minutes, unless something's gone wrong.
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Dec 24, 2014 3:35:24 GMT
No, I'm afraid I haven't, mainly because I haven't worked out an easy way to do that. How do you do it? Spreadsheet that reflects what should be shown, versus the output of www.assetzcapital.co.uk/loans?view=list -- and MK I Eyeball. Spreadsheet body has one line per loan:- Rate (%), Holding (£), Accrued (as of now), Accrued (predicted for tomorrow), Daily delta (pence, from rate and holding, used to create prediction), and Loan's pro-rata partial contribution to account total AER (%) ... Each morning, the yesterday's-predicted-accrued should be what today's-shown-on-site accrued is. If not, something's up ... either no accrual, a jump up or down that is not expected, or a repayment has occurred wiping it out (see statement to verify). OK. I've built my own spreadsheet along similar lines. It remains to be seen how easy it will be to reuse it on a subsequent day, but I'm hoping a bit of cut and paste will do the trick. The problem I anticipate is dealing with unit purchases and sales and interest payment received between updates, as there seem to be a number of those every day. (I have 78 loans with targets set, though not all of those are active.) Anyway, my first update a few minutes ago produced what we observed last night -- loans numbered 140+ had their AI updated as it should have been, and all the earlier loans had no AI change at all. chris: Can you please confirm when the AI updates are supposed to happen? If they no longer are supposed to occur shortly after midnight then we can stop being concerned when that's what happens.
|
|
|
|
Post by chris on Dec 24, 2014 7:33:06 GMT
They're supposed to happen between 12 and 12:30 but with re-runs later in the day if it failed. The last couple of days the failures have been tracked back to a small piece of code not being properly deployed on all servers, so when we ran it manually it was working but on the server it was running automatically it was failing. This has been resolved this morning so all should be good now.
|
|
bugs4me
Member of DD Central
Posts: 1,845
Likes: 1,478
|
Post by bugs4me on Dec 24, 2014 11:49:08 GMT
They're supposed to happen between 12 and 12:30 but with re-runs later in the day if it failed. The last couple of days the failures have been tracked back to a small piece of code not being properly deployed on all servers, so when we ran it manually it was working but on the server it was running automatically it was failing. This has been resolved this morning so all should be good now. Now switch off that laptop/tablet/whathaveyou chris and take a well earned break. Have a good well earned few days off and enjoy with the family.
|
|
mikeb
Posts: 1,072
Likes: 472
|
Post by mikeb on Dec 24, 2014 18:54:43 GMT
They're supposed to happen between 12 and 12:30 but with re-runs later in the day if it failed. The last couple of days the failures have been tracked back to a small piece of code not being properly deployed on all servers, so when we ran it manually it was working but on the server it was running automatically it was failing. This has been resolved this morning so all should be good now. It did all go through this time -- but of course now something else has popped up: The headline "Accrued interest" total in the summary page isn't reflecting the true total of all the accrued interests off the loans table ... maybe it will catchup overnight?
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Dec 24, 2014 19:40:32 GMT
They're supposed to happen between 12 and 12:30 but with re-runs later in the day if it failed. The last couple of days the failures have been tracked back to a small piece of code not being properly deployed on all servers, so when we ran it manually it was working but on the server it was running automatically it was failing. This has been resolved this morning so all should be good now. It did all go through this time -- but of course now something else has popped up: The headline "Accrued interest" total in the summary page isn't reflecting the true total of all the accrued interests off the loans table ... maybe it will catchup overnight? My AI total from the CSV download is only 7p short of the total shown on my Dashboard. I don't know whether that's an error, or the result of rounding, or might result from the inclusion of AI on my small experimental GEIA in the Dashboard number. (I presume GEIA AI is excluded from the downloaded CSV.)
|
|
dave
Member of DD Central
Posts: 86
Likes: 38
|
Post by dave on Dec 24, 2014 22:14:32 GMT
the mlia and geia accounts each have thier own csv files, both with the same name  Dave |
|
mikeb
Posts: 1,072
Likes: 472
|
Post by mikeb on Dec 26, 2014 18:43:30 GMT
It did all go through this time -- but of course now something else has popped up: The headline "Accrued interest" total in the summary page isn't reflecting the true total of all the accrued interests off the loans table ... maybe it will catchup overnight? My AI total from the CSV download is only 7p short of the total shown on my Dashboard. I don't know whether that's an error, or the result of rounding, or might result from the inclusion of AI on my small experimental GEIA in the Dashboard number. (I presume GEIA AI is excluded from the downloaded CSV.) Above referenced error was significantly more than rounding errors, however it is now balancing again (overnight update caught up?). As to rounding errors, I'm not sure on the CSV download -- the figures from the table (human readable version) are rounded to nearest pennies, and there's a variable 20-35p error between those amounts and the Accrued total. This is normal...
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Jan 6, 2015 2:27:44 GMT
They're supposed to happen between 12 and 12:30 but with re-runs later in the day if it failed. The last couple of days the failures have been tracked back to a small piece of code not being properly deployed on all servers, so when we ran it manually it was working but on the server it was running automatically it was failing. This has been resolved this morning so all should be good now. : And all was good from that point forward -- until Mon/Tues night, however, when something seems to have gone badly wrong. I haven't tried checking my day-by-day incremental accrued interest changes, but my total AI increased by less than 5% of the amount it should have after midnight.  Hopefully the problem will be obvious -- and easily fixable.
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Jan 6, 2015 15:17:07 GMT
They're supposed to happen between 12 and 12:30 but with re-runs later in the day if it failed. The last couple of days the failures have been tracked back to a small piece of code not being properly deployed on all servers, so when we ran it manually it was working but on the server it was running automatically it was failing. This has been resolved this morning so all should be good now. : And all was good from that point forward -- until Mon/Tues night, however, when something seems to have gone badly wrong. I haven't tried checking my day-by-day incremental accrued interest changes, but my total AI increased by less than 5% of the amount it should have after midnight. Hopefully the problem will be obvious -- and easily fixable. OK. I've now looked at the detailed data, and the problem seems to be that the accrued interest for Loan #40 has dropped as if the interest payment had been made even though the payment hasn't actually been credited to lenders' accounts. (I see from the loan's web page that the money was received by AC but an IT problem is preventing it from being allocated to the appropriate lenders.) That in itself shouldn't cause the AI to decrease, but in looking at the list of repayments for the loan I can see that the interest payment due on 5/Jan has disappeared completely from the list, and that's probably the source of the problem. Hopefully everything will be corrected once the IT patch is put in place.
|
|
mikeb
Posts: 1,072
Likes: 472
|
Post by mikeb on Jan 6, 2015 19:12:25 GMT
mikes1531 it fell over in stages :- Firstly on the 5th, principle paid (and knocked off holding), no interest paid, nothing knocked off accrued. On the "Repayments page" it showed the interest as still due. Then interest was deducted from accrued, but not actually paid. And now repayments page shows there is no interest payment due in Jan at all, unlike every other month around it. I guess the ongoing problem with this loan is that AC still have not managed to fix holdings or compensate lenders that have holdings which are incorrect, due to a purchasing-parts-at-the-wrong-price bug going back about 10 months now. I've no idea if this is still being discussed internally, because it was waiting for official sign-off last I heard, and that was ages ago.
|
|
|
|
Post by batchoy on Jan 12, 2015 14:26:50 GMT
My accrued interest on the Kiddy Loan is off, the January payment has been made and posted against the skipped December payment. Since I sold off my holdings just before the December payment was made the December payment should have cleared my accrued interest and divested me fully of the loan, with the December payment having now been posted I have received the funds but the interest is still showing as being accrued.
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Jan 12, 2015 15:06:32 GMT
My accrued interest on the Kiddy Loan is off, the January payment has been made and posted against the skipped December payment. Since I sold off my holdings just before the December payment was made the December payment should have cleared my accrued interest and divested me fully of the loan, with the December payment having now been posted I have received the funds but the interest is still showing as being accrued. I wonder if that might require manual intervention because of the situation caused by the crediting of the January payment back in December. Or perhaps it will correct itself automatically after midnight when all AI is updated. The routine payment of other interest has resulted in the AI for those loans having been adjusted appropriately already.
|
|
mikeb
Posts: 1,072
Likes: 472
|
Post by mikeb on Jan 12, 2015 18:35:07 GMT
batchoy -- I noticed this one paid up correctly today as expected, and that the rate has been reinstated. The only dangling feature is the accrued interest is still showing as accrued. I didn't mention it yet, as I fully expect it will fix itself overnight and reset to £0.00 (+some pence) tomorrow. If not, then something's gone wrong. This thing of "accrued interest remaining accrued after a payment" seems to happen on glitched loans, and on those that pay a day early. Magic happens at midnight.
|
|
Have you started yet?
