Live Tracking Cryptocurrency With Spreadsheet

Live tracking cryptocurrency with spreadsheet

Live tracking cryptocurrency with spreadsheet

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.

Live tracking cryptocurrency with spreadsheet

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.

Live tracking cryptocurrency with spreadsheet

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.

How to Code Google Sheets to Track Cryptocurrencies' Prices

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!

Just click here, then go to

Here are some screenshots of it in action with some sample data filled in:

Prices & Totals

Transaction History


I really hope you find this as useful as I do.

Let me know if you have any suggestions to improve it!

Happy trading!

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.

Live tracking cryptocurrency with spreadsheet

Thanks for your votes and encouraging words!

Luke Stokes is a father, husband, business owner, programmer, voluntaryist, and blockchain enthusiast.

He wants to help create a world we all want to live in.