Track your cryptocurrency portfolio on WazirX, CoinDCX, and Binance in Google sheets
I have been in the cryptocurrencies game for more than 3 years now, and had been using other crypto exchanges like unocoin, coinbase etc. previously. However, currently the most popular exchange in India is WazirX, so I shifted to it recently. But I didn’t like that it didn’t have the basic feature of showing its users their profits/losses. To rectify it, I decided to make a google sheet that does it for me. I went through the WazirX API and figured out the basic mechanics. The result is this Google sheet (link below). It fetches the latest prices from WazirX API everytime you click on the refresh data checkbox, and updates the whole sheet.
Please dont request to edit the file (for obvious reasons). To use the sheet, click File -> Make a copy, and then you can edit that to make your own portfolio.
If the Current Price column (I) shows error, create an ImportJSON function first. Go To -> Tools -> Script Editor -> Copy the script from here -> Save it as ImportJSON.js.
To add your transactions, download your Trading Report in excel format from WazirX, go to its Exchange Trades sheet, and copy paste values from the columns B:H here. The rest of the columns should get updated automatically; if they dont, copy paste the formula from rows above.
Click the checkbox under Refresh Data to fetch the current price and update the sheet. You can also update the sheet to fetch prices from other exchanges. Let me know if you want to know how.
I posted this first on reddit and have been updating it based on people’s requests ever since. I have added tabs for CoinDCX and Binance as well, two more popular crypto exchanges in India, on request from some people. The mechanics are similar for those.
I have also added a portfolio pie chart and 24 hour change% to crypto prices for convenience. Surprisingly WazirX api doesn’t have the direct option for it so had to make a formula for that. Furthermore, you can also track your PnL (Profit/Loss) on sold assets, so have added that for each tab too. Scroll down to see it.
You can also add more cryptocurrencies supported by WazirX, or CoinDCX or Binance. Just add the Crytpo pair in the Market column, and if the pair is supported, the sheet will automatically display the price.
Let me know if you want to request any more features in the sheet, or have any doubts. Cheers!
