I made a complete crypto portfolio tracking spreadsheet (excel) with live price updates and a full history of your Portfolio and trading performance

in #cryptocurrency6 years ago (edited)

This is a spreadsheet that I have developed for myself over the last year or so. I have found it very helpful for keeping track of my crypto holdings (great for tax purposes) and how well my trading decisions have been (not great). I figure it's time to share.

There is a lot in here including;

Automatically updates crypto prices from coinmarketcap. Nearly 2000 coins. Just select which ones you want to track by typing in the name.

You can even choose your local Fiat currency and get live conversion rates for any country.

No need to record details of every trade. Just keep track of your crypto purhcases (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.

This data gets saved every time you save the spreadsheet.

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

Oh yes and there are plenty of 'moon math' and analytics to see how bitcoin is trending and how far off you are from a lambo. This includes a full history of bitcoins price which updates every time you open the sheet.

Plenty more bits and pieces that I have tinkered with over time.

free download from here. Instructions inside. You probably need a fairly recent version of microsft excel with macros enabled (if you want it to do the fancy stuff).

https://www.dropbox.com/s/2n8xpn9r8oyetli/Cryptoprices9%20-%20For%20others.xlsm?dl=0

Let me know if you have any issues.

Sort:  

You have a minor misspelling in the following sentence:

Plenty more bits and peices that I have tinkered with over time.
It should be pieces instead of peices.

Dude this is awesome! Share it on reddit if you haven't. I bet lots of those people would love it.

Thanks. I shared on r/cryptocurrency yesterday but it didn't get much attention. I guess its probbably not good timing as everyone is obsessed with the price.

Ah shucks. Happens sometimes. But yesterday was kind of crazy, so yeah, probably poor timing. Still this is awesome. :)

Congratulations @bengineering! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

Award for the number of comments received

Click on the badge to view your Board of Honor.
If you no longer want to receive notifications, reply to this comment with the word STOP

To support your work, I also upvoted your post!

Do not miss the last post from @steemitboard:

SteemFest³ - SteemitBoard support the Travel Reimbursement Fund.

Support SteemitBoard's project! Vote for its witness and get one more award!

This is ok but I think the real question is will dogecoin explode!!

the dropbox link doesn't work