Author

Topic: Crypto Tracker Excel Sheet (Read 333 times)

member
Activity: 210
Merit: 10
December 08, 2017, 02:46:21 AM
#4
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.
newbie
Activity: 1
Merit: 0
December 08, 2017, 02:01:54 AM
#3
Google says the file is infected....?
newbie
Activity: 3
Merit: 0
November 23, 2017, 12:40:51 PM
#2
Would love some feedback Smiley
newbie
Activity: 3
Merit: 0
November 23, 2017, 12:17:19 PM
#1
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.
Jump to: