SteveT
Member of DD Central
Posts: 6,873
Likes: 7,918
|
Post by SteveT on Feb 1, 2018 9:51:57 GMT
ablrate I've just made a trial sale and purchase between my 2 accounts, to see how the new transaction records appear. A couple of observations: a) As I think has already been mentioned, the "From Date" selection box currently has to be set to a day earlier than you actually mean, and the "Download History" link isn't yet working. Also, could the date selection "buttons" be enlarged to include the little blue calendar icons; I keep clicking the blue calendar icons, only to find that nothing happens! b) It's a bit disappointing that a SM sale still generates 2 transaction lines, one for the capital (plus / minus premium) and 1 for the accrued interest, but what is really odd to me is that the other side of the trade (the SM purchase) still only generates 1 transaction line. Surely, for consistency at least, both sides of the trade should generate mirrored transaction entries? However, it's good now to have the Loan Number on every line, and for "Acrd" to be itemised in each line, so I can cut out the manual entries that reconciliation used to entail. c) In the "Type" field, why has "Secondary Trade" been replaced by "SM Sale" (used on BOTH sides of the trade)? To have a secondary market purchase appear in the transaction record as "SM Sale" makes no sense at all. Why not stick with "Secondary Trade" on both sides, as before? Or else use "SM Purchase" on the purchase end of the trade?
|
|
dawn
Member of DD Central
Posts: 308
Likes: 275
|
Post by dawn on Feb 1, 2018 10:15:06 GMT
ablrate I've just made a trial sale and purchase between my 2 accounts, to see how the new transaction records appear. A couple of observations: a) As I think has already been mentioned, the "From Date" selection box currently has to be set to a day earlier than you actually mean, and the "Download History" link isn't yet working. Also, could the date selection "buttons" be enlarged to include the little blue calendar icons; I keep clicking the blue calendar icons, only to find that nothing happens! b) It's a bit disappointing that a SM sale still generates 2 transaction lines, one for the capital (plus / minus premium) and 1 for the accrued interest, but what is really odd to me is that the other side of the trade (the SM purchase) still only generates 1 transaction line. Surely, for consistency at least, both sides of the trade should generate mirrored transaction entries? However, it's good now to have the Loan Number on every line, and for "Acrd" to be itemised in each line, so I can cut out the manual entries that reconciliation used to entail. c) In the "Type" field, why has "Secondary Trade" been replaced by "SM Sale" (used on BOTH sides of the trade)? To have a secondary market purchase appear in the transaction record as "SM Sale" makes no sense at all. Why not stick with "Secondary Trade" on both sides, as before? Or else use "SM Purchase" on the purchase end of the trade? Not disappointing for me - please keep them as 2 separate lines. I want to be able to see this as 2 separate things and I'd like the same on the buying/bidding side. Currently I have to manually repeat the entry on my transactions log and then manually split interest and capital otherwise the totals I have invested in each loan gets completely messed up. I would like to be able to download the transaction log and just use the data in it without having to manually change things so that I can see what is capital and what is interest etc so I prefer these transactions as separate lines please.
|
|
SteveT
Member of DD Central
Posts: 6,873
Likes: 7,918
|
Post by SteveT on Feb 1, 2018 10:47:03 GMT
1 line per trade would be fine if it included all 4 fields that an Ablrate trade involves (Capital, Prem/Disc, Accrued Int, Total)
|
|
marka
Member of DD Central
Posts: 224
Likes: 175
|
Post by marka on Feb 1, 2018 11:25:25 GMT
Another request I'm afraid
Could the difference in font colour used to highlight my own bids/offers be more obvious on an individual loan's "All Bids and Offers" page please. As it is (at least using Chrome) the colours are very similar.
Thanks
|
|
blender
Member of DD Central
Posts: 5,719
Likes: 4,272
|
Post by blender on Feb 1, 2018 11:25:47 GMT
At least we are now getting the SM purchase price split between capital and accrued interest purchased, which has been requested for a long time. Though not retrospectively. I only ever buy from the SM into the ISA accounts now, and so what does or does not count as taxable interest no longer matters.
|
|
dawn
Member of DD Central
Posts: 308
Likes: 275
|
Post by dawn on Feb 1, 2018 11:30:55 GMT
1 line per trade would be fine if it included all 4 fields that an Ablrate trade involves (Capital, Prem/Disc, Accrued Int, Total) I don't agree - column B tells me what sort of transaction has happened - it will make my spreadsheet an awful lot more complicated if I have to faff around looking for odd words in the comments field and then try to work out which number refers to what sort of transaction. My spreadsheet for Ablrate is similar to those for my other P2P platforms and it all works fine for them. If Ablrate change the selling entry to one line (or continue to have bidding and buying as one line) I will have to manually continue to fudge my transaction report to get it to find the right numbers (or completely redesign the spreadsheet so it is nothing like the others which doesn't make any sense as they should all be doing the same sort of thing albeit with slight quirky oddities relevant to each platform) 1 line with everything is a lot more complicated to extract the relevant info from - other platforms don't seem to have this problem, nor do they have the really irritating rounding errors that mean that I'm already unsure of whether my numbers are right or not.
|
|
SteveT
Member of DD Central
Posts: 6,873
Likes: 7,918
|
Post by SteveT on Feb 1, 2018 11:52:11 GMT
I’m going to have to modify my Ablrate spreadsheet anyway to adapt to the new columns and combine both old and new format transactions. The main thing, as blender says, is that the missing info (loan number and accrued interest purchased) is now accessible. However, if this is intended to be the long-term UI going forward, it’s a missed opportunity to leave SM sales and SM purchases in different formats. The obvious solution to your headache of identifying which type of transaction it is would be to have 1 line per transaction, with all 4 value fields, and distinguish between “SM Sale” and “SM Purchase” in column B!
|
|
dawn
Member of DD Central
Posts: 308
Likes: 275
|
Post by dawn on Feb 1, 2018 12:32:10 GMT
I’m going to have to modify my Ablrate spreadsheet anyway to adapt to the new columns and combine both old and new format transactions. The main thing, as blender says, is that the missing info (loan number and accrued interest purchased) is now accessible. However, if this is intended to be the long-term UI going forward, it’s a missed opportunity to leave SM sales and SM purchases in different formats. The obvious solution to your headache of identifying which type of transaction it is would be to have 1 line per transaction, with all 4 value fields, and distinguish between “SM Sale” and “SM Purchase” in column B! Sorry - I think I am being thick here - how does 1 line work? I have a purchase of £200 (say) but I actually pay £201.15 (say) which is made up of £200 capital and £1.15 accrued interest paid to the seller. 1 line will have a lump transaction of £201.15 (in column C) and I would need to work out manually what is capital and what is interest. To me it makes far more sense to have 2 lines 1 with Investment in column B (and a figure of £200) and a second line with Accrued interest in Column B (and a figure of £1.15). I'm pretty good with spreadsheets and excel but I don't believe I can expect the spreadsheet to work out how to split the £201.15 for itself based on column B saying SM Purchase? All column references are to the old system
|
|
SteveT
Member of DD Central
Posts: 6,873
Likes: 7,918
|
Post by SteveT on Feb 1, 2018 12:36:57 GMT
I’m going to have to modify my Ablrate spreadsheet anyway to adapt to the new columns and combine both old and new format transactions. The main thing, as blender says, is that the missing info (loan number and accrued interest purchased) is now accessible. However, if this is intended to be the long-term UI going forward, it’s a missed opportunity to leave SM sales and SM purchases in different formats. The obvious solution to your headache of identifying which type of transaction it is would be to have 1 line per transaction, with all 4 value fields, and distinguish between “SM Sale” and “SM Purchase” in column B! Sorry - I think I am being thick here - how does 1 line work? I have a purchase of £200 (say) but I actually pay £201.15 (say) which is made up of £200 capital and £1.15 accrued interest paid to the seller. 1 line will have a lump transaction of £201.15 (in column C) and I would need to work out manually what is capital and what is interest. To me it makes far more sense to have 2 lines 1 with Investment in column B (and a figure of £200) and a second line with Accrued interest in Column B (and a figure of £1.15). I'm pretty good with spreadsheets and excel but I don't believe I can expect the spreadsheet to work out how to split the £201.15 for itself based on column B saying SM Purchase? All column references are to the old system On re-inspection, I see there is also a " Type Category" column that distinguishes Type "SM Sale" between Type Categories " Buy" and " Sell" (or has that just appeared this morning?). So that's one problem eliminated. Also (and again, this might have changed since I looked briefly earlier this morning), I see there are already 4 value columns in the new transaction record that give us everything we need (so the second "Accrued Interest" transaction line is pretty redundant): " Amount" = for a Buy, the total cash value of the trade (capital plus premium/discount plus accrued interest) BUT, for a Sell, it's currently only the capital plus prem/discount (which is bizarre) " Loan Amount" = capital (only) " Capital Price" = capital plus any premium/discount paid " Acrd" = any accrued interest involved in the trade (NB. this figure now is displayed whether it's already included in "Amount" (for a Buy) or is excluded (for a Sell), which again is bizarre) So, given that the " SM Sale" transaction line gives me all I need to know the capital, premium/discount and accrued interest, there's no need for the "Accrued Interest" transaction line at all
|
|
elliotn
Member of DD Central
Posts: 3,063
Likes: 2,681
|
Post by elliotn on Feb 1, 2018 12:45:19 GMT
ablrate , thank you for this update (and quick fixes), I'm regularly stuck on mobile and this experience is now excellent.
Thankfully you've prepared us psychologically for UI update for some months and the tweak I have to do in Excel is nothing compared to that little bit of info under SM Sale/Buy/Acrd...THANK YOU!!!!!!
Requests - after a quick look:
Current Investments - per above i) scrollable ii) add Borrower (ie CI to mirror SM) iii) excel export
Transactions - consolidated, single line for SM Sales across different price points (ie Transactions to mirror Email)
Updates - mark all as read (I'm currently in the 100s rendering a useful device redundant)
Thanks again! One more - ability to edit your own bids/offers directly from All Bids and Offers tab when trading.
|
|
elliotn
Member of DD Central
Posts: 3,063
Likes: 2,681
|
Post by elliotn on Feb 1, 2018 13:19:58 GMT
Withdrawal not wholly viewable within the pop-up box. (Hopefully, new UI will help receive these by 2nd working day too ).
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Feb 1, 2018 17:32:09 GMT
Well, just had a look at the new statements with a view to having a spreadsheet fiddle having got the instant returns for the planes............. hmmmm The new statement seems to be scrambled. The amounts column has the values I was expecting but the balance column is all over the place and the final balance is wrong. Just plain screw-ball, no logic I can find. The display balance on the dashboard is correct. The archived old-style statement adds up correct. ablrate ? Anyone else seeing this?
|
|
SteveT
Member of DD Central
Posts: 6,873
Likes: 7,918
|
Post by SteveT on Feb 1, 2018 17:35:20 GMT
Well, just had a look at the new statements with a view to having a spreadsheet fiddle having got the instant returns for the planes............. hmmmm The new statement seems to be scrambled. The amounts column has the values I was expecting but the balance column is all over the place and the final balance is wrong. Just plain screw-ball, no logic I can find. The display balance on the dashboard is correct. The archived old-style statement adds up correct. ablrate ? Anyone else seeing this? I found I had to click the Date column (to sort the entries by Date and Time) for it to make sense. It obviously should be set to default sort by Date / Time.
|
|
|
Post by ablrate on Feb 1, 2018 17:46:14 GMT
If you have sorted any columns it will remember that sort and apply it to the history. If you click the date as suggested it will sort correctly - we are looking at it - it was a previous update someone wanted which 'remebered' the sort
We are working through all the suggestions on this thread to see what we can implement
Treeman - I have just looked at the history and notice what you mean - We had a fix to time stamp everything order... that appears to have gone astray - so IR paid at once is at the same time - but because its the same time it has randomised the inputs - we will fix tomorrow.
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Feb 1, 2018 17:52:17 GMT
Well, just had a look at the new statements with a view to having a spreadsheet fiddle having got the instant returns for the planes............. hmmmm The new statement seems to be scrambled. The amounts column has the values I was expecting but the balance column is all over the place and the final balance is wrong. Just plain screw-ball, no logic I can find. The display balance on the dashboard is correct. The archived old-style statement adds up correct. ablrate ? Anyone else seeing this? I found I had to click the Date column (to sort the entries by Date and Time) for it to make sense. It obviously should be set to default sort by Date / Time. Thanks but nope ! Makes no difference ............ Hadn't even considered sorting !?! shouldn't be possible. Filtering perhaps.......... Download doesn't work either ........ Guess I'll find something else to do for now
|
|