Get pleasure from this FREE Cryptocurrency spreadsheet that routinely tracks your good points and holdings!
Obtain hyperlink: https://goo.gl/c245nd
Directions:
Obtain and set up the Cryptofinance add on for Google Sheets
Open Portfolio
Choose your native Fiat Forex in Cell A1
Within the blue cells in Row 1, enter the coin’s symbols that you just presently personal (Bitcoin = BTC)
In Row 2, beneath the coin image, enter the ammount of items of that coin you personal.
In Row 3, beneath the quantity of items you personal, enter the worth you paid for the items in whole
Above “Whole Funding” Change “$0.00” to the TOTAL AMOUNT OF FIAT YOU HAVE INVESTED IN CRYPTO
That is it! All the opposite knowledge will populate routinely!
Troubleshooting
Costs not loading – refresh the web page. If that does not work click on “Add-ons”, “CRYPTOFINANCE”, then
“How one can refresh charges”. I’ve discovered that simply clicking that can refresh in most events. If that also does not work
attempt my information within the spreadsheet to set it as much as auto refresh.
Costs not refreshing – If in case you have plenty of totally different cash, it is doable you hit the API restrict of the CRYPTOFINANCE
add on. Strive checking again in quarter-hour to an hour.
For those who like this spreadsheet, and need to hook a hodler up, be at liberty to toss some coin in one in every of my many wallets 🙂
BTC 1HEg2rdaRxdyDh5JPtwHRGJyZ2RcLuhiAt
LTC Le7tRtZe16YY78eUDf46KmEH5kQcC66iaL
ETH 0x9A3F3Fb9C43aAb18342997166DB116A98997b8fb
XRP rEb8TK3gBgk5auZkwc6sHnwrGVJH8DuaLh Deposit Tag 106997144
VEN 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
XLM GAHK7EEG2WWHVKDNT4CEQFZGKF2LGDSW2IVM4S5DP42RBW3K6BTODB4A Memo 1027937250
WAVES 3P2wnqW4GvzMLGwFwKJVh6Dj31Dg1byJ2eo
QTUM QWEs3g6sr7ZGvz84R8fpUYNv4HE3cb6trS
XMR 44tLjmXrQNrWJ5NBsEj2R77ZBEgDa3fEe9GLpSf2FRmhexPvfYDUAB7EXX1Hdb3aMQ9FLqdJ56yaAhiXoRsceGJCRS3Jxkn Fee Id 8dc614d31f141d47192a6c71df497289046b09fce0fc06fe55cb9284b4e72d2b
BNB 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
NEO AHn51DhUE1JEGhcH6XRswZcZxF1smjfmnS
BCASH 1CaEGDGWiDsNqNLzUFZrPm2tfZw4zB1z7y
ICONOMI 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
ZRX 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
OMG 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
WTC 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
LRC 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
YOYO 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
EOS 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
STRATIS SdG6EgmAMgKWEFCR4zYs9ZCNkMbeXuUtZE
KYBER 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
FUN 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
XVG DRV9oSGeAfrQd6Bp5JLz6LFaMZ8PEJQZy6
SALT 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
METAL 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
DASH XymK8nq2u32Qp6S21MDftaZBX1XpfjbV8B
BTG GHxv4ZzZ7TvStmW3JQQUGf2r6Yogh4ECA7
REQ 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
POWR 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
ARK AaW4EZohJEs9hQJUyekzdiwdTBg6xzncJ5
GAS AHn51DhUE1JEGhcH6XRswZcZxF1smjfmnS
BAT 0xafc9ff81826c5ce49eee6f9b7fc7965198656d81
ZCASH t1bpwPhQBHtBLSUifwRhJ6A1EV3u9BzdAL8
source
