03-09-2021, 08:32 AM
A made a crypto tracking spreadsheet with live crypto price updates, moon math, and
<table> <tr><td> <a href="https://www.reddit.com/r/CryptoCurrency/comments/m0ve30/a_made_a_crypto_tracking_spreadsheet_with_live/"> <img src="https://b.thumbs.redditmedia.com/cbKNfl8c4pmePeDSqknD7VYppuTj5tus09RRv44UQdI.jpg" alt="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)" title="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> </td><td> <!-- SC_OFF --><div class="md"><p>Hi everyone.</p> <p>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.</p> <p>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.</p> <p>There is a lot in here;</p> <p>Automatically updates prices from coinmarketcap. The top 200 coins included. Just select which ones you want to track by typing in the ticker symbol. </p> <p>You can choose your local Fiat currency and get live conversion rates for any fiat currency.</p> <p>​</p> <p><a href="https://preview.redd.it/6x7g64xgiwl61.png?width=1904&format=png&auto=webp&s=8e0ec602a1ffe55e75a204213a33a4ba6dec2f71">https://preview.redd.it/6x7g64xgiwl61.png?width=1904&format=png&auto=webp&s=8e0ec602a1ffe55e75a204213a33a4ba6dec2f71</a></p> <p>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)</p> <p>​</p> <p><a href="https://preview.redd.it/zbgx7yqniwl61.png?width=1507&format=png&auto=webp&s=1667c9d459389cd4c2d807c633905952e536df62">https://preview.redd.it/zbgx7yqniwl61.png?width=1507&format=png&auto=webp&s=1667c9d459389cd4c2d807c633905952e536df62</a></p> <p>​</p> <p><a href="https://preview.redd.it/y96e2d3tgwl61.png?width=602&format=png&auto=webp&s=ade93b04c0602b698a6d24c7a6804ef9e5aae838">https://preview.redd.it/y96e2d3tgwl61.png?width=602&format=png&auto=webp&s=ade93b04c0602b698a6d24c7a6804ef9e5aae838</a></p> <p>I find this very handy to see if your trading is actually profitable compared to the HODL method.</p> <p>​</p> <p><a href="https://preview.redd.it/yapih66vgwl61.png?width=929&format=png&auto=webp&s=10d155483e98e575f00816048968fb4196a07b57">https://preview.redd.it/yapih66vgwl61.png?width=929&format=png&auto=webp&s=10d155483e98e575f00816048968fb4196a07b57</a></p> <p>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.</p> <p>​</p> <p><a href="https://preview.redd.it/ds7jh33uiwl61.png?width=1423&format=png&auto=webp&s=2110e1d6fac3a114d728125a1684413a687b1a26">https://preview.redd.it/ds7jh33uiwl61.png?width=1423&format=png&auto=webp&s=2110e1d6fac3a114d728125a1684413a687b1a26</a></p> <p>A few more charts because I like charts;</p> <p><a href="https://preview.redd.it/kwi87fe6jwl61.png?width=1133&format=png&auto=webp&s=c3d0897814d06d09f771bc6e42330f31065cb737">https://preview.redd.it/kwi87fe6jwl61.png?width=1133&format=png&auto=webp&s=c3d0897814d06d09f771bc6e42330f31065cb737</a></p> <p>Also has a simple 'regret calculator' to more than satisfy your regret quota for the day;</p> <p><a href="https://preview.redd.it/y6sgj9gvjwl61.png?width=351&format=png&auto=webp&s=20944d8459cd84bbbcf567ee7cfa8befbaba5413">https://preview.redd.it/y6sgj9gvjwl61.png?width=351&format=png&auto=webp&s=20944d8459cd84bbbcf567ee7cfa8befbaba5413</a></p> <p>free download from here. Instructions inside. You will need macros enabled if you want it to do the fancy stuff.</p> <p><a href="https://www.dropbox.com/scl/fi/khe16iesb137pxo19mxp7/Cryptoprices12-for-others.xlsm?dl=0&rlkey=aavvzcpu9vqb1porgm9jsw9cf">https://www.dropbox.com/scl/fi/khe16iesb137pxo19mxp7/Cryptoprices12-for-others.xlsm?dl=0&rlkey=aavvzcpu9vqb1porgm9jsw9cf</a></p> <p>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.</p> </div><!-- SC_ON --> submitted by <a href="https://www.reddit.com/user/Fly115"> /u/Fly115 </a> <br/> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/m0ve30/a_made_a_crypto_tracking_spreadsheet_with_live/">[link]</a></span> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/m0ve30/a_made_a_crypto_tracking_spreadsheet_with_live/">[comments]</a></span> </td></tr></table>Kind Regards R
<table> <tr><td> <a href="https://www.reddit.com/r/CryptoCurrency/comments/m0ve30/a_made_a_crypto_tracking_spreadsheet_with_live/"> <img src="https://b.thumbs.redditmedia.com/cbKNfl8c4pmePeDSqknD7VYppuTj5tus09RRv44UQdI.jpg" alt="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)" title="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> </td><td> <!-- SC_OFF --><div class="md"><p>Hi everyone.</p> <p>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.</p> <p>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.</p> <p>There is a lot in here;</p> <p>Automatically updates prices from coinmarketcap. The top 200 coins included. Just select which ones you want to track by typing in the ticker symbol. </p> <p>You can choose your local Fiat currency and get live conversion rates for any fiat currency.</p> <p>​</p> <p><a href="https://preview.redd.it/6x7g64xgiwl61.png?width=1904&format=png&auto=webp&s=8e0ec602a1ffe55e75a204213a33a4ba6dec2f71">https://preview.redd.it/6x7g64xgiwl61.png?width=1904&format=png&auto=webp&s=8e0ec602a1ffe55e75a204213a33a4ba6dec2f71</a></p> <p>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)</p> <p>​</p> <p><a href="https://preview.redd.it/zbgx7yqniwl61.png?width=1507&format=png&auto=webp&s=1667c9d459389cd4c2d807c633905952e536df62">https://preview.redd.it/zbgx7yqniwl61.png?width=1507&format=png&auto=webp&s=1667c9d459389cd4c2d807c633905952e536df62</a></p> <p>​</p> <p><a href="https://preview.redd.it/y96e2d3tgwl61.png?width=602&format=png&auto=webp&s=ade93b04c0602b698a6d24c7a6804ef9e5aae838">https://preview.redd.it/y96e2d3tgwl61.png?width=602&format=png&auto=webp&s=ade93b04c0602b698a6d24c7a6804ef9e5aae838</a></p> <p>I find this very handy to see if your trading is actually profitable compared to the HODL method.</p> <p>​</p> <p><a href="https://preview.redd.it/yapih66vgwl61.png?width=929&format=png&auto=webp&s=10d155483e98e575f00816048968fb4196a07b57">https://preview.redd.it/yapih66vgwl61.png?width=929&format=png&auto=webp&s=10d155483e98e575f00816048968fb4196a07b57</a></p> <p>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.</p> <p>​</p> <p><a href="https://preview.redd.it/ds7jh33uiwl61.png?width=1423&format=png&auto=webp&s=2110e1d6fac3a114d728125a1684413a687b1a26">https://preview.redd.it/ds7jh33uiwl61.png?width=1423&format=png&auto=webp&s=2110e1d6fac3a114d728125a1684413a687b1a26</a></p> <p>A few more charts because I like charts;</p> <p><a href="https://preview.redd.it/kwi87fe6jwl61.png?width=1133&format=png&auto=webp&s=c3d0897814d06d09f771bc6e42330f31065cb737">https://preview.redd.it/kwi87fe6jwl61.png?width=1133&format=png&auto=webp&s=c3d0897814d06d09f771bc6e42330f31065cb737</a></p> <p>Also has a simple 'regret calculator' to more than satisfy your regret quota for the day;</p> <p><a href="https://preview.redd.it/y6sgj9gvjwl61.png?width=351&format=png&auto=webp&s=20944d8459cd84bbbcf567ee7cfa8befbaba5413">https://preview.redd.it/y6sgj9gvjwl61.png?width=351&format=png&auto=webp&s=20944d8459cd84bbbcf567ee7cfa8befbaba5413</a></p> <p>free download from here. Instructions inside. You will need macros enabled if you want it to do the fancy stuff.</p> <p><a href="https://www.dropbox.com/scl/fi/khe16iesb137pxo19mxp7/Cryptoprices12-for-others.xlsm?dl=0&rlkey=aavvzcpu9vqb1porgm9jsw9cf">https://www.dropbox.com/scl/fi/khe16iesb137pxo19mxp7/Cryptoprices12-for-others.xlsm?dl=0&rlkey=aavvzcpu9vqb1porgm9jsw9cf</a></p> <p>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.</p> </div><!-- SC_ON --> submitted by <a href="https://www.reddit.com/user/Fly115"> /u/Fly115 </a> <br/> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/m0ve30/a_made_a_crypto_tracking_spreadsheet_with_live/">[link]</a></span> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/m0ve30/a_made_a_crypto_tracking_spreadsheet_with_live/">[comments]</a></span> </td></tr></table>Kind Regards R