Cryptocurrency Prices Download In One Sheet

Cryptocurrency prices download in one sheet

Crypto investment summit los angeles

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.

Cryptocurrency prices download in one sheet

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.

Cryptocurrency prices download in one sheet

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

Transaction History

Calculator

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.

Cryptocurrency prices download in one sheet

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.