HODL Back Tester Google Spreadsheet


#21

According to the back tester, it shows that being very profitable.
HODL is the key in both 1-time and recurring investments

Not a downside, but a counterpoint is that you don’t acquire any new coins as they come out…


#22

yo the man ! thanks man!


#23

Hey dude, so there are 7 coins i want to invest in roughly $20 each per week

When i changed the cell 1B to 7, some of the coins values became 0? could you help?

Thanks


#24

@Rickyzan you have to remember, if you invest over time…the TOP N Coins will change over time…so you will have zeros in some places…thats totally OKAY


#25

Thanks Dude!

Appreciate it


#26

Loving this sheet dude!!! however american date formatting is doing my head in…


#27

@firefight great feedback…Let me change that…watch it live…

…changed…better?


#28

very much!! was seriously struggling with it lol


#29

“We develop in production”…keep the suggestions coming!


#30

Sheet isn’t updating for Safe Exchange Coin (SAFEX) any ideas?


#31

The PUB/Nation is super Thankful!


#32

@Firefight interesting…it;s not on the list here: https://coinmarketcap.com/ as of this post
(I see Bittrex says WALLET MAINTENANCE…maybe part of the problem?? )

image

It’s live pricing, so when it comes back to life, it will resume recalculating.


#33

It is on the list number 131. Does it only take the first page of coins?


#34

Yes, I see it at #131 today.
It grabs Top 100… I can adjust that in the next version to get like top 200 maybe 300…but formula will not grab all…
image


#35

can this be a parameter into the api call? Enter a figure into a cell which is used for the web request?

edit: I think I see what you are doing, the API is a GetAll and you are just filtering it…maybe the filter can be paramatised .


#36

I think I’ve got it figured out in the new version…I have 200 pulling in…working on getting published today


#37

Brad, great work! Appreciate you brother


#38

Never mind the sistine chapel, this is the masterpiece.
If one would have invested a 1 time 10 000 USD on the 1st of January into 10 coins (1000 USD per coin), it would have generated in 8 months 174 000 USD, insanity.


#39

That would be super cool!


#40

Cool as. It’s great to be part of a community that can rally the brainpower to the benefit of all. Big thumbs up guys and girls