Google Sheets Cryptocurrency Portfolio with Coinmarket Cap Integration

in #cryptocurrency7 years ago

After a good bit of searching for a solid tool to track all my buys and sells and holdings of cryptocurrencies and tokens, I happened upon this post by Steemit user jhcooper7 (worth a follow; lots of good portfolio management posts). That post described how to use the script developed by GitHub contributor rathergood to integrate Coinmarketcap prices and other data into a Google Sheets workbook.

Based on his instruction, I built a workbook with separate sheets for each of my crypto holdings, to track the individual buy and sell histories, with a summary sheet that uses the coinmarketcap script to track price movement and profit/loss, etc.

If you look at my spreadsheet, you can see all my actual data, cause I don’t care and didn’t feel like making a fake version for sharing. It should not take much more than a cursory look to determine that no one should be modelling their actual holdings after me, but the spreadsheet itself is pretty sweet.

So, if this looks like a good solution or at least starting point for you, rip a copy and have at it.

If you like the tools, please show love to rathergood and jhcooper for their contributions.

Sort:  

Congratulations @isskewl! You have received a personal award!

1 Year on Steemit
Click on the badge to view your own Board of Honor on SteemitBoard.

By upvoting this notification, you can help all Steemit users. Learn how here!

Congratulations @isskewl! You received a personal award!

2 Years on Steemit

Click here to view your Board

Do not miss the last post from @steemitboard:

SteemWhales has officially moved to SteemitBoard Ranking
SteemitBoard - Witness Update

Support SteemitBoard's project! Vote for its witness and get one more award!

Congratulations @isskewl! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 3 years!

You can view your badges on your Steem Board and compare to others on the Steem Ranking

Vote for @Steemitboard as a witness to get one more award and increased upvotes!