Home / Blog / 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

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

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

I’ve posted this beforehand nevertheless since then coinmarketcap have modified their api. This model has a workaround for that – with the draw back that it takes for much longer to fetch price information. You will have to be affected person when opening the file and if you press the price refresh button.

This is a spreadsheet that I’ve developed for myself progressively over the past couple years. I’ve discovered it very useful for maintaining monitor of my bitcoin holdings (nice for tax functions). No have to belief third occasion apps to maintain your private data – monitor it your self.

There is a lot in right here together with;

Automatically updates costs from coinmarketcap. The high 200 cash included. Just choose which of them you wish to monitor by typing within the title.

You may even select your native Fiat forex and get live conversion charges for any nation.

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

You need not file particulars of each commerce. Just preserve monitor of your crypto purchases (from fiat) and what cash you at present maintain. The spreadsheet will calculate the remaining and preserve a file of how your portfolio and holdings have modified over time (it logs this information each 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 discover this very helpful to see if your trading is definitely worthwhile in comparison with the HODL technique.

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

Oh sure and there are loads of ‘moon math’ and analytics to see how bitcoin is trending. This consists of a full history of bitcoins price which updates each time you open the sheet.

https://preview.redd.it/upyy3qzv6yo41.png?width=1455&format=png&auto=webp&s=29db32fa7e6ce9156d27cea99afa35ab6fec2950

This model has some bug fixes and a few new options together with a ‘Stock to movement’ price prediction mannequin;

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

free obtain from right here. Instructions inside. You will want macros enabled if you would like it to do the flamboyant stuff.

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

Let me know when you have any points.

About Agent

Check Also

What’s the best Exchange for Crypto Futures Trading? : CryptoCurrency

What’s the best Exchange for Crypto Futures Trading? : CryptoCurrency

What’s the best Exchange for Crypto Futures Trading? : CryptoForex I am at present utilizing …

Leave a Reply

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