Community post
crypto currency excel calculator backtesting
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’
https://thebitcoinpub-91d3.kxcdn.com/uploads/default/original/2X/0/008f2d4a0aa7c2130dc965a972638d0f4708324c.png
EXCEL HOLDING TESTER
(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. 10,400/year)
- an investment last month, last week, etc
Also has Chart to show portfolio value
https://thebitcoinpub-91d3.kxcdn.com/uploads/default/original/2X/4/48986feb7de09cd7bd266d9bd1a47e417b256d90.png
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
https://thebitcoinpub-91d3.kxcdn.com/uploads/default/original/2X/a/a621dc2ee943784476f9ae25f10e0885044281e0.png
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
This sheet is about the idea of investing and holding afterwards
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’
Have fun with it!
Replies (0)
Conversation
No replies yet
Replies will appear here as people join the conversation.