On this page 9
Key takeaways
- Average cost = total spent ÷ total coins. Equal buys always give an average below the simple average of the prices you paid.
- DCA beats a lump sum when prices fall after you start, and loses when they rise steadily. Over traditional-market history, lump sum won about two-thirds of the time.
- Buying frequency matters less than most people think. Fees, especially flat per-purchase fees, matter more.
- The calculator uses scenario-shaped random paths, not real prices. Use it to understand behaviour, not to forecast.
DCA vs lump-sum simulator
Scenario model, not a forecastThe lump sum invests the same total on day one. Prices follow a seeded random path shaped by the scenario, so results are illustrative only. Change the seed to see luck at work.
Dollar-cost averaging is the simplest crypto plan there is: pick an amount, pick a schedule, keep buying. This free crypto DCA calculator shows what that plan does to your average cost in different markets and how it stacks up against putting the same money in on day one. If you are new to the idea itself, start with what DCA in crypto means; this page focuses on the numbers.
How the DCA calculator inputs work
| Input | What it does | Tip |
|---|---|---|
| Market scenario | Shapes the random path: bull, bear, sideways, crash and recovery, or custom | Run the bear case before the bull case |
| Amount per buy | Dollars spent on each purchase | Use what you can keep up for years |
| Frequency | Weekly, every two weeks or monthly | Match it to your pay cycle |
| Start price | The coin price at your first buy | Enter today's price for any coin |
| Fee per buy | Percentage taken from each purchase | Check the real fee on your buy screen |
| Duration | 1 to 10 years of buying | Longer plans smooth more timing luck |
| Price change (custom) | Where the price ends, from −90% to +400% | Test break-even: when does DCA lose money? |
| Volatility | How violently the path swings | Altcoins usually belong on High |
The lump-sum comparison invests the total amount you would have spent by the end, all at the start price, with the same fee. The end price is pinned to your scenario, so both plans finish at the same price and the comparison is fair. "New random path" changes the route the price takes to get there, which is where DCA wins or loses.
How to calculate DCA in crypto: the average-cost formula
Three formulas do all the work. For each purchase:
coins bought = (amount − fee) ÷ priceAcross the whole plan:
average cost = total spent ÷ total coins
value = total coins × current price
profit/loss = value − total spentA useful property: if you spend the same amount every time and ignore fees, your average cost equals the harmonic mean of the prices, which is always at or below the ordinary average. You automatically buy more coins when the price is low. That is the mechanical edge of DCA, and the reason it smooths out volatile markets. It does not make a falling coin profitable.
Worked example: six months of $100 buys
Suppose you buy $100 of bitcoin every month for six months with a 0.25% fee. The prices are illustrative, chosen to show a dip and recovery.
Illustrative six-month DCA plan, $100 per buy, 0.25% fee (our own calculation)
| Month | BTC price | BTC bought | Total BTC | Invested | Average cost |
|---|---|---|---|---|---|
| 1 | $60,000 | 0.001662 | 0.001662 | $100 | $60,150 |
| 2 | $52,000 | 0.001918 | 0.003581 | $200 | $55,854 |
| 3 | $45,000 | 0.002217 | 0.005797 | $300 | $51,747 |
| 4 | $48,000 | 0.002078 | 0.007876 | $400 | $50,790 |
| 5 | $56,000 | 0.001781 | 0.009657 | $500 | $51,777 |
| 6 | $63,000 | 0.001583 | 0.011240 | $600 | $53,380 |
At $63,000 the DCA position is worth about $708, an 18% gain, even though the price is only 5% above where you started. A $600 lump sum at $60,000 would be worth about $628. DCA won because half the buys happened below the start price.
Now flip the path: the price climbs steadily from $60,000 to $70,000 in $2,000 steps. DCA's average cost rises to about $64,983, and the position ends at about $646. The lump sum, bought entirely at $60,000, ends at about $698. Same coin, same end price trend, opposite winner. Which one wins depends on the path, and you do not know the path in advance.
DCA vs lump sum: what the evidence says
The best-known studies come from traditional markets. Vanguard's 2012 paper "Dollar-cost averaging just means taking risk later" compared the two approaches across US, UK and Australian markets and found lump-sum investing came out ahead about two-thirds of the time. Its 2023 follow-up, Cost averaging: Invest now or temporarily hold your cash?, reached a similar conclusion and noted that cost averaging can still suit investors who are very averse to risk and losses.
The logic is simple. If markets rise more often than they fall, money invested earlier spends more time rising. DCA holds cash on the sidelines, so on average it misses some of that. Its advantage is behavioural: it caps the regret of putting everything in the day before a crash, and it makes a plan easier to stick with.
Crypto adds two twists. Volatility is far higher, so the gap between the two outcomes on any single path can be large in either direction. And crypto history is short, with a few huge cycles, so backtests of "DCA vs lump sum in bitcoin" depend heavily on the start date chosen. We have not seen a crypto study robust enough to quote a single win rate, which is why this tool lets you test paths instead.
How frequency and fees change the result
People spend a lot of time on daily vs weekly vs monthly. In a simulation we ran for this page (1,000 random three-year paths with 70% annual volatility and no drift), the median difference between weekly and monthly average cost was about 0.8%, and nine in ten paths were within about 2.1%. Daily vs weekly differed by a median of about 0.2%. Timing luck largely washes out over years.
Fees do not wash out. How they are charged matters:
| Fee type | $1,200 a year monthly | $1,200 a year daily | Takeaway |
|---|---|---|---|
| 0.25% of each buy | $3.00 | $3.00 | Frequency does not matter |
| Hypothetical $1 flat fee per buy | $12 (1%) | $365 (30%) | Frequent small buys get crushed |
| Spread on a simple buy screen | Varies | Varies | Compare with the order-book price |
Check what your exchange actually charges for recurring purchases on the confirmation screen. Kraken, for instance, notes that recurring orders are not available on Kraken Pro, and Coinbase executes the first purchase immediately when you set up a schedule. Our DCA bots comparison lists exchange recurring-buy features side by side.
How to use your DCA results
Run the scenarios you fear
Bear market and crash first. If you could live with that outcome for the full duration, the plan is sized right.
Find your break-even
In Custom, move the price change slider until DCA value equals total invested. That is how far the coin can fall while your average cost still protects you.
Reseed a few times
Each new path changes the order of highs and lows. The spread you see is the real uncertainty.
Compare the cost line
On the chart, the pink dashed line is your average cost. When price is above it you are in profit.
Turn it into a real plan
Pick an amount you can keep up, set a recurring buy on a venue you trust, and log each purchase.
A DCA plan needs a venue that lasts
Recurring buys can run for years, so pick a long-running, regulated exchange. CEX.IO has operated since 2013, is a FinCEN-registered MSB with money transmitter licences in 39 US states plus DC, is FCA-registered in the UK and holds a PCI DSS Level 1 certificate for card payments.
Registrations checked October 2026 on the company's legal pages. Availability depends on your country; crypto is high-risk.
- Since 2013One of the longest-running crypto exchanges still operating
source - 39 US states + DCFinCEN-registered MSB with state money transmitter licences (NMLS 1804170)
source - FCA-registeredUK cryptoasset business under the MLRs, FRN 1007192
source - PCI DSS Level 1Card-payment security standard, 2026 certificate published
source
DCA spreadsheet template for Google Sheets or Excel
A calculator models the plan; a log tracks the reality. Set up a sheet with one row per purchase and these columns. The formulas assume row 2 is your first purchase; copy them down.
DCA log columns and formulas (Google Sheets and Excel)
| Column | Header | What to enter or formula |
|---|---|---|
| A | Date | Purchase date |
| B | Coin | BTC, ETH, etc. |
| C | Price | Price per coin at fill |
| D | Amount spent | Total charged, including fee |
| E | Fee | Fee in dollars |
| F | Coins bought | =(D2-E2)/C2 |
| G | Total coins | =SUM($F$2:F2) |
| H | Total invested | =SUM($D$2:D2) |
| I | Average cost | =H2/G2 |
| J | Current price | Typed in, or a price function where your sheet supports one |
| K | Value | =G2*J2 |
| L | P&L and P&L % | =K2-H2 and =L2/H2 |
Keep one sheet per coin, or add a filter on column B. If you buy on several exchanges, add an "Exchange" column so you can reconcile with statements at tax time. A log also keeps you honest: after a year you can compare your real average cost with what the calculator suggested.
Want the buying to happen automatically? Compare recurring buys and bots in our guide to crypto DCA bots, or check whether a paid bot is worth it with the trading bot ROI calculator. All calculators are listed on the crypto tools hub, and if you decide to automate more than buying, start with our ranking of the best AI crypto trading bots. This calculator is for education, not financial advice.
Frequently asked questions
How do you calculate DCA in crypto?
Add up everything you spent, including fees, and divide by the total number of coins you received. That is your average cost per coin. Each purchase buys (amount − fee) ÷ price coins. Your profit or loss is total coins × current price minus total spent.
Is DCA better than investing a lump sum?
Not on average. Research on traditional markets, including Vanguard's 2012 and 2023 papers, found lump-sum investing came out ahead roughly two-thirds of the time, because markets rose more often than they fell. DCA wins when prices drop after you start, and it reduces the regret of investing everything at a top. Crypto is far more volatile, so the spread of outcomes is wider.
Is it better to DCA daily, weekly or monthly?
Over long periods the difference in average cost is usually small. In our own 1,000-path simulation the median gap between weekly and monthly average cost was under 1%. Fees decide more: percentage fees cost the same however often you buy, but flat per-purchase fees and minimums make frequent small buys expensive.
Does this DCA calculator use real bitcoin prices?
No. It generates a seeded random price path shaped by the scenario you choose (bull, bear, sideways, crash and recovery, or custom) and pins the end price to that scenario. That lets you see how DCA behaves in different markets rather than in one historical window. Press "New random path" to see how much luck matters.
Can I use this as a crypto DCA simulator for any coin?
Yes. Enter the coin's current price as the start price and pick a volatility level that matches it; altcoins usually belong on High. The maths is the same for any asset. Results are illustrative and not a forecast for that coin.
Is there a DCA spreadsheet template for Google Sheets or Excel?
You can build one in a few minutes with the columns in our DCA log table: date, price, amount, fee, coins bought, cumulative coins, total invested, average cost, value and P&L. The formulas work the same in Google Sheets and Excel.
Keep reading
Sources and fact-check dates
We link to primary sources wherever possible. Dates show when the page was published or when we last checked it.
- Vanguard (2023): Cost averaging: Invest now or temporarily hold your cash? · published Feb 2023, checked 2026-10-21
- Shtekhman, Tasopoulos, Wimmer: Dollar-cost averaging just means taking risk later (Vanguard, 2012), coverage · checked 2026-10-21
- Kraken support: Recurring orders · checked 2026-10-21
- Coinbase help: How to set up recurring buys · checked 2026-10-21
