niceguy37
Member of DD Central
Posts: 504
Likes: 254
|
Post by niceguy37 on Oct 9, 2015 11:31:33 GMT
As a new lender, I was wondering if SavingsStream will merge multiple loan parts for the same loan into one entry (after the monthly interest payout)? Otherwise my loan part listing is going to get rather long and unwieldy, and their database will be larger than necessary.
|
|
pom
Member of DD Central
Posts: 1,922
Likes: 1,244
|
Post by pom on Oct 9, 2015 11:36:06 GMT
Nope - you're stuck with them all unfortunately
|
|
sam i am
Member of DD Central
Posts: 697
Likes: 555
|
Post by sam i am on Oct 9, 2015 12:00:27 GMT
The website is due to be updated sometime soon. While I don't expect that actual merging of loan parts will feature, many of us on this forum hope that there will be functionality to see and manage more easily the total held in each loan. The ability to reorder the Live Loan Parts page by loan and provide a subtotal by loan would be useful.
|
|
niceguy37
Member of DD Central
Posts: 504
Likes: 254
|
Post by niceguy37 on Oct 9, 2015 13:29:37 GMT
Nope - you're stuck with them all unfortunately That's a shame. It means, if I understand correctly, that there's no point buying up loans with less than 50p balance, as you'd never get a whole penny interest. And it would make lenders' and Lendy's maintenance overhead significantly reduced.
|
|
sam i am
Member of DD Central
Posts: 697
Likes: 555
|
Post by sam i am on Oct 9, 2015 15:03:13 GMT
I've never bought a loan part this small but I would hope that SS would work to many decimal places and then pay a penny interest after sufficient time had passed. You might even get that penny after only earning only 0.5p in interest if SS round up!
|
|
|
Post by meledor on Oct 9, 2015 17:26:13 GMT
Nope - you're stuck with them all unfortunately That's a shame. It means, if I understand correctly, that there's no point buying up loans with less than 50p balance, as you'd never get a whole penny interest. And it would make lenders' and Lendy's maintenance overhead significantly reduced.
Like sam i am I haven't bought a loan this small (you haven't come over from Assetz have you?) but the issue that concerns you does not just apply to loan parts under 50p, it could apply to a loan of any size. Consider a loan of £98.12 - if you held for the full 31 days of July you would get exactly £1.00 interest. However you might think there is no point loaning for instance an extra 42p - £98.54 because you would still get the same £1.00 interest for the month. However by the end of September the £98.12 amount will have paid £2.97 for 92 days interest whereas a principal of £98.54 will have paid £2.98 interest. In other words interest is calculated on a cumulative basis using the number of days since the loan part start date. And that is the reason I guess why you cannot merge different loan parts for the same loan because they will have different start dates.
|
|
|
Post by solicitorious on Oct 9, 2015 17:35:41 GMT
As a minimum SS should be able to sort loan parts by loan ID, so they are all grouped together. Basic html, I would have thought.
|
|
david42
Member of DD Central
Posts: 419
Likes: 346
|
Post by david42 on Oct 10, 2015 3:22:25 GMT
If the problem gets too bad, you can amalgamate your parts buy selling several parts on the secondary market then buying them back as one lump. This is very hazardous but I have done it successfully many times (and got caught by the hazards a few times). 1) Choose a time when there is nothing for sale for the loan in question. 2) Ensure the secondary market is not jammed up by an earlier overdrawn transaction. I test this by selling £1 of the loan and buying it straight back. If my sale goes through then I know the secondary market is not jammed up. 3) Sell all the loan parts you want to amalgamate. 4) Immediately buy back the whole amount in one transaction. You have bought back your own loan parts but they are now amalgamated into a single part. 5) You need enough spare cash to buy back the whole amalgamated loan part. I have never been brave enough to do this operation without the cash in my account, but in theory you could create a BACS deficit for the necessary cash at the start then offset the BACS deficit when the cash is released back at the end of the process. 6) You risk losing your precious loan parts if someone else manages to buy them back before you do. Be as quick as you can and choose a quiet time. 7) I clearly have too much time on my hands.
|
|
duck
Member of DD Central
Posts: 2,868
Likes: 6,908
|
Post by duck on Oct 10, 2015 6:07:59 GMT
OK I love my spreadsheets but setting one up to perform this task is so simple.
SS give us transactions in Excel format so you don't even need to sort columns. Simple series of 'IF' statements to read the relevant column and then return the £ value. Total at the bottom and then to keep clarity reference the £ value to a summary sheet.
I'm running 3 accounts in SS so I like to see individual account exposure to each loan and also total exposure. Since I'm continually buying shrapnel this method is very time effective since it takes seconds to download the file, paste it into my spreadsheet and copy the formulas.
|
|
webwiz
Posts: 1,133
Likes: 210
|
Post by webwiz on Oct 10, 2015 7:33:24 GMT
If the problem gets too bad, you can amalgamate your parts buy selling several parts on the secondary market then buying them back as one lump. This is very hazardous but I have done it successfully many times (and got caught by the hazards a few times). 1) Choose a time when there is nothing for sale for the loan in question. 2) Ensure the secondary market is not jammed up by an earlier overdrawn transaction. I test this by selling £1 of the loan and buying it straight back. If my sale goes through then I know the secondary market is not jammed up. 3) Sell all the loan parts you want to amalgamate. 4) Immediately buy back the whole amount in one transaction. You have bought back your own loan parts but they are now amalgamated into a single part. 5) You need enough spare cash to buy back the whole amalgamated loan part. I have never been brave enough to do this operation without the cash in my account, but in theory you could create a BACS deficit for the necessary cash at the start then offset the BACS deficit when the cash is released back at the end of the process. 6) You risk losing your precious loan parts if someone else manages to buy them back before you do. Be as quick as you can and choose a quiet time. 7) I clearly have too much time on my hands. I would not use this system whilst there is a suspicion that bots are at work. You can't be faster than a bot and could lose the lot.
|
|
sam i am
Member of DD Central
Posts: 697
Likes: 555
|
Post by sam i am on Oct 10, 2015 7:37:26 GMT
OK I love my spreadsheets but setting one up to perform this task is so simple.
SS give us transactions in Excel format so you don't even need to sort columns. Simple series of 'IF' statements to read the relevant column and then return the £ value. Total at the bottom and then to keep clarity reference the £ value to a summary sheet.
I'm running 3 accounts in SS so I like to see individual account exposure to each loan and also total exposure. Since I'm continually buying shrapnel this method is very time effective since it takes seconds to download the file, paste it into my spreadsheet and copy the formulas. A pivot table is an alternative method.
|
|
duck
Member of DD Central
Posts: 2,868
Likes: 6,908
|
Post by duck on Oct 10, 2015 7:52:47 GMT
OK I love my spreadsheets but setting one up to perform this task is so simple.
...... A pivot table is an alternative method. absolutely, my point is that with minimal basic spreadsheet work (some people view pivot tables as 'advanced) pulling this information together takes little effort.
|
|
SteveT
Member of DD Central
Posts: 6,875
Likes: 7,924
|
Post by SteveT on Oct 10, 2015 8:37:20 GMT
|
|
adrianc
Member of DD Central
Posts: 10,000
Likes: 5,139
|
Post by adrianc on Oct 10, 2015 8:54:01 GMT
Now, how do we persuade LoneRifle that he needs to invest in SS, and produce an equivalent of his FCViz browser extension...?
|
|