0risk
Member of DD Central
Posts: 217
Likes: 202
|
Post by 0risk on Jan 11, 2017 0:03:12 GMT
It would be great to chart my portfolio of loans in terms of loan originators; types; etc in Excel or Google Sheets. So, is there anyone who has done that and wants to share here?
|
|
0risk
Member of DD Central
Posts: 217
Likes: 202
|
Post by 0risk on Mar 13, 2017 18:37:57 GMT
|
|
0risk
Member of DD Central
Posts: 217
Likes: 202
|
Post by 0risk on Apr 9, 2017 0:41:52 GMT
I've just corrected an error in the spreadsheet.
The analysis uses the correct column now: "Outstanding Principal". It was using the "My Investment" column before.
|
|
p40l0m4r
Member of DD Central
Posts: 63
Likes: 16
|
Post by p40l0m4r on Apr 9, 2017 9:44:22 GMT
Hi 0risk, probably you already think that, but in other case I can do some update in the same sheets using pivots, for example putting graph of interest rates showed by timing for each tipe of loan, or delay divided for each type of loans or originator. But I need to know how update this file in google documents, I'm not confidant with that . Can you help me?
|
|
0risk
Member of DD Central
Posts: 217
Likes: 202
|
Post by 0risk on Apr 9, 2017 12:36:25 GMT
Hi 0risk, probably you already think that, but in other case I can do some update in the same sheets using pivots, for example putting graph of interest rates showed by timing for each tipe of loan, or delay divided for each type of loans or originator. But I need to know how update this file in google documents, I'm not confidant with that . Can you help me? I'd like to see your ideas. I've only made those charts. To update this file you just need to open it, log in to google docs, and go to File / Make a Copy. Then you'll have a copy of this spreadsheet in your own google docs. You can edit it as you want. When you feel ready you can go to the File options and Share via web link. You'll be given a link which you can post here. You may want to delete some lines of your investments or hide private information.
|
|
|
Post by buttchopf23 on Apr 9, 2017 12:44:26 GMT
I think p40 would like to know if he can link the file to update it automatically with data from his account. With google docs I am not familiar as well. But with excel it would not be that big of a deal.
|
|
0risk
Member of DD Central
Posts: 217
Likes: 202
|
Post by 0risk on Apr 9, 2017 12:51:56 GMT
I think p40 would like to know if he can link the file to update it automatically with data from his account. With google docs I am not familiar as well. But with excel it would not be that big of a deal. That would be great. I tried the URL www.mintos.com/en/my-investments/list.xlsx but it didn't work. Any idea?
|
|
0risk
Member of DD Central
Posts: 217
Likes: 202
|
Post by 0risk on Apr 9, 2017 13:10:22 GMT
An option is the user save the file to the google drive and then the spreadsheet opens it. It's an improvement, but the user has to have google drive installed.
|
|
p40l0m4r
Member of DD Central
Posts: 63
Likes: 16
|
Post by p40l0m4r on Apr 11, 2017 21:03:50 GMT
I'll do some try when i will have a bit of time..... I'll update soon when I've something
|
|