Bitcoin Forum
May 27, 2018, 05:56:19 PM *
News: Latest stable version of Bitcoin Core: 0.16.0  [Torrent]. (New!)
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Crypto Tracker Excel Sheet  (Read 211 times)
kishijp
Newbie
*
Offline Offline

Activity: 3
Merit: 0


View Profile
November 23, 2017, 05: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.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1527443779
Hero Member
*
Offline Offline

Posts: 1527443779

View Profile Personal Message (Offline)

Ignore
1527443779
Reply with quote  #2

1527443779
Report to moderator
1527443779
Hero Member
*
Offline Offline

Posts: 1527443779

View Profile Personal Message (Offline)

Ignore
1527443779
Reply with quote  #2

1527443779
Report to moderator
1527443779
Hero Member
*
Offline Offline

Posts: 1527443779

View Profile Personal Message (Offline)

Ignore
1527443779
Reply with quote  #2

1527443779
Report to moderator
kishijp
Newbie
*
Offline Offline

Activity: 3
Merit: 0


View Profile
November 23, 2017, 05:40:51 PM
 #2

Would love some feedback Smiley
Winre
Newbie
*
Offline Offline

Activity: 1
Merit: 0


View Profile
December 08, 2017, 07:01:54 AM
 #3

Google says the file is infected....?
mangkanor
Member
**
Offline Offline

Activity: 210
Merit: 10

The revolutionary trading ecosystem


View Profile WWW
December 08, 2017, 07: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.

Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!