HODL Back Tester Google Spreadsheet


#1

Inspired by an awesome Video and Research by @jamesbrooks and @mwlang ($204,279.83 in one year investing in the top 10 Cryptocurrencies!), I made a google spreadsheet for doing back testing on your own.

NOTE: The sheet is view only. To edit, make a copy.

Click ‘File’ menu, then click ‘make a copy’
image


(Note: not compatible with Desktop Excel since I use some non-traditional formulas)

You can change these variables on the tab called “BackTest”:

  • $USD Amount to invest (Either one time or weekly)
  • Top N coins (i,.e. 10 vs 8 vs 20)
  • Starting week & Ending week (for 1-time investment, make the weeks the same)

with those variables, you can simulate:

  • a 1 time investment (i.e. $10,000 first week of Jan 1 into top 8 or 10 coins)
  • a weekly investment (i.e. $20 per coin into top 10 coins to invest $10,400/year)
  • an investment last month, last week, etc

Also has Chart to show portfolio value

**

Going for a one-time investment or a weekly investment?

**
The sheet will help precalculate the number of shares to buy to stay on track with your investment amount

Here are a few things you can try:

One-Time Investment @ $10,000
Top 20, Invest $500, Start Week 1/1/2017, End Week 1/1/2017
Top 10, Invest $1000, Start Week 1/1/2017, End Week 1/1/2017
Top 8, Invest $1250, Start Week 1/1/2017, End Week 1/1/2017
Top 8, Invest $1250, Start Week 7/31/2017, End Week 7/31/2017

Dollar Cost Average Investing @ $10,400/year
Top 20, Invest $100, Start Week 1/1/2017, End Week 8/27/2017
Top 10, Invest $100, Start Week 1/1/2017, End Week 8/27/2017
Top 8, Invest $100, Start Week 1/1/2017, End Week 8/27/2017

The goal here is to see that you are not missing out, and you should start Investing and HODL (My opinion, not advice!)

If you see any mistakes, or improvements, let me know!

NOTE: The sheet is view only. To edit, make a copy.
Click ‘File’ menu, then click ‘make a copy’

2017-09-24: Added an indicator to tell you if your copy is older than the latest changes (in event of formula changes)
-Has a change log at bottom of HOW TO USE tab now for any ongoing changes.
image

Sneak preview at an upcoming Back tester:
It’s pretty bare right now, but more to come!
https://public.tableau.com/profile/brad.durbin2173#!/vizhome/ThebitCoin_pub-HODLBacktester/BackTest?publish=yes


$204,279.83 in one year investing in the top 10 Cryptocurrencies!
$204,279.83 in one year investing in the top 10 Cryptocurrencies!
Anyone know of a website, excel sheet, etc, where we can see how to best profit from trading through multiple coins?
Dollar Value Averaging
[WIP] - EPIC Bitcoin Resource List! :rocket: :bomb: :fire:
PUB 101 - New User Kickstarter!
First LTC/BTC Atomic Swap/Implications
Ready to invest weekly -- Buy with USD or BTC? + More questions
Rebalancing vs Buying in Top 10: $1,043,902 Profits!
Help a newb! Buy BTC/ ETH right now or no?
Really stupid question. XRP: $USD vs BTC profit
$204,279.83 in one year investing in the top 10 Cryptocurrencies!
I'm gonna drop 15K USD, what to put it on?
Student without much $$$
August 30, 2017 - ROLL CALL! - The Maths Destroys the Fud
Going All In $10,000
My Battle Plan for a hopeful 600% Gain
First investment?
$1000 to invest
Great Links NEEDED!
As a week old newbie
Why? am I doing something wrong?
My ticket to the moon!
Getting Started @ The Pub :beers:
#2

This is really cool. Thanks for putting in the hard work making this spreadsheet brother. Helps strengthen my resolve in HODLing. Keep up the good work. Glad you are here!


#3

amazing work! super interesting to see how this pans out. I’ve got a large lump sum going into GDAX right now. Once that clears I will most definitely be putting this trade through the test and keeping a log to compare for 2018!


#4

This is dope…thanks for putting in the work and sharing


#5

Stay tuned… Now that I know pubbers like it, I’ve started to take this sheet three steps further and make it do cross analysis of several scenarios and chart them, weighted investing, and week by week profit analysis.

Since history repeats itself, this should be good enough to generate data to support our strategies!

My wife loves it and asked why I didn’t invest $10k a year ago… Showing friends this know is easy to get them on board


#6

Wow, this is absolutely fantastic. My bf was just asking me how on earth we’d be able to track everything.
You just won yourself :+1::+1::+1::+1::+1: :nerd_face:


#7

Gawd. Did it really take me this long to get to this???

Thank you sir. I’ll be doing a video on this tomorrow.


#8

you are forgiven @peter. Working on a new version that does some wild analytical stuff…maybe HODL out for a day?


#9

Will do. Please inform me when it’s "production ready."
As you may know when I build stuff… heh. I test in production, and I do UAT live!!! :sweat_smile::man_facepalming:t2:


#10

Roger that. Ditto That! :wink:


#11

As a developer of webapps… this could be quite a fun side project…


#12

You are the man ! @cryptoBrad - Thanks for putting in the effort.

I have been actually running a similar side project just for testing.

Put in 10$ in TOP 100 , Problem is - I choose the wrong time to get in, I did it when the market was at a high, especially the ALTs. Although I am past the break even point - If I had done this experiment during the July/Aug Crash - I would be up atleast 100-300% on the investment.

Will keep you guys updated :slight_smile:


#13

@nitroxokill Thanks! And it’s never too late to get it…you just have to HODL longer…the data supports that.

I hope we can show family/friends/strangers that “it’s never too late!”


#14

Nice work cyryptoBrad–Thank you


#15

I believe cell B4 is wrongly calculating profit/loss it should read =(A4/C4)-1 :slight_smile:

But great work!


#16

Thanks, I’ll update it… Sometimes I move to fast… Need spot checkers…


pinned #17

#18

Tweeted. Too good to not share.


#19

Great stuff here. What an amazing community we have here. Let me know if you need someone to QA this as that’s my day job for a software company in SW Florida


#20

I am planning to invest in top 10 in one go instead of investing every week.
Are there any downsides to this?