Inputs
Export
Exports include all rows from the transactions table below.
Transactions
| # | Date | Price (USD) | Amount (USD) | Fees (USD) | Effective Price | BTC Bought | Cumulative BTC | Cumulative Invested | Average Cost | Portfolio Value | Unrealized P/L |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Totals | 0.00000000 | — | $0.00 | — | — | — | |||||
Example dataset
Illustrative weekly DCA with $100 contributions, 0.5% fee, and 0.1% slippage. Prices are sample values only.
| # | Date | Price | Amount | Fees | Eff. Price | BTC Bought | Cum BTC | Cum Invested | Avg Cost |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 2025-01-05 | $45,000 | $100.00 | $1.00 | $45,045 | 0.002197 | 0.002197 | $99.00 | $45,079 |
| 2 | 2025-01-12 | $47,200 | $100.00 | $1.00 | $47,247 | 0.002093 | 0.004289 | $198.00 | $46,131 |
| 3 | 2025-01-19 | $44,300 | $100.00 | $1.00 | $44,344 | 0.002228 | 0.006517 | $297.00 | $45,587 |
| 4 | 2025-01-26 | $43,800 | $100.00 | $1.00 | $43,844 | 0.002241 | 0.008758 | $396.00 | $45,212 |
| 5 | 2025-02-02 | $46,100 | $100.00 | $1.00 | $46,146 | 0.002139 | 0.010897 | $495.00 | $45,404 |
Formula used
- Percent fee (USD) = Amount × (Fee% ÷ 100)
- Total fees (USD) = Percent fee + Fixed fee
- Net invested (USD) = Amount − Total fees
- Effective price (USD) = Market price × (1 + Slippage% ÷ 100)
- BTC bought = Net invested ÷ Effective price
- Cumulative BTC = Σ BTC bought
- Cumulative invested = Σ Net invested
- Average cost (USD/BTC) = Cumulative invested ÷ Cumulative BTC
- Portfolio value (USD) = Cumulative BTC × Current BTC price
- Unrealized P/L (USD) = Portfolio value − Cumulative invested
How to use this calculator
- Choose start/end dates and a frequency. Optionally enter custom interval days.
- Enter the contribution amount, fees, and slippage assumptions.
- Optionally provide a current BTC price to compute P/L.
- Click Generate schedule to create rows. Prefill prices using the field, or toggle auto-fetch.
- Review or edit any price in the table. Then click Calculate.
- Download the transactions table as CSV or PDF for records.
This tool is for education only and not financial advice.
Planned buys and budget by schedule
Computed from your date range, weekend choice, and amount per buy.
| Schedule | Planned buys | Gross per buy | Gross total |
|---|---|---|---|
| Daily | — | — | — |
| Weekly | — | — | — |
| Biweekly | — | — | — |
| Monthly | — | — | — |
Fee sensitivity for your contribution
Shows fees and net invested for typical percentage fees plus your fixed fee.
| Percent fee | Fixed fee | Gross per buy | Total fees | Net invested |
|---|---|---|---|---|
| 0.00% | — | — | — | — |
| 0.25% | — | — | — | — |
| 0.50% | — | — | — | — |
| 1.00% | — | — | — | — |
| 1.50% | — | — | — | — |
Slippage effect at current price
Effective price and BTC bought for common slippage levels using your current price.
| Slippage | Effective price | Net invested | BTC bought |
|---|---|---|---|
| 0.00% | — | — | — |
| 0.10% | — | — | — |
| 0.25% | — | — | — |
| 0.50% | — | — | — |
| 1.00% | — | — | — |