Pages:
Author

Topic: Lump vs DCA with real data - page 2. (Read 226 times)

member
Activity: 360
Merit: 22
September 08, 2023, 05:44:55 PM
#1
Lump some purchase at the first of the month from Jan 1, 2019 to August 1 2023, 56 weeks hence $5600 dollars. This is so I  can apples to apples with DCA. I know it's very aggregate and course data. 2021 and 2022 to current 8/23 would suck. Sure more finite data is cool (I have it) but this is an exercise. We don't have the luxury of looking at history and saying oh I woulda/shoulda/coulda done this blah blah blah. I could do it on the weekly or daily and it looks way different for sure, but I ain't giving it away, not sorry. What is really cool isn't some head and shoulders and falling wedge crap, It's a added the news in another column that affected it.

$5600 number is stems from 56 weeks.

Lump

2019      BTC      Lump    BTC PUR   Final amount at 8/2023
Jan    $3,843.52    $5,600    1.45 BTC   $43,237.47   

Using August 1 2023 as the sale date
Aug    $29,675.73

DCA

Now using DCA at 100 per month

Month   BTC on 1st    @100permonth
   
2019                      BTC   
Jan    $3,843.52    0.026   
Feb    $3,487.95    0.0286   
Mar    $3,859.58    0.0259   
Apr    $4,158.18    0.024   
May    $5,402.70    0.0222   
Jun    $8,564.02    0.0116   
Jul    $10,583.13    0.009   
Aug    $10,399.67   0.0096   
Sep    $9,757.97    0.01   
Oct    $8,343.28    0.012   
Nov    $9,261.10    0.0107   
Dec    $7,424.29    0.0134   
2020         
Jan    $7,200.17    0.0138   
Feb    $9,392.88    0.0106   
Mar    $8,562.45    0.0116   
Apr    $6,606.78    0.0151   
May    $8,864.77    0.0112   
Jun    $10,167.27    0.0098   
Jul    $9,228.33    0.0108   
Aug    $11,759.59    0.0085   
Sep    $11,970.48    0.0083   
Oct    $10,619.45    0.0094   
Nov    $13,737.11    0.0072   
Dec    $18,803.00    0.0053   
2021         
Jan    $29,374.15    0.0034   
Feb    $33,573.18    0.0029   
Mar    $49,631.24    0.002   
Apr    $59,095.81    0.0017   
May    $57,828.05    0.00173   
Jun    $36,684.93    0.0027   
Jul    $33,572.12    0.0029   
Aug    $39,974.89    0.0025   
Sep    $48,847.03    0.002   
Oct    $48,116.94    0.002   
Nov    $61,004.41    0.0016   
Dec    $57,229.83    0.0017   
2022         
Jan    $47,686.81    0.002   
Feb    $38,743.27    0.0025   
Mar    $44,354.64    0.0022   
Apr    $46,281.64    0.0021   
May    $38,469.09    0.0026   
Jun    $29,799.08    0.0034   
Jul    $19,269.37    0.0051   
Aug    $23,314.20    0.0042   
Sep    $20,127.14    0.005   
Oct    $19,312.10    0.0051   
Nov    $20,485.27    0.0048   
Dec    $16,967.13    0.0058   
2023         
Jan    $16,625.08    0.006   
Feb    $23,723.77    0.0042   
Mar    $23,646.55    0.0042   
Apr    $28,411.04    0.0035   
May    $28,091.57    0.0035   
Jun    $26,819.97    0.0037   
Jul    $30,590.08    0.0032   
Aug    $29,675.73    0.0033   
      
         TOTAL      0.42813   12,705.00
      
   
Pages:
Jump to: