CryptoCurrency Portfolio Template Version 2 for Google Sheets by mix1009

View this thread on: hive.blog | peakd.com | ecency.com

cryptocurrency · @mix1009 · Feb 8 '18

$1.20

CryptoCurrency Portfolio Template Version 2 for Google Sheets

Here is CryptoCurrency Portfolio Template version 2 for Google Sheets:

https://docs.google.com/spreadsheets/d/1thBM8j6R_q9XWQCKEXtXo59TtHormuyBrFoEduU7iU8/edit?usp=sharing

![Screen Shot 2018-02-08 at 8.20.45 PM.png](https://steemitimages.com/DQmPQ7Aa4iXZJazn4Uq2ttK2smLDZgNYFPid5cauSXQodtb/Screen%20Shot%202018-02-08%20at%208.20.45%20PM.png)

I also made a YouTube video on setup and adding new crypto:
https://www.youtube.com/watch?v=P3EO0p2LBb8

Version 2 Updates:
1. YouTube Video - Setup & Adding Crypto.
2. Added 1h percent changes column. It’s hidden by default. You can show it by clicking arrows between column E and G.
3. Added 3 columns (J,K,L) for marketcap, available supply & total supply. (hidden by default)
4. Added “ETH” column and ETH gains calculator. (Do not delete Ethereum from the sheet for it to function properly)
5. Added “Add” coin button. It will copy last row. You have to fill out the COIN ID and update crypto holdings.
6. Added “Update” button. Don’t abuse it though.
7. Added “Cash holdings” in AM13.
8. Better UPDATE performance when you have a lot of cryptos(>30) : request top 100 coins and uses it as cache.

Here is the link to original steemit post and update post for version 1:
* https://steemit.com/cryptocurrency/@mix1009/cryptocurrency-portfolio-template-for-google-sheets
* https://steemit.com/cryptocurrency/@mix1009/cryptocurrency-portfolio-template-update

If you want to contribute:
* Please upvote or resteem this article
* Use my referral link to join Binance: https://www.binance.com/?ref=10032265
* You can find my Ethereum and Bitcoin addresses in the template

👍 mix1009, lorem, farq, krazykov, benjaminlostler, cryptoboyjon, rajureddy, porters, bikeitjohn, tanso, barkeybark, criptoviciado, ste.crycur, oskillator, galant168, baudi, edgeball, lynchr20, contrarius

`author`	mix1009
`permlink`	cryptocurrency-portfolio-template-version-2-for-google-sheets
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency","crypto","bitcoin"],"image":["https://steemitimages.com/DQmPQ7Aa4iXZJazn4Uq2ttK2smLDZgNYFPid5cauSXQodtb/Screen%20Shot%202018-02-08%20at%208.20.45%20PM.png","https://img.youtube.com/vi/P3EO0p2LBb8/0.jpg"],"links":["https://docs.google.com/spreadsheets/d/1thBM8j6R_q9XWQCKEXtXo59TtHormuyBrFoEduU7iU8/edit?usp=sharing","https://www.youtube.com/watch?v=P3EO0p2LBb8","https://steemit.com/cryptocurrency/@mix1009/cryptocurrency-portfolio-template-for-google-sheets","https://steemit.com/cryptocurrency/@mix1009/cryptocurrency-portfolio-template-update","https://www.binance.com/?ref=10032265"],"app":"steemit/0.1","format":"markdown"}
`created`	2018-02-08 11:33:57
`last_update`	2018-02-08 11:33:57
`depth`	0
`children`	13
`last_payout`	2018-02-15 11:33:57
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	1.188 HBD
`curator_payout_value`	0.015 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,616
`author_reputation`	378,420,569,657
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	35,896,583
`net_rshares`	174,487,274,259
`author_curate_reward`	""

properties (23)vote details (19)

voter	rshares	pct
contrarius	0	100%
lynchr20	0	0%
mix1009	134,819,435,420	100%
edgeball	0	100%
baudi	0	100%
krazykov	617,220,000	100%
galant168	0	100%
lorem	27,932,586,447	100%
oskillator	0	100%
farq	9,274,400,112	100%
ste.crycur	0	100%
criptoviciado	0	100%
cryptoboyjon	614,473,939	100%
benjaminlostler	614,708,389	100%
barkeybark	0	100%
rajureddy	614,449,952	100%
tanso	0	100%
bikeitjohn	0	100%
porters	0	100%

@auskev · Feb 28 '18

Fantastic work @Mix1009. Adding and updating cryptos is a piece of cake.  I've made a copy of the sheet and added some extra worksheets to make it a one stop shop for all my crypto strategies and notes, such as a worksheet to keep track of upcoming ICO's I'm invested in.

properties (22)

`author`	auskev
`permlink`	re-mix1009-cryptocurrency-portfolio-template-version-2-for-google-sheets-20180228t200616053z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"users":["mix1009"],"app":"steemit/0.1"}
`created`	2018-02-28 20:06:18
`last_update`	2018-02-28 20:06:18
`depth`	1
`children`	1
`last_payout`	2018-03-07 20:06:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	271
`author_reputation`	1,194,043,612
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	41,208,363
`net_rshares`	0

@namhb · Mar 31 '18

Could you share with else what you added?

properties (22)

`author`	namhb
`permlink`	re-auskev-re-mix1009-cryptocurrency-portfolio-template-version-2-for-google-sheets-20180331t205405194z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"app":"steemit/0.1"}
`created`	2018-03-31 20:54:03
`last_update`	2018-03-31 20:54:03
`depth`	2
`children`	0
`last_payout`	2018-04-07 20:54:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	41
`author_reputation`	0
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	47,678,769
`net_rshares`	0

@baudi · May 4 '18 (edited)

could you (please! :)) add a column with max price in btc&$ and divide that with current price (in btc/$) so that we get a multiplier (x times that the price need's to rise to ATH) it would be a nice tool to have to quickly pick which coins are attractive to buy(/which to sell)
i dont know how to program and  i am now doing it "by hand" is so f?%=& up :)
if you could reply (if updated) or if i can "contract" you to do that for a few sat. ? :)
thank you

properties (22)

`author`	baudi
`permlink`	re-mix1009-cryptocurrency-portfolio-template-version-2-for-google-sheets-20180504t155946170z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"app":"steemit/0.1"}
`created`	2018-05-04 15:59:45
`last_update`	2018-05-04 16:02:57
`depth`	1
`children`	0
`last_payout`	2018-05-11 15:59:45
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	456
`author_reputation`	597,576,972
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	53,862,923
`net_rshares`	0

@edgeball · May 29 '18

just figured out that there's V2 now. Love the new addings! Great work!

is it possible for V3 to add BTC total?
I added it in V1 so that I can see it in the history tab and create a chart

properties (22)

`author`	edgeball
`permlink`	re-mix1009-cryptocurrency-portfolio-template-version-2-for-google-sheets-20180529t144721822z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"app":"steemit/0.1"}
`created`	2018-05-29 14:47:21
`last_update`	2018-05-29 14:47:21
`depth`	1
`children`	0
`last_payout`	2018-06-05 14:47:21
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	188
`author_reputation`	0
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	58,287,420
`net_rshares`	0

@lorem · Feb 8 '18

$0.93

항상 유용하게 쓰고 있습니다. 업데이트 버전 고맙습니다.

👍 mix1009

`author`	lorem
`permlink`	re-mix1009-cryptocurrency-portfolio-template-version-2-for-google-sheets-20180208t120159280z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"app":"steemit/0.1"}
`created`	2018-02-08 12:02:00
`last_update`	2018-02-08 12:02:00
`depth`	1
`children`	1
`last_payout`	2018-02-15 12:02:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.696 HBD
`curator_payout_value`	0.232 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	31
`author_reputation`	771,169,977,421
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	35,901,004
`net_rshares`	134,819,435,420
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
mix1009	0 B		134,819,435,420	100%

@mix1009 · Feb 8 '18

사용하면서 불편한 점 있으시면 알려주세요~

properties (22)

`author`	mix1009
`permlink`	re-lorem-re-mix1009-cryptocurrency-portfolio-template-version-2-for-google-sheets-20180208t140519544z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"app":"steemit/0.1"}
`created`	2018-02-08 14:05:21
`last_update`	2018-02-08 14:05:21
`depth`	2
`children`	0
`last_payout`	2018-02-15 14:05:21
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	23
`author_reputation`	378,420,569,657
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	35,923,700
`net_rshares`	0

@morrocoin · Jul 4 '18

Thanks for you sharing your work!

A few minutes after adding new tokens to my copy, I get this message:

Request failed for https://api.coinmarketcap.com/v1/ticker/bitcoin?convert=EUR returned code 429. Truncated server response: (html comment removed: [if lt IE 7]> <![endif]) (html comment removed: [if IE 7]> <html class="no-js ie7 oldie" lang="en... (use muteHttpExceptions option to examine full response).DetailsDismiss

Am I doing something wrong? now the sheet will not update.

Thanks again!)

properties (22)

`author`	morrocoin
`permlink`	re-mix1009-cryptocurrency-portfolio-template-version-2-for-google-sheets-20180704t163215271z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"links":["https://api.coinmarketcap.com/v1/ticker/bitcoin?convert=EUR"],"app":"steemit/0.1"}
`created`	2018-07-04 16:32:15
`last_update`	2018-07-04 16:32:15
`depth`	1
`children`	0
`last_payout`	2018-07-11 16:32:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	502
`author_reputation`	0
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	63,409,587
`net_rshares`	0

@rajureddy · Feb 13 '18 (edited)

Hi Mix,
 
