|
Post by Ton ⓉⓞⓃ on Nov 9, 2015 16:28:20 GMT
Please, everyone using this thread, do not name Borrowers or give info that can easily be used to i.d. them. I say this because I can see several old posts, as well as the new ones above, that clearly id Borrowers. Please remove them yourselves if we miss them as we are about the go through this thread and try and do so. dawn, SteveT, robberbaronI have just discovered the Saving Stream Facebook page - www.facebook.com/savingstream/ - on which Saving Stream have published (on 20th October) the PBL id, picture of property, amount of loan and valuation for a lot of current active loans. It doesn't name the borrower specifically but it wouldn't be too difficult for some-one to find the information if they tried. Is it OK for them to do this? Genuine question - I am not sure whether it is or not. My gut feeling is not, but there may be business reasons for this and the borrowers may have agreed. If it is not OK then some-one needs to tell them - I haven't asked them about it because I'm not sure whether it is OK or not The short answer is that what they do is down to them. In other words they might have asked them if they can do that, perhaps even paid them. It might be in the small print of the loan agreement that they can be used in advertizement. It's going to be almost vital for a small business to show real people getting real loans to show that p2p works. But we don't have that agreement or understanding with the Borrowers. There have been some long long discussions on this subject in the past. But for simplicity we tend to avoid all business names as it difficulty to work out who is a Borrower and who is not. I lend on just two platforms so I might happen to know a number of them, but no one is going to know all the names of the Borrowers, so that's why we avoid all business names. There is an argument to say the rules need to be updated in this regard as they say at the moment that you can name Borrowers so long as the Platform names them and it's visible there without you having to log in to see it (i.e. it's in the public domain). That's all well and good until next week or next month when the Platform updates it's site and those Borrowers are changed for another set of Borrowers. So while they were visible you could name those Borrowers but they then need to be redacted when they become invisible, this is just about impossible to do, but when there were significantly less Platforms it was almost feasible. A lot more could be said but for the moment hopefully that answers your question.
|
|
stevio
Member of DD Central
Posts: 2,065
Likes: 894
|
Post by stevio on Nov 11, 2015 8:12:11 GMT
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Jan 30, 2016 20:12:40 GMT
I'm trying to use the spreadsheet for the first time since mid-December. I tried to paste in the data from my latest statement CSV download, and it didn't work. So I came back to this thread and realised I'm supposed to do a 'Paste Special - Text' rather than a simple Paste. So far, so good. Then I went back to Excel and tried to do that, but I can't find that option. My Paste command has a lot of options, and hovering over the various icons brings up their descriptions, but none of them is 'Paste Special - Text'. If I click on Paste Special. the dialogue box looks like... ...and I don't see a Text option there either. What am I doing wrong? I don't remember having any trouble finding the appropriate Paste command before. I'm on a Microsoft Office 365 subscription, which means I'm using Excel 2016 now. I don't know when it switched from being Excel 2013, so I don't know if that has anything to do with my problem. Does anyone have any suggestions where else I should be looking for the elusive 'Paste Special - Text' command?
|
|
SteveT
Member of DD Central
Posts: 6,875
Likes: 7,924
|
Post by SteveT on Jan 30, 2016 20:24:10 GMT
I'm trying to use the spreadsheet for the first time since mid-December. I tried to paste in the data from my latest statement CSV download, and it didn't work. So I came back to this thread and realised I'm supposed to do a 'Paste Special - Text' rather than a simple Paste. So far, so good. Then I went back to Excel and tried to do that, but I can't find that option. My Paste command has a lot of options, and hovering over the various icons brings up their descriptions, but none of them is 'Paste Special - Text'. If I click on Paste Special. the dialogue box looks like... ...and I don't see a Text option there either. What am I doing wrong? I don't remember having any trouble finding the appropriate Paste command before. I'm on a Microsoft Office 365 subscription, which means I'm using Excel 2016 now. I don't know when it switched from being Excel 2013, so I don't know if that has anything to do with my problem. Does anyone have any suggestions where else I should be looking for the elusive 'Paste Special - Text' command? Not sure which spreadsheet (or version) you're using but, either way, you'll be wanting the underlying numbers so use Paste Special - Values. I presume you've picked up the data from a CSV download. The time you're likely to get the Paste Special - Text option is if you copy directly from a webpage by highlighting. [This is the version I now use, taking the account transactions CSV download as its input, rather than copying from the screen on the old SS website: p2pindependentforum.com/post/74480/thread]
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Jan 30, 2016 20:35:28 GMT
Not sure which spreadsheet (or version) you're using but, either way, you'll be wanting the underlying numbers so use Paste Special - Values. I presume you've picked up the data from a CSV download. The time you're likely to get the Paste Special - Text option is if you copy directly from a webpage by highlighting. I tried Paste Values, but when I look at the Loans Summary tab, the amounts I see still show the mid-Dec data. For instance, it still shows I have some of PBL028 which repaid today. Looking at the Txns Extract tab, I can see today's capital repayment for PBL028, so I know the data has been transferred across. It's as if the pivot table hasn't refreshed itself. I've tried forcing a 'recalculation' but that had no effect. Is there a different way to force the pivot table to update itself?
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Jan 30, 2016 20:47:41 GMT
OK. Problem solved now. Looking at the above link, I'm pretty sure I'm using that version of the spreadsheet (my copy has the same name, seems to be the right size (77,455 bytes) and was downloaded after the message was posted). But the critical instruction in that message was the one about right-clicking within the pivot table and Refreshing. Sorry to have bothered you. Thanks for your input. Enjoy the rest of your weekend. I'm afraid I don't use the spreadsheet often enough -- and don't use pivot tables myself -- to remember the special instructions. I must remember to look at the first post in this thread the next time I get myself in trouble!
|
|