10 months ago I tweaked an existing spreadsheet to create the Cryptocurrency Bank Spreadsheet. I also updated it 8 months ago. I use a version of this spreadsheet myself almost every day. My version includes some buttons to refresh things and take portfolio snapshots, but I chose not to include those features here because they require you to grant access to the script to write to your spreadsheet, and I'd rather not train users to do things like that for security reasons. On this one, just manually change the number in the refresh sell to update the prices.
This spreadsheet is free for you to use. Just use this link to create a copy:
https://docs.google.com/spreadsheets/d/1bcPgtaE7FL0wTXpuMyc3jYBB9sOlQEZbb6A24hz3AXE/copy
Or you can preview it here:
https://docs.google.com/spreadsheets/d/1bcPgtaE7FL0wTXpuMyc3jYBB9sOlQEZbb6A24hz3AXE/edit
Seriously though, make a copy. Don't request access to edit it directly. If you're viewing it, go to:
File -> Make a Copy.
Even though the instructions clearly talk about making a copy, I've had over 50 people request access to the spreadsheet. Why are instructions so hard to follow? I have no idea. Instead, follow the instructions, make a copy, and update it however you like. If you're using a copy of the older version, I recommend using this one instead so it will work more consistently for you.
Major changes in this update:
I removed reliance on the CryptoCompare API. After many months of talking with one of their developers, hoping to have individual tokenized access to the API so the Google Sheets IP address wouldn't get rate limited, we ended up deciding it would be better to rebuild things to pull all currencies at once instead of individually. Once I looked into doing that, I figured using the CoinMarketCap data made more sense since some of the currencies I own were not properly listed on CryptoCompare and most people use CoinMarketCap anyway. It also greatly simplified the code to not use the legacy stuff in the spreadsheet I originally started with.
I've added ETH as a trading pair. This is very helpful for when you're buying something on exchanges like EtherDelta and they price things in ETH. Sometimes when you buy something, it may or may not be a good trade later depending on which currency pair you used at the time. Keeping track of the pairs you used is helpful for making better decisions in the future.
I know there are many other spreadsheets and tools out there now, so feel free to use what works best for you. A mobile app I've been enjoying lately is Coin Stats. Here's my referral link if you want to check that out for IOS.
I hope the traders out there are having fun with all this volatility and the holders are confident in the future value they'll someday enjoy.
For more information about this spreadsheet, please see the original post.
Some things to keep in mind with cryptocurrency:
- You are your own bank. You have to keep track of everything yourself.
- If you don't control the private key, you don't own the cryptocurrency. For this reason, decentralized exchanges like BitShares are great: https://wallet.bitshares.org/?r=luke-stokes
- Because you are your own bank, understanding this stuff is important. Start with the older videos I put together at http://understandingblockchainfreedom.com
I hope you're having a great day! Also, wow, thank you to those who welcomed my sister @karaelizabeth to Steemit. Her first post got over 3,600 views and 430 comments! That's amazing. :)
