Bitcoin & Ethereum Historical DCA Calculator
Choose a past period and replay regular purchases against recorded Bitcoin or Ethereum prices. Inspect every scheduled buy.
Your inputs
Your result
- End value before sell fees
- $3,781.67
- Net gain / loss
- $381.67
- Total contributed
- $3,400.00
- Scheduled purchases
- 34
- Average cost including buy fees
- $74,542.87
- Units held
- 0.04561134
- Buy fees paid
- $3.40
- Same budget bought upfront
- $6,659.36
Calculation ledger
34Showing first and last rows; the CSV includes the complete ledger.
| UTC date | Daily open | Budget per purchase (USD) | Fee paid (USD) | Units purchased | Units held | Total contributed |
|---|---|---|---|---|---|---|
| 2024-01-01 | $42,288.58 | $100.00 | $0.10 | 0.00236234 | 0.00236234 | $100.00 |
| 2024-02-01 | $42,545.47 | $100.00 | $0.10 | 0.00234808 | 0.00471042 | $200.00 |
| 2024-03-01 | $61,179.03 | $100.00 | $0.10 | 0.00163291 | 0.00634333 | $300.00 |
| 2024-04-01 | $71,291.50 | $100.00 | $0.10 | 0.00140129 | 0.00774462 | $400.00 |
| 2024-05-01 | $60,621.20 | $100.00 | $0.10 | 0.00164794 | 0.00939256 | $500.00 |
| 2024-06-01 | $67,473.07 | $100.00 | $0.10 | 0.00148059 | 0.01087315 | $600.00 |
| 2024-07-01 | $62,669.14 | $100.00 | $0.10 | 0.00159409 | 0.01246723 | $700.00 |
| 2024-08-01 | $64,609.61 | $100.00 | $0.10 | 0.00154621 | 0.01401344 | $800.00 |
| 2026-08-01 | $62,826.69 | $100.00 | $0.10 | 0.00159009 | 0.04314414 | $3,200.00 |
| 2026-09-01 | $78,562.74 | $100.00 | $0.10 | 0.0012716 | 0.04441573 | $3,300.00 |
| 2026-10-01 | $83,556.14 | $100.00 | $0.10 | 0.0011956 | 0.04561134 | $3,400.00 |
How this calculation works
Prices are recorded daily Coinbase Exchange spot candles in USD. Purchases occur at the selected day's UTC open, with buy fees deducted from the entered budget. Portfolio value uses each day's close. The end date is included; no candle after that date is used.
The first purchase is on your start date. Weekly purchases repeat every seven days. Monthly purchases use the original calendar day, or the month's last day when needed. The upfront comparison buys the total scheduled budget at the first day's open and assumes all that cash was available then.
Formula
Bought units = scheduled budget × (1 − buy fee) ÷ daily open. Portfolio value = accumulated units × daily close.
Worked example
With no fees, two $100 purchases at reference prices of $100 and $50 accumulate 3 units. At a final close of $60, their marked value is $180 against $200 contributed. The purchase schedule alone does not guarantee a gain.
What to keep in mind
Historical candle prices are reference prices, not confirmed executable fills. The calculation excludes spread, slippage, sell fees, taxes and interest on unused cash. Upfront and gradual funding are different assumptions. Missing dates are rejected rather than filled with invented prices. Past results do not establish future returns.