MultiversX Tracker is Live!

Bitcoin Historic Data Analysis 2012 - 2021 theoretical DCA strategies (u/jack_murray is kinda right)

Bitcoin Reddit

More / Bitcoin Reddit 48 Views

Bitcoin Historic Data Analysis 2012 - 2021 theoretical DCA strategies (u/jack_murray is kinda right)

I did this post earlier in the day but I succeeded only in confirming my own bias it seems.
(I was also at work and half assed the analysis.)

I was wanting to prove in favor of the idea of DCAing your investment in response to another post saying it was bad.

First off, my math was way wrong, noticing this I decided to alter it to capture the amount in BTC as jack_murray did, this made the accumulation of the value over time much more clear. The way I was doing it trying to determine the value by the USD price bought at, which is wrong and would require more steps to make accurate.

Second, after doing it correctly, I saw the pattern he had described in the original post but then it made me want to dig further and confirm it.

The logic of

...and if you believe each day is a more or less random event that is independent from the other, then your expected price for each day will be more or less linear up to the final expected price...

is actually pretty sound.

I've redone the graph to show the growth of an hourly $0.50 investment, a biweekly $168 investment, and a quadweekly $336 investment which we will use for monthly as a step up from his logic.

I will show the graphs and spare the code this time but it can be viewed right here

So this is the graph for the correctly calculated logic for the investments.

2012-2021

Here we see the logic of DCAing a smaller sum as often as you can seems to keep up in the initial years, not taking much time for a hourly or biweekly purchase to catch up in value to a quad/monthly investment.

The total output for this graph was:

Hourly DCA value: ~726.13016094 Biweekly DCA value: ~747.79138679 Quadweekly DCA value: ~777.00114745 Quadweekly DCA is better than hourly and biweekly DCA The difference from hourly is ~50.87098651 BTC The difference from biweekly is ~29.20976066 BTC 

However, I took away the initial first half of the data and wanted to see if this still held true if you were not able to buy at the lower prices. That graph shows as follows:

2nd or 3rd Quarter 2016 - 2021

This again shows the same pattern. Initial investments are the same but spread out, it doesn't take too much time for a hourly or biweekly DCA to catch up to the quad/monthly investments.

However, after enough time, they start to flatten out and the initial larger investments, less frequently, captures more value over time.

The output for this graph was:

Hourly DCA value: ~6.43636485 Biweekly DCA value: ~6.53238826 Quadweekly DCA value: ~6.6355424 Quadweekly DCA is better than hourly and biweekly DCA The difference from hourly is ~0.19917755 BTC The difference from biweekly is ~0.10315414 BTC 

Much less dramatic in the difference than I expected, nonetheless, it had kept up in its performance.

Here is the last graph where I only used the last quarter of the data, and yet, it still holds up.

1st Quarter 2019 to 2021

Output:

Hourly DCA value: ~1.24297321 Biweekly DCA value: ~1.27118742 Quadweekly DCA value: ~1.30507422 Quadweekly DCA is better than hourly and biweekly DCA The difference from hourly is ~0.06210101 BTC The difference from biweekly is ~0.0338868 BTC 

Then I decided, why not really turn up the gas?

There has to be a point where the is an investment that is too much at a time, and it will surely start to under-perform compared to a DCA strategy that simply invests less, more often. But then I realized I had been failing to capture the USD value of the investment over this period.

Of course you spend more USD you're getting more sats over time.

So what was the difference in the fluctuation in price per the investment strategies?

That's when what I was looking for showed up

2012-2021

Output:

Hourly DCA BTC value: ~726.13016094 Biweekly DCA BTC value: ~747.79138679 Quadweekly DCA BTC value: ~777.00114745 Yearly Lump Investment BTC value: ~2278.12065014 3-Month Interval BTC value: ~1497.62706738 6-Month Interval BTC value: ~1776.15862315 9-Month Interval BTC value: ~1826.7085963 2-Year Interval BTC value: ~3383.05674626 3-Year Interval BTC value: ~5060.90135927 Total investment in USD: $223045622965.9 Final BTC worth in USD (Hourly DCA): $42670566.46 Final BTC worth in USD (Biweekly DCA): $43943474.3 Final BTC worth in USD (Quadweekly DCA): $45659966.88 Final BTC worth in USD (Yearly Lump Investment): $133872277.78 Final BTC worth in USD (3-Month Interval): $88007080.2 Final BTC worth in USD (6-Month Interval): $104374805.85 Final BTC worth in USD (9-Month Interval): $107345342.14 Final BTC worth in USD (2-Year Interval): $198803128.55 Final BTC worth in USD (3-Year Interval): $297400575.57 3-Year Interval is the best strategy for BTC valuation. 3-Year Interval is the best strategy for USD valuation. 

Long Term still wins, but cut the time into a fourth and you get:

Hourly DCA BTC value: ~1.24297321 Biweekly DCA BTC value: ~1.27118742 Quadweekly DCA BTC value: ~1.30507422 Yearly Lump Investment BTC value: ~3.51834809 3-Month Interval BTC value: ~2.37060162 6-Month Interval BTC value: ~2.65536827 9-Month Interval BTC value: ~2.82621894 2-Year Interval BTC value: ~5.09641951 3-Year Interval BTC value: ~6.50343393 Total investment in USD: $155777428611.17 Final BTC worth in USD (Hourly DCA): $73042.51 Final BTC worth in USD (Biweekly DCA): $74700.5 Final BTC worth in USD (Quadweekly DCA): $76691.84 Final BTC worth in USD (Yearly Lump Investment): $206753.44 Final BTC worth in USD (3-Month Interval): $139306.86 Final BTC worth in USD (6-Month Interval): $156040.99 Final BTC worth in USD (9-Month Interval): $166080.92 Final BTC worth in USD (2-Year Interval): $299487.78 Final BTC worth in USD (3-Year Interval): $382170.06 3-Year Interval is the best strategy for BTC valuation. Hourly DCA is the best strategy for USD valuation. 

Here we finally see it, and for some reason, the graph looks pretty much the same but there's a connecting line between the first and last points, I am not sure why.

https://preview.redd.it/irqjpt5zpnbb1.png?1189&format=png&auto=webp&s=6b8f2faa675fe972fd347143dd798e7e96bbb351

What all of this data is saying, or at least as I am interpreting it, it's actually better to save a bit of money and make a larger investment to capture more value over time, but if you want to capture value to turn back into USD, you should DCA hourly.

Thank you u/jack_murray for the original post making this a nagging thought in my head the whole day that I had to prove right or wrong, but I don't think I succeeded with either.

There was also another user that pointed out the initial purchase was omitted from my last solution, here it would be much more dramatic and important to have that initial purchase, so thank you too for also pointing that out. I deleted the last post because it was just wrong and can't remember your u/

submitted by /u/ominous_raspberry
[link] [comments]

Get BONUS $200 for FREE!

You can get bonuses upto $100 FREE BONUS when you:
πŸ’° Install these recommended apps:
πŸ’² SocialGood - 100% Crypto Back on Everyday Shopping
πŸ’² xPortal - The DeFi For The Next Billion
πŸ’² CryptoTab Browser - Lightweight, fast, and ready to mine!
πŸ’° Register on these recommended exchanges:
🟑 Binance🟑 Bitfinex🟑 Bitmart🟑 Bittrex🟑 Bitget
🟑 CoinEx🟑 Crypto.com🟑 Gate.io🟑 Huobi🟑 Kucoin.



Comments