A made a Cryptocurrency tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (fixed). : CryptoCurrency


I have posted this previously however since then coinmarketcap have changed their api. This version has a workaround for that – with the downside that it takes much longer to fetch price data. You will need to be patient when opening the file and when you press the price refresh button.

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

There is a lot in here including;

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

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

https://preview.redd.it/zmt33x8q6yo41.png?width=1536&format=png&auto=webp&s=734fc117610d6eaa3bcc10670241fbf436e902b1

You don’t need to 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/ha3gel8r6yo41.png?width=1380&format=png&auto=webp&s=7bdbd351b866ff70f160810f2515a32953a5249b

https://preview.redd.it/mzkt96js6yo41.png?width=602&format=png&auto=webp&s=45fefffe6f92f2ad4fefac67320ffe3454a7155b

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

https://preview.redd.it/ggg2utxu6yo41.png?width=929&format=png&auto=webp&s=010ab01b6424d525b1913a3d27acdd499cda25b8

Oh yes and there are 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/upyy3qzv6yo41.png?width=1455&format=png&auto=webp&s=29db32fa7e6ce9156d27cea99afa35ab6fec2950

This version has some bug fixes and a few new features including a ‘Stock to flow’ price prediction model;

https://preview.redd.it/3vx5tq3x6yo41.png?width=767&format=png&auto=webp&s=e5d43c1394e979ff9069b9f9dbb40038bdee514a

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

https://www.dropbox.com/s/yjba4y6qdsye2qo/Cryptoprices11%20-%20for%20others.xlsm?dl=0

Let me know if you have any issues.



Source link

قالب وردپرس

Leave a Reply

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