Bitcoin Forum

Alternate cryptocurrencies => Altcoin Discussion => Topic started by: kishijp on November 23, 2017, 05:17:19 PM



Title: Crypto Tracker Excel Sheet
Post by: kishijp on November 23, 2017, 05:17:19 PM
Hi guys I'm Kishi from Japan, I've just got started in Crypto from June this year and I've been loving everything about crypto and especially the communities. I've learnt so much from the subreddits over the last few months and thought it is time to give back. I've developed my own excel spreadsheet that tracks my crypto portfolio (update the prices through a macro from coinmarketcap.com) and produces a nice pie chart. It also has another worksheet that tracks the prices / market cap of the top 50 coins from coinmarketcap.com to highlight the big movers and losers over a 24 hour period.

I hope some of you will find it useful (link below). Also, let me know if you have any questions on how to use it or if it doesn't work for you. Thanks again!

https://drive.google.com/file/d/16X6d8K5AXn7GboAtfJpds1W35XmqJIBR/view

Pics: https://imgur.com/a/1REs6

How to use:

1) Download the spreadsheet

2) Allow Macro execution so spreadsheet can update

3) Press the update button located on the second and last page.

Edit: The tool was developed in a Windows environment and does not appear to be compatible with Mac-OS. If someone knows how to modify the code to make it compatible for Macs, please let me know and I can update the uploaded file.


Title: Re: Crypto Tracker Excel Sheet
Post by: kishijp on November 23, 2017, 05:40:51 PM
Would love some feedback :)


Title: Re: Crypto Tracker Excel Sheet
Post by: Winre on December 08, 2017, 07:01:54 AM
Google says the file is infected....?


Title: Re: Crypto Tracker Excel Sheet
Post by: mangkanor on December 08, 2017, 07:46:21 AM
Beware of the file it may be infected by some virus,or worst RAT i would rather keep using coinmarketcap to see the price movements of each coins.