Ahorro DCA ajustado bitcoin.xlsx

	B	C	D	E	F	G	H	L
1
2	Ahorro mediante compras recurrentes de bitcoin
3
4	Precio actual de bitcoin			$22,630.00
5
6	Bitcoin acumulado (ahorro)			0.09058534
7	Precio hoy en dólares			$2,049.95
8	Dólares utilizados en las compras de BTC			$2,250.00
10	Precio ponderado de compra			$24,838.15
11	*Compra adicional
12	#Compra	Fecha	Dólares gastados	Precio de bitcoin en la compra (USD)	Cantidad de satoshis comprados	Precio actual de esos satoshis en dólares		precio ponderado
13	1	2-ago-2020	$50.00	$10,990.00	0.00455000	$102.97		$552.02
14	2	6-sep-2020	$50.00	$10,100.00	0.00495000	$112.02		$551.91
15	3	4-oct-2020	$50.00	$10,570.00	0.00473000	$107.04		$551.92
16	4	1-nov-2020	$50.00	$13,750.00	0.00363000	$82.15		$551.00
17	5	6-dic-2020	$50.00	$18,980.00	0.00263435	$59.62		$551.97
18	6	3-ene-2021	$50.00	$32,450.00	0.00154083	$34.87		$551.96
19	7	7-feb-2021	$50.00	$37,950.00	0.00131926	$29.85		$552.69
20	8	7-mar-2021	$50.00	$49,750.00	0.00100502	$22.74		$551.96
21	9	4-abr-2021	$50.00	$57,050.00	0.00087642	$19.83		$551.96
22	10	2-may-2021	$50.00	$56,400.00	0.00088652	$20.06		$551.96
23	11	6-jun-2021	$50.00	$35,450.00	0.00141044	$31.92		$551.97
24	12	4-jul-2021	$50.00	$34,500.00	0.00144927	$32.80		$551.96
25	13	20-jul-2021	$200.00	$29,400.00	0.00680272	$153.95	*	$2,207.86
26	14	1-ago-2021	$50.00	$39,600.00	0.00126262	$28.57		$551.96
27	15	26-sep-2021	$50.00	$40,920.00	0.00122189	$27.65		$551.96
28	16	31-oct-2021	$50.00	$60,200.00	0.00083056	$18.80		$551.96
29	17	28-nov-2021	$50.00	$54,100.00	0.00092421	$20.91		$551.96
30	18	4-dic-2021	$200.00	$42,100.00	0.00475059	$107.51	*	$2,207.86
31	19	26-dic-2021	$50.00	$49,700.00	0.00100604	$22.77		$551.97
32	20	23-ene-2022	$50.00	$34,800.00	0.00143678	$32.51		$551.97
33	21	27-feb-2022	$50.00	$37,400.00	0.00133690	$30.25		$551.97
34	22	27-mar-2022	$50.00	$44,600.00	0.00112108	$25.37		$551.97
35	23	24-abr-2022	$50.00	$39,200.00	0.00127551	$28.86		$551.97
36	24	11-may-2022	$200.00	$29,200.00	0.00684932	$155.00	*	$2,207.86
37	25	29-may-2022	$50.00	$28,900.00	0.00173010	$39.15		$551.96
38	26	30-jun-2022	$50.00	$18,900.00	0.00264550	$59.87		$551.97
39	27	31-jul-2022	$50.00	$23,410.00	0.00213584	$48.33		$551.97
40	28	31-ago-2022	$50.00	$19,920.00	0.00251004	$56.80		$551.97
41	29	30-sep-2022	$50.00	$19,190.00	0.00260552	$58.96		$551.97
42	30	31-oct-2022	$50.00	$20,350.00	0.00245700	$55.60		$551.97
43	31	14-nov-2022	$200.00	$15,820.00	0.01264223	$286.09	*	$2,207.86
44	32	30-nov-2022	$50.00	$16,520.00	0.00302663	$68.49		$551.97
45	33	31-dic-2022	$50.00	$16,490.00	0.00303214	$68.62		$551.97
46	34				0	$0.00		$0.00
47	35				0	$0.00		$0.00
48	36				0	$0.00		$0.00
49	37				0	$0.00		$0.00
50	38				0	$0.00		$0.00
51	39				0	$0.00		$0.00
52	40				0	$0.00		$0.00
53	41				0	$0.00		$0.00
54	42				0	$0.00		$0.00
55	43				0	$0.00		$0.00
56	44				0	$0.00		$0.00
57	45				0	$0.00		$0.00
58	46				0	$0.00		$0.00
59	47				0	$0.00		$0.00
60	48				0	$0.00		$0.00
61	49				0	$0.00		$0.00
62	50				0	$0.00		$0.00
63	51				0	$0.00		$0.00
64	52				0	$0.00		$0.00
65	53				0	$0.00		$0.00
66	54				0	$0.00		$0.00
67	55				0	$0.00		$0.00
68	56				0	$0.00		$0.00
69	57				0	$0.00		$0.00
70	58				0	$0.00		$0.00
71	59				0	$0.00		$0.00
72	60				0	$0.00		$0.00
73	Subtotales		$2,250.00		0.09058534	$2,049.95
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101