Better manage your cryptocurrencies portfolio with Google Sheets add-ons
Post date: Jun 06, 2018 4:4:6 PM
Tracking cryptocurrency market prices is a great challenge! This distinctive market is highly volatile and ever-changing. Over 1,600 cryptocurrencies are listed on coinmarketcap.com and the list keeps growing.
In order to track their assets, many cryptocurrency investors choose to build their own dashboard with a spreadsheet. It is a simple and efficient solution, fully customized, to record trades, add up investments, and hopefully oversee profit!
Retrieving market values directly in a spreadsheet is already possible via GOOGLEFINANCE, a Google Sheets formula, but Bitcoin is the only cryptocurrency value available. Since last year, some clever add-ons have been launched to help you get information on cryptocurrency market and fill in the gap left by Google!
Here is top 3 of best add-ons for cryptocurrencies trading that you need to install whether you are a beginner or an expert!
Cryptofinance lets you retrieve rates, market cap, volume, currency exchange, and total supply with the single formula '=CRYPTOFINANCE( )'. This truly is the best way to build your own dashboard from scratch. As Cryptofinance uses Coinmarketcap data, you’ll get access to over 1,600 indexed cryptocurrencies. In addition to market values, this add-on provides sentiment analysis based on general market trends. No wonder why Cryptofinance is so popular (+79K installs)!
+ : This free add-on is very comprehensive and suitable for experts with high analysis needs
- : Building your dashboard will take time. But you can reuse templates shared by some users (such as this one)
Get the tutorial here.
If you don’t like using formulas, Spreadstreet is a great option. This add-on helps you import market data and aggregated stats to your spreadsheet. Spreadstreet uses every major trading platform API (Bittrex, Bitcoin Charts, Bitfinex,…) to offer a wide range of data sources. In addition to pulling data from specific exchange platforms, you also will be able to compare trading platforms with each other for optimizing your portfolio value. To access this solution, you need to have a Spreadstreet account and pay a monthly fee.
+ : The simple sidebar will help you get started very easily
- : The free trial period of two weeks is a little short for exploring fully the tool
Get the tutorial here.
This third add-on is very easy to use and will be much appreciated by beginners! Track my crypto provides a mail alert service that warns you when a selected price point in crossed. This is the perfect way to reach your target sell price. Track my crypto also offers a quick way to retrieve market value in a spreadsheet: Select which cryptocurrency you would like to track and you’ll get a recap table in Google Sheets. Adding a few basic formulas, you’ll get the value of your portfolio in no time.
+ : The setup is very easy for a valuable and customizable mailing service
- : Only the top ranked cryptocurrencies on coinmarketcap.com are available for now (BTC, ETH, XRP, …)
Get the tutorial here.