|
|
Post by cyrilmadrid on Mar 11, 2017 16:40:12 GMT
To diversify platform risk, I started investing across platforms: AC, FS and SS.
Am currently trying to consolidate the export of my positions so as to get a single position.
I am trying to do that in SQL, but run across some programming issues.
Have you tried to do that ?
|
|
bigfoot12
Member of DD Central
Posts: 1,817
Likes: 816
|
Post by bigfoot12 on Mar 12, 2017 14:54:38 GMT
Sorry I can’t help you with SQL as I’ve never tried to import CSVs using it, nor have I tried to consolidate P2P positions. What is it you are trying to achieve? Can you compare a loan on one platform with one on another?
I have done something similar with shares, when I used to have more than one account. I download the CSV files from each platform and import them using Java and the openCSV package. I do this because I have had identical shares on different platforms. The report that the platform sent me was incorrect when calculating capital gains because my average purchase price was wrong.
|
|
|
|
Post by cyrilmadrid on Mar 12, 2017 15:24:06 GMT
What I am trying to do is to view all my loans across 3 platforms in one view, and be able to check concentration -amount by loan-, split by interest rate, split by expiry, ... across my total loan book.
The issue is that the format of exportation from each platform is different, different column names, orders, format -expiry date or days to expiry-, but at the end all provide similar information (loan name, amount, interest rate, ... whatever its called).
A field I miss from all and which would be very useful is the credit status of the loan: paying on time, late payment, defaulted... that would make it easier to make stats of troubled loans.
|
|
|
|
Post by charles on Mar 14, 2017 5:30:12 GMT
What we need is a cross-border, cross-platform secondary market for all these crowdfunded investments/assets. Then you would be able to view and manage all your different positions through just one portal and one sign-in.  |
|
