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.
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)
I discover this very helpful to see if your trading is definitely worthwhile in comparison with the HODL technique.
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.
This model has some bug fixes and a few new options together with a ‘Stock to movement’ price prediction mannequin;
free obtain from right here. Instructions inside. You will want macros enabled if you would like it to do the flamboyant stuff.
Let me know when you have any points.