Project: Crypto Investing Profit Simulation from Historical Data (4)

in #cryptocurrency3 years ago

To get more insights from coinmarketcap.com's historical snapshots, I'm doing more simulations and having a closer look at the data.

I've simulated investing equally in top 10 crypto assets for 1, 4, 13, 26, 52 weeks. Instead of just getting the average of the profit, I wanted to see it's distribution. The distribution is not what I expected. It really depends on when you invest.

Below graph shows profit for 1 week investment depending when you invested. Average profit is 3.37% which is good. But probability of you getting plus profit is 53.8%. Probability of getting plus profit can be calculated by counting percent of points where it's above zero (0%).

1week.png

Investing for 4 weeks does increase average profit to 19.65%, but probability of you getting plus profit is 49.81%. You are more likely to loose. When you invest for 3 months, average profit increases to 93.22% and probability of plus profit increases to 59.27%.

1m,3m.png

Investing for 6 months, average profit increases to 224.91%, probability of plus profit is 60%. Investing for a full year, average profit is 718.46% and probability of plus profit is 68.42%.

6m,12m.png

Here is a summary table of the average profit and probability of plus profit. Yearly profit is calculated using profit and invested weeks.
Screen Shot 2018-04-27 at 2.02.00 PM.png

I've invested in cryptocurrencies for almost a year now. Seeing only the average profit made me believe that it was really easy to get profits. And I wasn't doing a good job. But probability of plus profit was what I missed. I think I'm doing ok now.

Here is my analysis of the simulation results:

  1. Profit really depends on when you invest.
  2. Long term investing is much better. More profits and higher probability of gain.
  3. If you can't predict the market, you should invest using dollar cost averaging. This makes your investment at least close to average.

Below Google sheet contains the data results for all simulations and graphs:

https://docs.google.com/spreadsheets/d/18H2_oK6Y3MGj3SKewifWYd63qHTIV8VgVfuGtXaOmD8/edit?usp=sharing

Sort:  

Interesting informasion... Thanks sir..

Thank you :) It's really fun analyzing data and learning from it.

Good analysis and data Mix. I agree 100% with the results of the research. For me, long term is the safest and most reliable investment strategy. I wish I would have loaded up on more like a month ago, but that’s ok. It’s hard to pick the bottoms.

GL to all of us.

I was too early to get back into crypto. On January, I got all my initial investment out. My initial investment went back all into crypto in early February. I thought it was the bottom :( Got to be patient. I'm also learning technical analysis.