Thanks for the updated version. I have seen the script and there is nothing suspicious about it but I'm little concerned if there is any chance they get the access to our drive and spreadsheet as they can update their script anytime. To be on safe side I suggest not to store any personal details on this sheet and it's better to use a new Gmail account in which you have nothing to lose.  
![CryptoPrice.PNG](https://steemitimages.com/DQmRWVg4yQE44q3JVTRMZY6PW2uZdudC6F3zgLJGEeHkTVm/CryptoPrice.PNG) ![View and Modify.PNG](https://steemitimages.com/DQmSpdckvs9cyjypWWkdK4yT57ZGaiGtAEWJTFgKu6wSJUe/View%20and%20Modify.PNG).   
You are giving permission to CryptoPrice to view and manage your ALL your spreadsheets in google drive and also you are giving permissions to Create, Modify existing spreadsheets. Keeping this in mind it's better to create a new Gmail account separately for this spreadsheet. Hope this helps someone. Appreciate your response. Thanks! Cheers mate.

properties (22)

`author`	rajureddy
`permlink`	re-mix1009-cryptocurrency-portfolio-template-version-2-for-google-sheets-20180213t013635263z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"app":"steemit/0.1","image":["https://steemitimages.com/DQmRWVg4yQE44q3JVTRMZY6PW2uZdudC6F3zgLJGEeHkTVm/CryptoPrice.PNG","https://steemitimages.com/DQmSpdckvs9cyjypWWkdK4yT57ZGaiGtAEWJTFgKu6wSJUe/View%20and%20Modify.PNG"]}
`created`	2018-02-13 01:36:33
`last_update`	2018-02-13 02:13:51
`depth`	1
`children`	1
`last_payout`	2018-02-20 01:36:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	984
`author_reputation`	75,270,775
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	37,075,838
`net_rshares`	0

@mix1009 · Feb 14 '18

I believe when you make a copy, the script is also copied. So I don't think I can update the script after the sheet is copied. If I can change it after distributing it, it would be a big security threat to the users of the template. It's a good tip though. If you can read javascript, please read the code and see if there is no suspicious code.

properties (22)

`author`	mix1009
`permlink`	re-rajureddy-re-mix1009-cryptocurrency-portfolio-template-version-2-for-google-sheets-20180214t030610322z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"app":"steemit/0.1"}
`created`	2018-02-14 03:06:12
`last_update`	2018-02-14 03:06:12
`depth`	2
`children`	0
`last_payout`	2018-02-21 03:06:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	345
`author_reputation`	378,420,569,657
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	37,366,274
`net_rshares`	0

@ruimleal · May 23 '18

Needs a V3 for the new api v2 of Coin Market Cap, will you release it? Thanks for this while it worked

properties (22)

`author`	ruimleal
`permlink`	re-mix1009-cryptocurrency-portfolio-template-version-2-for-google-sheets-20180523t195529669z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"app":"steemit/0.1"}
`created`	2018-05-23 19:55:30
`last_update`	2018-05-23 19:55:30
`depth`	1
`children`	0
`last_payout`	2018-05-30 19:55:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	102
`author_reputation`	814,223,384
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,325,400
`net_rshares`	0

@samsara111221 · Apr 27 '18

Hi there!

I get an error on the Script Editor when choosing > Select Function > Update > Run ...

The error says the following:

Service invoked too many times for one day: urlfetch. (line 102, file "Code")

Line 102 of the file code contains:

var response = UrlFetchApp.fetch(url);

What could be the issue?

What could be the solution?

I've already allowed permission for CryptoPrice.

See attached image for further detail.

Thanks for your help!

![Screen Shot 2018-04-27 at 7.51.11 PM.png](https://steemitimages.com/DQmTYvZ2BQkFofvkTNKTF8bVGKbPWexvYfZWp8DfVKQovHh/Screen%20Shot%202018-04-27%20at%207.51.11%20PM.png)

properties (22)

`author`	samsara111221
`permlink`	re-mix1009-cryptocurrency-portfolio-template-version-2-for-google-sheets-20180427t180416861z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"image":["https://steemitimages.com/DQmTYvZ2BQkFofvkTNKTF8bVGKbPWexvYfZWp8DfVKQovHh/Screen%20Shot%202018-04-27%20at%207.51.11%20PM.png"],"app":"steemit/0.1"}
`created`	2018-04-27 18:04:18
`last_update`	2018-04-27 18:04:18
`depth`	1
`children`	0
`last_payout`	2018-05-04 18:04:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	623
`author_reputation`	0
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	52,498,636
`net_rshares`	0

@ste.crycur · Apr 1 '18

Thank you very much for this amazing sheet.
In the history pages it doesn't add new coin and when I try to edit the code to help you to improve the spreadsheet, it apperas this sentence:
TypeError: Cannot call method "getRange" of undefined. (riga 176, file "Code")

properties (22)

`author`	ste.crycur
`permlink`	re-mix1009-cryptocurrency-portfolio-template-version-2-for-google-sheets-20180401t204950724z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"app":"steemit/0.1"}
`created`	2018-04-01 20:49:51
`last_update`	2018-04-01 20:49:51
`depth`	1
`children`	1
`last_payout`	2018-04-08 20:49:51
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	265
`author_reputation`	0
`root_title`	"CryptoCurrency Portfolio Template Version 2 for Google Sheets"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	47,826,347
`net_rshares`	0

@ste.crycur · Apr 23 '18

help !!

properties (22)