Cryptocurrency Real-time Price Tracker (Excel Spreadsheet)

Hello,

Recently I saw some post explaining how to keep track of your coins using Google/Excel Spreadsheets. Well, today I would like to share with you the document I've been using for the past year. It is a document I created based on my needs. Here is a simple video tutorial on how the document works:

Here you can download the document: https://goo.gl/2rF7Dn

As I mention in the video, it is very simple to use, it does not have any VBA/Macro, it does not have any viruses (You can run a virus scan to prove it). The document is connected to worldcoinindex website and it updated the price of the coins every minute. Additionally, using the dropdown you can chose from 100 different coins.

If you are like me and don't like watching boring videos, here is a simple guide of how the document works:

1. Simply type or select your coin from the dropdown:

1. After you select your coin from the dropdown, here you will have a summary of the current price of the coin:

1. Here you will be able to add your trades on that coin:

1. And as soon as you start filling in your trades, you will have a summary of the coins you owned:

1. On the document, I have 5 different (For the currencies I owned), and based on those 5 tabs, you will have this small dashboard:

1. Also, I added a converter calculator

.

Again, this is the way I track my coins, It does not mean that it is the right way to do it. I'm new here, I'm learning and your feedback is much appreciate it. Please tell me what you think, what areas of improvement does it has, what am I doing wrong, etc. If you are interested in learning how I did it, leave me a comment and I promise I'll do a small tutorial.

Please share, re-steemit, you know what to do.

THANK YOU!

Al

P.S sorry for my broken English hahaha!