Very insightful tips, thanks.

Excellent post.  Thanks for sharing.  I've resteemed it as well.

Great post! Thanks alot. I have one issue thou. The "Current allocation" percentage Is completely of. It sums up to 700% and should 100% right. What could be wrong?

Hi thor love your rebalancing spread sheet. Now coinmarketcap is updating their api data to v2. I see in your spread sheet your using v1. How would I or you implement the v2 api data to work with your spread sheet? I tried just changing v1 to v2 in the google Script editor but it looks like it didn't work once I saved it. Would it be possible for you to update your spread sheet? Thanks again. 

s.

Amazingly useful stuff, man! Much respect to you for sharing this!!

Is it possible to use this sheet to view the results of this strategy applied to the past month?

Thanks for the info dude!  Shoutout to coinmastery.com which led me to this.

Love this thank you! I saw this on CoinMastery Youtube page. Question: My portfolio is about 13 coins. I cut/paste the names/quantities of them from another spreadsheet, but the current coin price isn't refreshing. I updated the script and pressed refresh as you stated.  Any thoughts...

Hello, Bitcoin Cash is not recognised? Do you know what to put? I've tried 'Bitcoin Cash' 'BCH' 'BitcoinCash' etc. Thanks in advance.

Awesome! I'm excited to check this out. Thank you for sharing with the community. We're all in this together!

Well done, like and resteemed! 
Nice to see the CCC so active in here!

Thanks for posting, really saves a lot of work! I've noticed prices Coinbase/GDAX differ a lot from those at coinmarketcap at times. As the former is where I trade atm, would it be possible to change the script to read prices from there? The API is there, but I've tried a few times to change the script - without success. :( https://developers.coinbase.com/api/v2

Thanks for posting, really saves a lot of work! I've noticed prices Coinbase/GDAX differ a lot from those at coinmarketcap at times. As the former is where I trade atm, would it be possible to change the script to read prices from there? The API is there, I just don't know how to write the Script. :( https://developers.coinbase.com/api/v2

Cool, but why did you not address one of the most important questions: how often and when to rebalance? Once a year? Once a month? Once a week?

Thanks for sharing the Google Sheet.

I've added these functions to get data from Bitstamp and Bitfinex. Call them from the cells as you would ccprice (including the last parameter which references the cell I5 that gets updated with the timestamp upon refresh)

function bitfinexPrice(name, datetime)
{
  var url = "https://api.bitfinex.com/v1/pubticker/" + name;
  var response = UrlFetchApp.fetch(url);
  var json = response.getContentText();
  var data = JSON.parse(json);
  var price = data["last_price"];
  SpreadsheetApp.flush();
  return price; 
}

function bitstampPrice(name, datetime)
{
  var url = "https://www.bitstamp.net/api/v2/ticker/" + name + "/";
  var response = UrlFetchApp.fetch(url);
  var json = response.getContentText();
  var data = JSON.parse(json);
  var price = data["last"];
  SpreadsheetApp.flush();
  return price; 
}

Thank you so much, thorthur22.

Looks awesome, I definitely want to put some thought into this and adapt it for my needs. More specifically, I've made a decision on the money I've put into crypto not to take it out - at least not for the short term..waiting til Bitcoin hits the high $6,000's (a la Clif High) before I consider pulling some crypto out to invest in more silver.

Anyway, what I'm trying to say is that whenever I "sell" an altcoin, it's just selling into Bitcoin for a bit of arbitrage profit. I want to use your spreadsheet simply replacing USD with Bitcoin (removing BTC from the Asset Class column and valuing all other cryptos in BTC instead of USD). That should work though! :)

Awesome tool! its a good way to robot sellings and buys and cut the emotion orders

https://media.giphy.com/media/lCAkyIbqDDSLe/giphy.gif

Thanks a lot for this article. Upvote from me.

Hi

For some reason the table stopped to refresh the current price of the coins.

thanks for sharing this. Have saw it first on CCC, so it's fair I comment it here. Keep up the good work!

This looks great, thanks for sharing!

Thanks very much for this tool! Just learned about it from Coin Mastery.

Would you address the comment posted by one guy under Giovanni post? 

Quotation:

"maybe I'm just tired and not reading this correctly, but your calculation doesn't work.

If on day 2 when BTC goes up to 3000, and you rebalance "To rebalance your portfolio you sell the excess BTC and get USDT. This will give you a portfolio with 5 BTC and 13750 in USDT".

According to that you've just made USDT out of nowhere without actually selling any of your 5 BTC. I assume you mean that you sell 0.416 BTC to USDT which would actually leave you with 4.583 BTC and 13750 in USDT (the equivalent vales of both)."

and then:

"If you forgot to take away the BTC you sold each time in your calculations it would explain your crazy exponential graph.
After day 3 when BTC goes down to 2300 and you rebalance you'd actually have 5.281 BTC and $12,145USDT = $24290 value. Now this is still better than holding for sure, but does not put you in front of where you've started."

This post received a 3.0% upvote from @randowhale thanks to @thorthur22!  For more information, [click here](https://steemit.com/steemit/@randowhale/introducing-randowhale-will-you-get-the-100-vote-give-it-a-shot)!

thank you; one thing though: to add more coins, you didnt explain how; what im doin is copying the previous line and modifying it, currently figuring out if its working

Hi friend, very good !!!!!
You would help me with a vote in my Blog., Thanks !!! ;)

Try to rebalance your portfolio via [coinwizard.me](https://coinwizard.me)

Tip!