Sharing my Crypto Portfolio Manager! Revision 1.0

in #cryptocurreny7 years ago (edited)

800x445xcrypto-coins.jpg.pagespeed.ic.n4xwRMEUvR.jpg

Dear Investors and fellow traders,

When remembering correctly, I was looking for ways to properly manage my investments when I started accumulating coins a while back. At that time, I was actively searching for tools that would help me achieve my goals but couldn't find many spreadsheets that really helped me out or had all of the elements that I was looking for.

Most people either wanted to sell their work or didn't put in too much effort so I decided that I'd make one for myself. I love to work in Excel so I gave Google Sheets a try since this was the only way in which I could get live data from CoinMarketCap implemented in a sheet (this is a terrible job in Excel). This will be the first revision of my sheet that I share and I hope that we can improve it as a community with the help of everyone who feels an urge to chip in.

Sharing is Caring

My goal here today is to share my spreadsheet that I use to track the progress of my investments per coin for free. To help others, with less knowledge get started and to improve my own skillsets as I will be phishing for valuable insight and feedback online in terms of improvements. Ultimately, creating a small community (telegram) that could work together to create an awesome custom portfolio manager. Sort of an open source development program, one might say.

Why Excel or Google Sheets over Blockfolio?

You might wonder why I don't just use Blockfolio on IOS? I like to keep my trading data offline (in Excel sheets) but I've put my Blockfolio application on "Watch only" to track all coins that currently have my interest.

Some points that would point out the main differences in the following table:

BlockfolioGoogle Sheets/Excel
AddictiveCreative
Mobile AppLaptop, Desktop, Mobile
No customisationFully customisable
Bugs on occasionWorks perfectly all the time
All trading data onlineKeep trading data offline
Etc.Etc.

Now, with this tool, you can track all your coins and their current prices. The manager then compares this to the total amount (USD or EUR) that you invested in a particular coin to quickly assess the status (current ROI) of your investment, per coin. There's only a few variables that you need to link from other Google Sheets (example included) or import from Excel.

I've included some information regarding operation of the manager in the sheet itself for the total noobs amongst us, though it should be pretty straightforward.

The link to the sheet can be found here:
Google Sheets Portfolio Manager

Please join my Telegram Group to provide feedback or get back to me if you made a donation to the cause! I'd also like to hear if you made improvements or additions to my sheet:
Telegram Group

In the following link you'll find some useful information and help topics as to how get started with the add-on if you want to make your own spreadsheet or update mine:
=CRYPTOFINANCE Fuction Help

If you feel like donating a few coins that would be very much appreciated but not required. It's my pleasure sharing it and since we are all in this revolution together, the more people benefit, the faster blockchain technology will be adopted.

  • BTC - 1FER7Ztb6JZoEnomLvacnqkfD1LHzMyi2G
  • ETH - 0xF8D519c05E11eFa9875Be9eF5DE4AB941de23350
  • LTC - LTZUPgw7wnKXUr5oPTrL6V8YsHkYo1Z2JR

PS At point of writing, my editing is crappy and I'm dead tired since I'm currently abroad on an internship, working 13 hours a day and struggling to find time to work on crypto. I will update this sheet regularly to provide newer revisions of the sheet and, if applicable, will provide newer posts with updated information!

Stay safe and do not hesitate to reach out or leave a comment!

Love