![unnamed.png](https://steemitimages.com/DQmVszf7ACWqLozfxMxNSrWhQLqaCxKFzupYQdgfo8Ly9Vi/unnamed.png)
<h1>Track your entire crypto portfolio balance in a spreadsheet!</h1>
![Screenshot (14).png](https://steemitimages.com/DQmcbBEtALU6iz5JhyYdeWuo56uox7ABuT83vJgVUtMJLya/Screenshot%20(14).png)


I used the API from [Cryptocompare](https://www.cryptocompare.com/api/) to pull the current prices of the coins I'm either interested in or own. With this, you can add your own coins and get the current price by updating the code in cell C3:C6. In cell C8:C10, those are the prices I bought them for. Change those accordingly. 
> For updating the current prices:
   If you click on any of the cells C3:C6, you'll see a long string of text like this

=VALUE(ImportJSON("https://min-api.cryptocompare.com/data/price?fsym=BTC&tsyms=USD","/USD","noHeaders"))
> Updating this to any coin you want is easy:
Simply change fsym=BTC to whatever coin you want to use (ex. I use monero so id use fsym=XMR)
If you are using a different currency, change tsyms=USD to your country's currency code (check the api documentation)

For the last column "Without XMR", you don't have to use that if you don't want to. The reason I have it there is because I didn't put any money into Monero. That was all from mining. So for fun, I wanted to calculate how much I have earned if I hadn't been mining. 
>Here's the link to the Google Sheets: 
https://docs.google.com/spreadsheets/d/1RUZoD8Zjsc0YNePOZ-LUlKCeMO-xCdgtlq6UOm_0sxE/edit?usp=sharing