skippyonspeed
Some people think I'm a little bit crazy, but I know my mind's not hazy
Posts: 787
Likes: 424
|
Post by skippyonspeed on Oct 1, 2016 14:38:50 GMT
Saving Stream, have I told you lately that I love you..... Steady there...... I'm feeling......I've been !
|
|
gwenynwyr
Member of DD Central
Posts: 54
Likes: 23
|
Post by gwenynwyr on Oct 1, 2016 14:39:32 GMT
Hi Guys, I'm new to all this and have just received my first interest payments. Comparing the interest in the 'My Loans' table with the amounts in the 'Transactions' table most are the same, but for 2 of the loans there is a small discrepancy. PBL067 is £0.05 short and PBL081 is £1.97 short. I've seen reference to the interest payments being made manually, are they also calculated manually? Looking forward to any comments/advice.
|
|
skippyonspeed
Some people think I'm a little bit crazy, but I know my mind's not hazy
Posts: 787
Likes: 424
|
Post by skippyonspeed on Oct 1, 2016 14:46:18 GMT
If the amounts lent are identical and the loans are all started on the same day, then the interest payments should be the same assuming the rate of interest is the same
|
|
gwenynwyr
Member of DD Central
Posts: 54
Likes: 23
|
Post by gwenynwyr on Oct 1, 2016 15:17:47 GMT
Thanks skippyonspeed, but the difference is between entries in 'My Loans' and 'Transactions', not between loans. I'll pass the question on to SS for comment.
|
|
littleoldlady
Member of DD Central
Running down all platforms due to age
Posts: 3,045
Likes: 1,862
|
Post by littleoldlady on Oct 1, 2016 16:30:11 GMT
These figures will, of course, only be the same for the month in which the loan is bought. My loans bought in Sep all tally on both pages.
|
|
skippyonspeed
Some people think I'm a little bit crazy, but I know my mind's not hazy
Posts: 787
Likes: 424
|
Post by skippyonspeed on Oct 1, 2016 17:03:29 GMT
Thanks skippyonspeed, but the difference is between entries in 'My Loans' and 'Transactions', not between loans. I'll pass the question on to SS for comment. Ah yes just re-read your orig. post. Having recently composed a spreadsheet that calculates daily interest and predicts future payments, I know quite a lot and found SS's system very frustrating because they lump accrued interest and previously paid sums together. The "My Loans" page shows a grand total of each loan part ie all paid and accrued interest since the start of the loan. The "Transactions" page shows single payments of accrued interest for 1 complete month.
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Oct 1, 2016 18:36:44 GMT
Comparing the interest in the 'My Loans' table with the amounts in the 'Transactions' table most are the same, but for 2 of the loans there is a small discrepancy. PBL067 is £0.05 short and PBL081 is £1.97 short. Looking forward to any comments/advice. gwenynwyr: Further to the explanation above from skippyonspeed, might you have invested in PBL067 and PBL081 back in August? If so, look at your transaction entries for 31/Aug and you may find that the 'missing' amounts were paid on those two loans at that time.
|
|
gwenynwyr
Member of DD Central
Posts: 54
Likes: 23
|
Post by gwenynwyr on Oct 1, 2016 21:57:13 GMT
That's it! I thought that The interest only covered the current month. The 2 loans in question were at the end of August as you suggested. I'll get the hang of things soon, but thanks to all for helping out.
|
|
0risk
Member of DD Central
Posts: 217
Likes: 202
|
Post by 0risk on Oct 1, 2016 22:53:47 GMT
This is my first interest and I was quite surprised to see SS paying interest on each piece of loan, rounding it to the nearest penny. I was expecting they would add all the pieces' interest and round the result only in the end. As I see it, one could get a few pence more or less.
This isn't the real problem, but someone could use this in his favour.
For example, if I invest £5,100, in 30 days I get £50.30 (=5100*0.12*30/365). But if I buy 10,000 pieces of £0,51, I would get £100. (=10000*round(0.51*0.12*30/365)
A bot could easily do this.
Someone please tell me I am wrong.
|
|
|
Post by Deleted on Oct 1, 2016 22:59:29 GMT
Thanks skippyonspeed, but the difference is between entries in 'My Loans' and 'Transactions', not between loans. I'll pass the question on to SS for comment. Ah yes just re-read your orig. post. Having recently composed a spreadsheet that calculates daily interest and predicts future payments, I know quite a lot and found SS's system very frustrating because they lump accrued interest and previously paid sums together. The "My Loans" page shows a grand total of each loan part ie all paid and accrued interest since the start of the loan. The "Transactions" page shows single payments of accrued interest for 1 complete month. Does your spreadsheet calculating interest work from the 'Transaction' Excel list? If so, could you share it?
|
|
skippyonspeed
Some people think I'm a little bit crazy, but I know my mind's not hazy
Posts: 787
Likes: 424
|
Post by skippyonspeed on Oct 2, 2016 1:26:24 GMT
Because of the way SS hide the accrueing intererest, and they only show 2 decimal places ie to the nearest penny, I haven't been able to check it until a payment is made. Sadly there was an error, which on the surface appears to be exactly 1 day of interest, but might just be co-incidental. Because I personally find the SS way of showing interest and loan parts awkward, frustrating and irritating, I haven't got round to debugging yet, I have to drink alcohol to scramble my Spocklike logic!!!!! It is self-calculating using the TODAY() function and formulae I have written myself. If you want to have a go yourself. It took me a couple days to decide the best way was to split it into 4 tables, ie "Active Loan Parts" - this has 3 (yes 3!!) separate interest columns "Accrueing", "Expected Accrued Total for Current Month" and "Total Parts Interest" for each loan part. The last being the equivalent to what you see on SS "Live LoanParts" page dropdowns ie interest earnt since I started the loan. Could have had 4th one ie Loan total that just added all the parts together but thought that was making it complicated!!!!!!! "Loan Parts Sold during Current Month" - (because there is unpaid accrued interest to be added to the Active Loan interest payment, in the previous table.) Just 2 interest columns (phew!) "Accrued" ie the current month total up to date of sale, and "Total Parts Interest" same as previous table "Loan Parts Sold" - Once again 2 interest columns "Total Parts Interest" same as previous table and "Loan Total Interest" this shows the Grand total of all the Sold parts for each loan as shown on the SS page. As I sell an active part I manually cut and paste it into the 2nd table and modify the formulae to stop it accrueng. After the accrued interest is paid on the 1st of each month, all of the contents of 2nd table gets transferred to the 3rd table then there is a bit more faffing about to do. The 4th table is for "Repaid Loans" just to match SS, which to me, is not really necessary. Once I have fixed the bug, I will automate the all manual shuffling with macros. I usually enjoy little projects like these......but not this one. I designed one for my AC account which was a LOT simpler 'cos they show 15 decimal places and no individual loan parts!!!!................................now there might be a simpler way, but I haven't seen it........ confused............I am.......now, I need more beer!
|
|
skippyonspeed
Some people think I'm a little bit crazy, but I know my mind's not hazy
Posts: 787
Likes: 424
|
Post by skippyonspeed on Oct 2, 2016 2:14:37 GMT
This is my first interest and I was quite surprised to see SS paying interest on each piece of loan, rounding it to the nearest penny. I was expecting they would add all the pieces' interest and round the result only in the end. As I see it, one could get a few pence more or less. This isn't the real problem, but someone could use this in his favour. For example, if I invest £5,100, in 30 days I get £50.30 (=5100*0.12*30/365). But if I buy 10,000 pieces of £0,51, I would get £100. (=10000*round(0.51*0.12*30/365) A bot could easily do this. Someone please tell me I am wrong. Yep you are wrong, they only show 2dp, not sure how many dp they work to but it could be 10 to 15 (AC say they work to 40dp but it all gets a bit silly after about 10. I tried an experiment a while back. After an irritating 2 hours I ended up with a loan part of about 42p. I was so p***ed off I thought I would use it as an experiment. I worked out how long it would take to earn just over 1p and I then sold it off on SM 1p at a time When the interest for that month was paid I did earn 1p, but all the loan parts showed £0.00 nb I just found it bizarre how fast each 1p sold. I think it was before FFF so it might have been a 'bot'
|
|
duck
Member of DD Central
Posts: 2,880
Likes: 6,964
|
Post by duck on Oct 2, 2016 6:14:35 GMT
I noticed an interesting 'issue' with yesterdays interest and the SS statement's. 30th Sept is the end of my Company year so being efficient I downloaded a Tax Statement yesterday morning and it showed Period: From 1st October 2015 to 30th September 2016 ... Total Interest Paid £X.XX.Then interest was paid on the 1st of October .... but on your personal statement it shows as being paid on 30th Sept (as normal) .... so download another Tax Statement and lo and behold Period: From 1st October 2015 to 30th September 2016 ... Total Interest Paid £X.XX + interest paid in October but backdated to September.So I now have 2 Tax statements both stating Report Generated 01st October 2016 but with different amounts of interest paid Now obviously I can sort this out easily at my end but if I was the type who simply took the statement as 'gospel' (or wanted to) there are various interesting scenarios that could be explored by those wanting to 'explore the tax system' ........ .... perhaps savingstream needs to perform a tweak to get rid of this anomoly.
|
|
dan83
Posts: 243
Likes: 84
|
Post by dan83 on Oct 2, 2016 7:18:19 GMT
I wasn't expecting interest until Monday, I also got mine yesterday.
|
|
skippyonspeed
Some people think I'm a little bit crazy, but I know my mind's not hazy
Posts: 787
Likes: 424
|
Post by skippyonspeed on Oct 2, 2016 7:37:29 GMT
I noticed an interesting 'issue' with yesterdays interest and the SS statement's. 30th Sept is the end of my Company year so being efficient I downloaded a Tax Statement yesterday morning and it showed Period: From 1st October 2015 to 30th September 2016 ... Total Interest Paid £X.XX.Then interest was paid on the 1st of October .... but on your personal statement it shows as being paid on 30th Sept (as normal) .... so download another Tax Statement and lo and behold Period: From 1st October 2015 to 30th September 2016 ... Total Interest Paid £X.XX + interest paid in October but backdated to September.So I now have 2 Tax statements both stating Report Generated 01st October 2016 but with different amounts of interest paid Now obviously I can sort this out easily at my end but if I was the type who simply took the statement as 'gospel' (or wanted to) there are various interesting scenarios that could be explored by those wanting to 'explore the tax system' ........ .... perhaps savingstream needs to perform a tweak to get rid of this anomoly. The only statements I can find are Tax Statements where are "personal statements" hidden?
|
|