A made a crypto tracking spreadsheet with live crypto price updates, moon math, and a history of your Portfolio and trading performance. Updated Version (12)

Cryptocurrency News and Public Mining Pools

A made a crypto tracking spreadsheet with live crypto price updates, moon math, and a history of your Portfolio and trading performance. Updated Version (12)

A made a crypto tracking spreadsheet with live crypto price updates, moon math, and a history of your Portfolio and trading performance. Updated Version (12)

Hi everyone.

I have posted this previously however I have since fixed a few things which were causing issues for some people. As requested this is an updated version.

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 200 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/6x7g64xgiwl61.png?width=1904&format=png&auto=webp&s=8e0ec602a1ffe55e75a204213a33a4ba6dec2f71

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/zbgx7yqniwl61.png?width=1507&format=png&auto=webp&s=1667c9d459389cd4c2d807c633905952e536df62

https://preview.redd.it/y96e2d3tgwl61.png?width=602&format=png&auto=webp&s=ade93b04c0602b698a6d24c7a6804ef9e5aae838

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

https://preview.redd.it/yapih66vgwl61.png?width=929&format=png&auto=webp&s=10d155483e98e575f00816048968fb4196a07b57

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/ds7jh33uiwl61.png?width=1423&format=png&auto=webp&s=2110e1d6fac3a114d728125a1684413a687b1a26

A few more charts because I like charts;

https://preview.redd.it/kwi87fe6jwl61.png?width=1133&format=png&auto=webp&s=c3d0897814d06d09f771bc6e42330f31065cb737

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

https://preview.redd.it/y6sgj9gvjwl61.png?width=351&format=png&auto=webp&s=20944d8459cd84bbbcf567ee7cfa8befbaba5413

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/khe16iesb137pxo19mxp7/Cryptoprices12-for-others.xlsm?dl=0&rlkey=aavvzcpu9vqb1porgm9jsw9cf

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.

submitted by /u/Fly115
[link] [comments]