elliotn
Member of DD Central
Posts: 3,063
Likes: 2,681
|
Post by elliotn on Feb 24, 2017 15:10:37 GMT
Account history (ie the abl excel export) to abl should be pretty straight forward from a pivot, my problem is then trying to tie back to cash.
From memory, something like this (pls note I'm not at pc so will get back on any discrepancies):
Investment + Bid - Capital Repayment - Secondary Trade = Funds Currently Lent (ie loans at capital amount)
Interest Repayment = Total Interest
Funds Currently Lent + Total Interest + Instant Returns + Available balance = Total Funds on abl
|
|
sg
Posts: 68
Likes: 69
|
Post by sg on Feb 24, 2017 15:35:33 GMT
Just tried that and it's the Secondary Trade that screws it up, it's listed as an investment under "Type" exactly as a Primary trade but only part of it is invested, the rest goes to pay accrued interest and any markup over par. So for example I have an Investment amount of -£204.08 to buy £200 of lending. I thought I might be able to strip the numbers from the "Transaction Comments" but one of mine says "Buy £50.00 for -£0.14 on loan XXX in secondary market." which I'm pretty sure is wrong so I'm not going to do it that way.
It looks like I'll have to trudge through the 130 emails I have from Ablrate and enter numbers manually, thankfully I'm not that active and have only been on Ablrate six months or so, I pity the long term active investor.
Surely this should be split out in the Account History ?
I only started this to do an XIRR on each of my P2P's for comparison, Ablrate seemed low (less than 10%) considering I have never taken any loans lower than 10% and rarely leave much money lying fallow, so I tried to resolve the account. That was three hours ago and my head hurts now so I'm going for a nice cup of tea !!
|
|
elliotn
Member of DD Central
Posts: 3,063
Likes: 2,681
|
Post by elliotn on Feb 24, 2017 15:51:56 GMT
Yes, I need to check how Secondary Trade is split to confirm that, 2 or 3 parts you need to add together although you can just take out the capital element to get back to Dashboard. The £50 line is nonsense on it's own but looks like it was a Bid you made on the SM? If so, you need to net it against an amount near that time for c£50 and this should equal the total cost of the loan part you bought. SteveT might be able help on xirr, I've never used it, my travails are trying to do nothing more sophisticated than agree to my cash in/out!
|
|
sg
Posts: 68
Likes: 69
|
Post by sg on Feb 24, 2017 16:29:52 GMT
I see what you mean about the Bid (I'd filtered out those lines so didn't see it). So basically I got it for less than I bid so got something back (14p).
XIRR is easy compared to resolving this. It just lets me compare performance over varying lengths of time on the platforms I'm on. So I got SS = 11.42%; MT = 11.11%; ABL = 9.07%. I think of it much as AER a tool for comparison.
I expected ABL to be the highest as some of my loans are higher than 12% on here but not on the others.
I had used the "Total Funds on Ablrate" as the final balance in the calc so I thought I'd check it and my total was about £30 above that, that's when it got difficult !
If the XIRR is correct then I think it points to the secondary market costing me more than I though it did, which I will need to look at in isolation. I had assumed from the start that buying a 14% loan at 101% was approximately the same as buying a 13% loan at par. If the XIRR is correct then it must be costing me more than this somewhere, unfortunately until I resolve the Account History I won't be able to tell where the money is going.
Thankfully I haven't sold anything on the secondary market yet as I think that will muddy the waters even further (ie is a payment in lieu of interest the same as interest for tax purposes !, is selling over par a capital gain !)
|
|
sg
Posts: 68
Likes: 69
|
Post by sg on Feb 24, 2017 17:26:24 GMT
Well I've just done the grunt work and it's thrown up some stuff that's worth commenting on.
Taking off the amount paid over par (interest + price increase) on the secondary takes the ABL XIRR to 11.28% so comparable to SS & MT for me.
I haven't received emails for the trades on the secondary market done last June so can't split out accrued interest and price increase. I have other Ablrate emails from then so I'm not sure what happened to them or whether I can retrieve this information another way.
The numbers still don't resolve in the Account History but I'm within a couple of quid now so it will do for this purpose.
I take this as a warning to be very careful what I buy on the Secondary Market. Most of this was last June at the time I joined (impatient to be invested ! Basic Schoolboy Error). It occurrs to me that the effect of paying over par on the secondary market is not a simple calculation but will lessen over time as long as the loan is held, for example the 16% loan I paid a large markup but for each month I hold the loan the effect of this will be spread thinner and thinner and the effective rate of the loan will creep up, I will monitor this.
Thanks for the help. I'm off to the pub.
|
|
|
Post by ablrate on Feb 25, 2017 17:09:55 GMT
We are in the process of revamping the SM comments section to make it easier to understand. Also, when you download the history we are aiming to have it so that data can easily be manipulated without having to have a degree in excel. We also looking to have a few buttons that give standard outputs for those who want to strip out secondary trades, mark ups etc. We are sorry this has taken some time but we want to make sure that we don't change it and make it less understandable.
If you have any issues with the SM please let us know as soon as possible and we will be able to look through your account. The integrity of the reporting system is, of course, absolutely paramount and even if you suspect something may not be right do let us know. Even if nothing is wrong it will help us determine how better to display information.
Regards Ablrate
|
|
sg
Posts: 68
Likes: 69
|
Post by sg on Feb 25, 2017 19:35:26 GMT
ablrateThats good to know. I got this to resolve this morning by stripping out the buy amounts from the comments on Investments into a currency column of their own. In addition to separating out Accrued Interest and Purchase Fee (not sure how you describe the amount over the Invested amount) from SM buys can I request that the values downloaded are the unrounded ones that are used internally to calculate the totals. Even though it did resolve there was a 3p error on the total and a 2p error on the interest, these are presumably due to rounding but as the numbers I downloaded are already rounded to 1p there's nothing more I could do to balance it.
|
|
ali
Member of DD Central
Posts: 313
Likes: 311
|
Post by ali on Feb 27, 2017 8:35:33 GMT
If you have any issues with the SM please let us know as soon as possible and we will be able to look through your account. The integrity of the reporting system is, of course, absolutely paramount and even if you suspect something may not be right do let us know. Even if nothing is wrong it will help us determine how better to display information Can I refer you to my query by email of the 9th September which was acknowledged on the 13th as follows: I haven't had a resolution or a revert. Let me know if there is anything else you need to know.
|
|
|
Post by ablrate on Feb 27, 2017 11:52:11 GMT
If you have any issues with the SM please let us know as soon as possible and we will be able to look through your account. The integrity of the reporting system is, of course, absolutely paramount and even if you suspect something may not be right do let us know. Even if nothing is wrong it will help us determine how better to display information Can I refer you to my query by email of the 9th September which was acknowledged on the 13th as follows: I haven't had a resolution or a revert. Let me know if there is anything else you need to know. Hi If you DM me your details I will chase up.
|
|
ali
Member of DD Central
Posts: 313
Likes: 311
|
Post by ali on Feb 27, 2017 13:08:54 GMT
Just to note that the discrepancy on my account is now sorted. Thanks ablrate
|
|