Hey everyone !
I haven't been in this (facinating) crypto world for long, but already I found myself needing to have a consolidated view of my coins and growth.
I came up with the following Google Sheets template I'm sharing with you today :
https://docs.google.com/spreadsheets/d/1kKBjsCkBUFIjvYaLy2fXu1wy04K5rJs_zYZ2UQbo8lo/edit?usp=sharing
Overview
I wanted simplicity first and foremost. Adding a newly bought coin takes seconds :
The sheet has multiple tabs :
- Overview : See your coins repartition + Overall portfolio growth
- Trades : Set your recents coins boughts here
- ICOs : Set your tokens bought during ICOs
- Mining : Add your current mined currencies
And a hidden Data tab where are stored the computed values for the graphs in Overview
My overview tab is less desirable than the gif I posted above 馃槄
I had 30% growth last week. Latest rumors keep dumping prices 馃槀
But it's ok, I'm a newbie here. I'm enjoying the journey ;)
Use it
As for all Google Sheets templates, if you want to use it, go into "File" > "Make a copy...", as shown in the screenshot below :
By default, I'm using cryptoCompare to fetch the prices, and ask for "EUR".
Check the next section "Advanced usage" if you need to use something else !
Advanced usage
Available macros
CryptoCompare
=cryptocompare(B3, "USD")
The second parameter is optional and will resolve to EUR if not specified
TokenFund
=tokenFund()
The Token Fund not being listed on cryptoCompare, I had to do another macro just for it...
USD by default, If you need something else, you can edit the macro to fetch a USD to X and return the correct price 馃槈
Also, I put it under the ICO tab because I did not know where to put it ^^
sortAndCumul
=sortAndCumul(dates, values, arrayIndex)
=sortAndCumul(B3:B28,D3:D28, 0)
This one was made last night cause I didn't know how to do the performance graph.
Now that I think about the current graph doesn't make much sense 馃 I think I'll change it to something else soon-ish...
How to change macros
Simply go into "Tools" > "Script editor"
Which will bring you here :
It's Javascript for those who are accustomed to it.
However the debugging is painful and behavior not always what you'd expect 馃槗
Contribute
For those that would like to contribute to it, send me the emails I should add edition rights to in the comments !
Or if you know a better contribution model with Google Sheets, I'm all for that 馃槈
Thanks for those who made it this far.
Took me some time to get a hang of Google Sheets intricacies.
Hope you'll like it.
As usual, spread the love for crypto and Steemit !!
馃馃憣馃徏馃帀