Since 2013, I've been tracking my bitcoin transfers and balances in my own spreadsheet. This is important, because with cryptocurrency, you are your own bank.
Recently I started playing around with Open Ledger and things started getting really complicated because of the various markets there. You can buy cryptocurrencies using various currencies like bitcoin, bitUSD, and BitShares.
Keeping track of an asset's value on these different markets was getting really difficult.
Yesterday, I found this spreadsheet which Pablo Yabo created just a few days ago. It's pretty awesome in that it pulls live rates for various cryptocurrencies. I started working with it and ended up adding a transaction history tab as well so I could keep track of my trades and what the profit/loss is on those trades, as well as the value of my current holdings.
I included a calculator also so I could determine if buying an asset makes sense on a given market, given it's current BTC, USD, or BTS price.
You can have the spreadsheet for free!
How to connect an Excel Spreadsheet to CoinMarketCap (bitcoin)
Just click here, then go to
Here are some screenshots of it in action with some sample data filled in:
Prices & Totals
I really hope you find this as useful as I do.
Let me know if you have any suggestions to improve it!
Updated: See my comment below for a couple new features I added today, the main one being a way to see the balances of your different wallets based on your transaction history.
Thanks for your votes and encouraging words!
He wants to help create a world we all want to live in.