My Crypto Portfolio Spreadsheet using Google Sheets (REAL TIME DATA) Tutorial

Описание: In this video we will be creating a basic crypto portfolio management template so you can keep track of your existing crypto investments and monitor others on your watchlist.

As promised I have left the formula's to add into the relevant tab of your spreadsheet within this description and as follows:

Real time current price data example using Fantom, Ticker FTM: =IMPORTDATA("https://cryptoprices.cc/FTM/")
So using a different token change FTM to example: BTC

All time high formula using again Fantom as an example,
=IMPORTDATA("https://cryptoprices.cc/FTM/ATH/")

To get percentage use the following formula. =(click current price box-click all time high box)/click all time high box and then press enter. You can then click format and change to percentage.

To get your percentage from your price bought use the following:
=(click current price box-click price bought box)/click price bought box and then enter. Then format and change to percentage.

We hope you liked the video guys consider watching our video on our top 3 alts this week    • Top 3 Alts this Week Crypto Analysis