in

I made a crypto tracking spreadsheet with live crypto price updates, moon math, and a history of your Portfolio and trading performance. Updated Version (13) – now supports 1000 cryptocurrencies.

Edit: fixed a bug with the exchange rate. download again (same link) to fix

​

Hi everyone.

I have posted this previously – however there was a few issues which I have now fixed.

1. Changed to Coingecko api. This now supports the top 1000 cryptocurrencies.
2. Loads much faster.
3. Should work internationally . The last version had formatting issues which caused errors for some people depending on their region settings. This should now work without having to change your excel language settings. Its difficult for me to test this in all the countries so please let me know if you are getting equation errors related to the exchange rate conversions.

This is a spreadsheet that I have developed for myself gradually over a few years. I have found it very helpful for keeping track of my crypto holdings (good for tax purposes). No need to trust third party apps to keep your personal information – track it yourself.

There is a lot in here;

Automatically updates prices from coinmarketcap. The top 1000 coins included. Just select which ones you want to track by typing in the ticker symbol.

You can choose your local Fiat currency and get live conversion rates for any fiat currency.

​

https://preview.redd.it/4q0ud2tdcht61.png?width=1904&format=png&auto=webp&s=66c2ddb94458dd40b4a8c4faaedc3cdff58d8fae

I don’t record details of every trade. Just keep track of your crypto purchases (from fiat) and what coins you currently hold. The spreadsheet will calculate the rest and keep a record of how your portfolio and holdings have changed over time (it logs this data every time you save the sheet)

​

https://preview.redd.it/w2d6u10gcht61.png?width=1507&format=png&auto=webp&s=7238c8d7c64e68055a9878f522a9be246b48ca44

​

​

https://preview.redd.it/o8utfeqhcht61.png?width=602&format=png&auto=webp&s=9281d1c62972d691b1828bdc00abced272b4fa7d

I find this very handy to see if your trading is actually profitable compared to the HODL method.

​

​

https://preview.redd.it/eb3w4t9jcht61.png?width=929&format=png&auto=webp&s=99def90145a61e3ea19438e75737505d6f16c729

There are also plenty of ‘moon math’ and analytics to see how bitcoin is trending. This includes a full history of bitcoins price which updates every time you open the sheet.

​

https://preview.redd.it/kpcgd7ykcht61.png?width=1423&format=png&auto=webp&s=9031f21351feeecf638b260a52c04feb57d93d4f

A few more charts because I like charts;

​

https://preview.redd.it/6z5y6namcht61.png?width=1133&format=png&auto=webp&s=e8414053e1c36e8a6722dfcb6e62b58bc4958c80

Also has a simple ‘regret calculator’ to more than satisfy your regret quota for the day;

​

https://preview.redd.it/esdfokaocht61.png?width=351&format=png&auto=webp&s=944d2e278cd8818b95ab1662970fe0c6a8922f69

​

free download from here. Instructions inside. You will need macros enabled if you want it to do the fancy stuff.

[https://www.dropbox.com/scl/fi/66kw99690pjnankj7m3k0/Cryptoprices13-for-others.xlsm?dl=0&rlkey=a4foejlch6pzbmo43431bv6ud](https://www.dropbox.com/scl/fi/66kw99690pjnankj7m3k0/Cryptoprices13-for-others.xlsm?dl=0&rlkey=a4foejlch6pzbmo43431bv6ud)

Hope this is helpful to you in some way. Let me know if you have any issues – I will try and help if you catch me at a good time. This only works in Microsoft excel – it does not work in google sheets.



View Reddit by Fly115View Source

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

GIPHY App Key not set. Please check settings

38 Comments

  1. of course you should be careful downloading random files from random people on the internet. If you are concerned you can;

    run it through a virus scan (i.e [virustotal.com](https://virustotal.com/))

    check the external connections in excel – you can follow the links and see these are all just simple number/text data from sources such as coinmarketcap.

    you can also scroll through all the comments (reddit and dropbox comments) from past versions and you wont see anyone finding malware etc;

    [https://www.reddit.com/r/CryptoCurrency/comments/dc5322/i_made_a_cryptocurrency_tracking_spreadsheet/?utm_source=share&utm_medium=web2x&context=3](https://www.reddit.com/r/CryptoCurrency/comments/dc5322/i_made_a_cryptocurrency_tracking_spreadsheet/?utm_source=share&utm_medium=web2x&context=3)

    someone there posted the vba script in a pastebin if you want to check that out.

  2. The current state of this subreddit: this post with an awesome tool that really adds value and probably took a very long time to do has <200 upvotes. Meanwhile some random (probably made up) sob story how crypto changed someone’s life or the usual low effort doge shill / anti-shill post that regurgitates things everyone knows already has a couple thousands upvotes…

  3. Amazing work! If I may ask; is there a way to extend the top 1000 or a way to just pull specific coins? bit lost with the API and damn MAC version of excel is giving me some hard time checking the connection details 🙄 happy to drop you some moons for the nice work once I get some lol

  4. Wow.. I remember trying this awhile ago when you posted it, but it had some issues and I wasn’t sure what was going on. This new one worked instantly, and I’m only on my third time breaking it and reverting back to the original file!

    &#x200B;

    Thanks so much for putting this together and sharing it with us.

  5. This is impressive, and I’m sure you’ve put a lot of time and effort into it.

    But what are the benefits of using this versus a traditional portfolio tracker? The more in-depth stats and graphs/charts?

Loading…

0

What do you think?

How it started: // How it’s going:

VeChain VET VETUSDT

VeChain Mentioned in 2021 Forbes Blockchain 50, Parabolic Move In Sight?