Due to a high number of requests, I’ve updated my crypto tracking spreadsheet to now support the top 5000 crypto (moons included). This spreadsheet tracks your crypto and keeps a record of your gains, losses and historical positions. Cryptoprices version 14
I previously posted a download link to my excel spreadsheet that I made for tracking my crypto portfolio. It supported the top 1000 coins. However I had many people message me asking how they could add support for more coins. I guess you guys really like your shitcoins and small caps.
So I decided to update it with 5000 of the top coins from coingecko and post it again for anyone who is interested. Yes it even supports live prices for r/cryptocurrency moons.
The main reason that I didn't have all these coins previously is because it really slows down the refresh time while its importing all the new data. To deal with this I made it adjustable so that you can choose how many coins to import (0-5000). If you only want live prices for the top 100 then set this cell to 100, if you want more then you can have more, you will just have to wait a few more seconds each time you press refresh.
There is a handful of other minor changes and bug fixes.
The spreadsheet now also measure your trading gain/loss in BTC not just fiat. So you can see how well your alts are doing versus just holding BTC.
The spreadsheet now logs the amount of coins you held over time, not just the fiat value of those coins. This should help a tax time if you are diligent at saving the spreadsheet after each trade (just update the portfolio tab with your new coins and save the spreadsheet).
It also lets you input fiat purchases of any crypto now (no longer limited to 3).
some screenshots;
Still has moon maths, regret calculator and lots of charts
Download link
https://www.mediafire.com/file/wc24a9bgxiaxhep/Cryptoprices14-_for_others.xlsm/file
previous version for reference and so you can see i'm not trying to scam or give you malware. Of course you shouldn't trust me and should scan the file for malware anyway (i.e virustotal.com). It does contain external connections and macros which are required for fetching crypto prices and exchange rates from coingecko.com
submitted by /u/Fly115
[link] [comments]