I made a crypto tracking spreadsheet with live crypto price updates, moon math, and a history of your Portfolio and trading performance. Updated Version (13) - now supports 1000 cryptocurrencies. - Latest Hindi News , International , Bussiness , Sports ,Tech Info

Latest Hindi News , International , Bussiness , Sports ,Tech Info

Latest Hindi News , International , Bussiness , Sports ,Tech Info

Latest

Home Top Ad

Post Top Ad

Friday, April 16, 2021

I made a crypto tracking spreadsheet with live crypto price updates, moon math, and a history of your Portfolio and trading performance. Updated Version (13) - now supports 1000 cryptocurrencies.

/u/Fly115Cryptocurrency News & Discussion https://ift.tt/3tu1fKA
I made a crypto tracking spreadsheet with live crypto price updates, moon math, and a history of your Portfolio and trading performance. Updated Version (13) - now supports 1000 cryptocurrencies.

Hi everyone.

I have posted this previously - however there was a few issues which I have now fixed.

  1. Changed to Coingecko api. This now supports the top 1000 cryptocurrencies.
  2. Loads much faster.
  3. Should work internationally . The last version had formatting issues which caused errors for some people depending on their region settings. This should now work without having to change your excel language settings. Its difficult for me to test this in all the countries so please let me know if you are getting equation errors related to the exchange rate conversions.

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 1000 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/3o2po9zwfgt61.png?width=1904&format=png&auto=webp&s=b8067bfed48db9d898d3b9cb6632e38a3dfe3127

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/fe44akiyfgt61.png?width=1507&format=png&auto=webp&s=0c2a56c698e6af265c272aebad34341e91ef2f07

https://preview.redd.it/3lmzflq0ggt61.png?width=602&format=png&auto=webp&s=61e49c24e46624ef7e50d89b04c37ee4f4184d51

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

https://preview.redd.it/hbixiyw1ggt61.png?width=929&format=png&auto=webp&s=ff88a3ccb613cb92358c8b25bd22ddabfe934d55

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

A few more charts because I like charts;

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

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

https://preview.redd.it/uldmgpg6ggt61.png?width=351&format=png&auto=webp&s=2b419f757a116680bb5d8316cf5e2a0c2106fc08

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/66kw99690pjnankj7m3k0/Cryptoprices13-for-others.xlsm?dl=0&rlkey=a4foejlch6pzbmo43431bv6ud

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]


from Cryptocurrency News & Discussion https://ift.tt/32kwdso
via

No comments:

Post a Comment

Post Bottom Ad

Pages