So it’s mostly just a visual update, there are a few features I added and changed for example, the current price of ICON auto updates from coinmarketcap.com this can be edited to be changed to any other coin by changing the url which is the cell marked with “[”.
The url for ICON is currently “https://api.coinmarketcap.com/v1/ticker/icon/” changing the end /ticker/icon/ to /ticker/“insertcoin”/ will then auto update to that coin. Though, this system can sometimes go down for a few minutes so you can always just manually insert the price of the preferred coin and have indicated where to do so.
To use the Sheet as is all you need to do is edit anything that is white. which is only a few things such as Weekly investment flat rate in case your investing more or less than the initial $100 I’ve entered.
Also you may need to change the Initial starting date (which will automatically change all other dates to be exactly one week from that day) to whichever day you intend to invest on, which if I remember would be the first Friday of the year. Mine is currently the 01-06-2018 as I live in Australia.
(Note: As I write this I just realized the fact that in the United States at least Months are written before the days and have updated that detail.)
This might be pointless but I was going to do for myself regardless and figured I’d share, I tend to enjoy fixing up all my excel sheets, maybe I have a few useful ones of my own ill add to the pub someday.
Note: To edit and save your own goto: File>Make a Copy… and you will have full permissions over the copy.
Thank you and enjoy