Liz
Member of DD Central
Posts: 2,426
Likes: 1,297
|
Post by Liz on Jan 5, 2015 18:43:40 GMT
Just a minor suggestion The list of my holdings on page www.savingstream.co.uk/members tab Live Loan Parts Could you order it by loan name please (called Asset Detail) not by loan id. So I can easily see what's going on if I have several chunks of a loan Thanks I think you need both, ie two seperate lists.
|
|
star dust
Member of DD Central
Posts: 2,998
Likes: 3,531
|
Post by star dust on Jan 5, 2015 19:00:23 GMT
I think it is actually ordered by date of purchase, but loan id's are created at the time you purchase so it amounts to the same thing really. To cater for all requirements/ taste/ preference, it would be useful if the columns could be sorted, as offered by a number of other P2P sites. I usually cut and paste into excel and order by asset detail myself, on a reasonably regular basis, but it is a chore to get rid of all the boat and house symbols cluttering up the spreadsheet!
|
|
|
|
Post by mrclondon on Jan 5, 2015 22:02:29 GMT
but it is a chore to get rid of all the boat and house symbols cluttering up the spreadsheet! For those au fait with excel macros, this is the code I have to clean up the list of selling / sold loans when copied and pasted into excel. If you try to do it manually you end up deleting the picture of the house / boat but not the underlying control which contains the picture. Sub CleanSellingSold()
Dim sh As Integer
Dim ty As Integer
With Sheets("SellingSold")
.Columns("B:B").Hyperlinks.Delete
For sh = .Shapes.Count To 1 Step -1
ty = .Shapes(sh).Type
If ty = 12 Or ty = 13 Then .Shapes(sh).Delete
' Type 12 = Control ; Type 13 = Picture
Next sh
End With
End Sub
|
|
star dust
Member of DD Central
Posts: 2,998
Likes: 3,531
|
Post by star dust on Jan 5, 2015 22:10:10 GMT
but it is a chore to get rid of all the boat and house symbols cluttering up the spreadsheet! For those au fait with excel macros, this is the code I have to clean up the list of selling / sold loans when copied and pasted into excel. If you try to do it manually you end up deleting the picture of the house / boat but not the underlying control which contains the picture.
I don't use macros much, but I'll give it a go! Many thanks.
|
|
Investor
Member of DD Central
Posts: 662 
Likes: 590
|
Post by Investor on Jan 6, 2015 12:40:40 GMT
For those au fait with excel macros, this is the code I have to clean up the list of selling / sold loans when copied and pasted into excel. If you try to do it manually you end up deleting the picture of the house / boat but not the underlying control which contains the picture.
I don't use macros much, but I'll give it a go! Many thanks. And if it doesn't work star dust my solution would be simply to select 'match destination format' rather than 'use source format' when pasting into Excel. That's what I always do which I appreciate isn't the perfect solution but gets rid of all the pictures and links and leaves thing looking clean.
|
|
star dust
Member of DD Central
Posts: 2,998
Likes: 3,531
|
Post by star dust on Jan 7, 2015 6:15:02 GMT
And if it doesn't work star dust my solution would be simply to select 'match destination format' rather than 'use source format' when pasting into Excel. That's what I always do which I appreciate isn't the perfect solution but gets rid of all the pictures and links and leaves thing looking clean. It worked a treat, thanks. Haven't tried re-learning my macro skills yet though  .
|
|
unmadem
Member of DD Central
Posts: 377
Likes: 181
|
Post by unmadem on Jan 7, 2015 12:21:37 GMT
It isn't actually easy to workout your actual return on investment on savingstream. While it is stated on the dashboard it is 12% the SS is doing itself an injustice as most have cashback and there is often the option to get the interest up front. Both of which can then be reinvested improving your overall return.
The main difficulty is that interest which has been paid is obviously included in the account balance but there is no easy way to get a figure for the interest which has been accrued but not yet paid. On the live loan parts screen it only shows the total interest due some of which is paid and some of which is not yet paid.
savingstream it would be useful if you could add another column onto the live loan parts screen to show the accrued interest not yet paid and total this at the bottom.
It would also be very helpful if you could allow the live loan parts screen to be exported to Excel in the same way as the transaction statement. Many other p2p sites have this feature already.
|
|
star dust
Member of DD Central
Posts: 2,998
Likes: 3,531
|
Post by star dust on Jan 7, 2015 13:02:16 GMT
savingstream it would be useful if you could add another column onto the live loan parts screen to show the accrued interest not yet paid and total this at the bottom.
It would also be very helpful if you could allow the live loan parts screen to be exported to Excel in the same way as the transaction statement. Many other p2p sites have this feature already. I would second this - I actually suggested they should separate interest due and paid for the PBLs about six or more months ago, but unfortunately it's one suggestion they have not taken up.................................... yet???
|
|
jonno
Member of DD Central
nil satis nisi optimum
Posts: 2,806
Likes: 3,237
|
Post by jonno on Jan 7, 2015 13:29:27 GMT
savingstream it would be useful if you could add another column onto the live loan parts screen to show the accrued interest not yet paid and total this at the bottom.
It would also be very helpful if you could allow the live loan parts screen to be exported to Excel in the same way as the transaction statement. Many other p2p sites have this feature already. I would second this - I actually suggested they should separate interest due and paid for the PBLs about six or more months ago, but unfortunately it's one suggestion they have not taken up.................................... yet??? Thirded (real word?)
|
|
star dust
Member of DD Central
Posts: 2,998
Likes: 3,531
|
Post by star dust on Jan 7, 2015 19:31:41 GMT
Hope this is a good omen. I'm not sure when it happened, but on the main loan page PBLs 11-13 are all showing remaining term as six months, whereas the individual overview pages state 77 days remaining. Certainly last week all were listed as 3 months remaining. Maybe they really will drawdown this week  . |
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Jan 7, 2015 19:32:29 GMT
savingstream it would be useful if you could add another column onto the live loan parts screen to show the accrued interest not yet paid and total this at the bottom. Perhaps all that's needed is for the Accrued Interest column actually to show accrued interest. The standard definition of AI is interest that has been earned but not yet paid. When a loan goes live and interest to that date is paid, there is no more accrued interest at that time. And similarly, when interest is paid at the end of each month, that amount no longer is 'accrued' so the AI again should be nil.
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Jan 7, 2015 19:38:28 GMT
Hope this is a good omen. I'm not sure when it happened, but on the main loan page PBLs 11-13 are all showing remaining term as six months, whereas the individual overview pages state 77 days remaining. Certainly last week all were listed as 3 months remaining. I suspect all that's happened is that savingstream have acknowledged that when the loans actually do go live the borrowers will expect the maturity date to be six months in the future. And I suspect they've simply forgotten to update the individual overview pages as well. I'm half expecting that all loans will continue to show 182 days remaining until they draw down, and only then will the timer start ticking. We'll see what happens tomorrow.
|
|
star dust
Member of DD Central
Posts: 2,998
Likes: 3,531
|
Post by star dust on Jan 7, 2015 19:47:32 GMT
I suspect all that's happened is that savingstream have acknowledged that when the loans actually do go live the borrowers will expect the maturity date to be six months in the future. And I suspect they've simply forgotten to update the individual overview pages as well. I'm half expecting that all loans will continue to show 182 days remaining until they draw down, and only then will the timer start ticking. We'll see what happens tomorrow. Actually, having just checked, PBLs 16 &17 are out of kilter too, so maybe they just set all the non-drawndown ones to 6 months when they inserted the drawdown column yesterday?
|
|
ramblin rose
Member of DD Central
“Some people grumble that roses have thorns; I am grateful that thorns have roses.” — Alphonse Karr
Posts: 1,370
Likes: 857
|
Post by ramblin rose on Jan 8, 2015 10:19:42 GMT
savingstream it would be useful if you could add another column onto the live loan parts screen to show the accrued interest not yet paid and total this at the bottom. Perhaps all that's needed is for the Accrued Interest column actually to show accrued interest. The standard definition of AI is interest that has been earned but not yet paid. When a loan goes live and interest to that date is paid, there is no more accrued interest at that time. And similarly, when interest is paid at the end of each month, that amount no longer is 'accrued' so the AI again should be nil. Just to be nitpicky, and in case any new lenders are slightly misled, when a loan goes live, for those people who have elected to receive interest monthly, the interest isn't paid to date - it is paid up till the end of the latest month. So there would be some accured interest for the current month, unless it went live on the last day of the month, of course. For those who've elected to receive all the interest up-front, it is all paid and there would be no more accrued interest in that case.
|
|
star dust
Member of DD Central
Posts: 2,998
Likes: 3,531
|
Post by star dust on Jan 8, 2015 12:13:28 GMT
Actually, having just checked, PBLs 16 &17 are out of kilter too, so maybe they just set all the non-drawndown ones to 6 months when they inserted the drawdown column yesterday? All in line now and all non-drawn down loans showing 6 months on all tabs pages etc..... pity I was hoping it might mean a drawdown was imminent.  .
|
|
.
.
.