DCA Calculator for Crypto in Google Sheets (2026)

What Is Dollar-Cost Averaging?

Dollar-Cost Averaging (DCA) means investing a fixed amount at regular intervals — say $200 every month into Bitcoin — regardless of the current price. When prices drop, you buy more coins. When prices rise, you buy fewer. Over time, this smooths out volatility and reduces the risk of buying everything at a peak.

Tracking DCA in a spreadsheet gives you something no app dashboard can: full control. You see your exact average cost, cumulative investment, and real-time P&L side by side. CoinTable, a Google Sheets add-on for cryptocurrency prices, makes this possible by injecting live market data directly into your formulas.

For the full setup on getting crypto prices into Sheets, see our guide on how to get crypto prices in Google Sheets.

Why Track DCA in Google Sheets?

• See your true average cost — Not an estimate from an exchange, but a formula you control
• Compare DCA vs. lump sum — Run both scenarios with real numbers
• Full audit trail — Every purchase logged with date, amount, and price
• No vendor lock-in — Your data lives in your Google Drive, not in a third-party app
• Live valuation — CoinTable formulas update your current value automatically

Build the DCA Calculator Step by Step

Column Layout

Set up your sheet with these columns:

The Formulas

Enter these formulas in row 2, then drag them down for each purchase:

D2 (Coins Bought):       =B2/C2
E2 (Running Total Coins): =SUM(D$2:D2)
F2 (Total Invested):      =SUM(B$2:B2)
G2 (Current Value):       =E2*CT_PRICE("BTC")
H2 (P&L):                 =G2-F2

The key formula is =E2*CT_PRICE("BTC") — it multiplies your running coin total by the live Bitcoin price from CoinTable. Every time the sheet recalculates, your P&L updates.

Average Cost Basis

Add this formula in a summary cell above or beside your table:

Average Cost = Total Invested / Running Total Coins
             = =F100/E100  (where row 100 is your last entry)

Or more precisely, use a dynamic formula:

=SUMPRODUCT(B2:B100*(B2:B100<>"")) / SUMPRODUCT(D2:D100*(D2:D100<>""))

This handles empty rows without breaking.

Complete Example: BTC DCA Over 6 Months

Here's what a real DCA log looks like. Assume you invest $200 on the 1st of each month:

Summary Dashboard

Add these summary formulas at the top of your sheet:

Total Invested:    =SUM(B2:B7)                        → $1,200.00
Total BTC:         =SUM(D2:D7)                        → 0.016827
Average Cost:      =SUM(B2:B7)/SUM(D2:D7)             → $71,318
Current BTC Price: =CT_PRICE("BTC")                   → (live)
Current Value:     =SUM(D2:D7)*CT_PRICE("BTC")        → (live)
Total P&L ($):     =Current Value - Total Invested     → (live)
Total Return (%):  =(Current Value - Total Invested)
                    / Total Invested * 100             → (live)

DCA for Any Coin, Not Just Bitcoin

The same spreadsheet works for any cryptocurrency. Replace "BTC" with any ticker CoinTable supports:

=CT_PRICE("ETH")    → Ethereum DCA
=CT_PRICE("SOL")    → Solana DCA
=CT_PRICE("DOGE")   → Dogecoin DCA

You can even track multiple DCA strategies in separate sheets within the same workbook — one tab for BTC, another for ETH, a third for SOL. The formulas are identical; only the ticker changes.

For more formula options, check out the crypto formulas cheat sheet.

DCA vs. Lump Sum: Compare Both Strategies

One of the biggest advantages of building your own spreadsheet is running "what if" scenarios. Here's how to compare DCA against a lump-sum investment.

Lump Sum Setup

In a separate section of your sheet:

Lump Sum Amount:       $1,200 (same as total DCA invested)
Lump Sum Date:         2025-10-01 (same as DCA start)
BTC Price on That Date: $63,500
BTC Bought:            =1200/63500                → 0.018898
Current Value:         =0.018898*CT_PRICE("BTC")  → (live)
Lump Sum P&L:          =Current Value - 1200      → (live)

Side-by-Side Comparison

In a steadily rising market, lump sum tends to outperform DCA because you bought more coins at the lower early price. In a volatile or declining market, DCA protects you by spreading your purchases across multiple price points.

The spreadsheet lets you see exactly which strategy would have won for your specific time period and coin.

Adding a Chart

Visualize your DCA progress with a Google Sheets chart:

1. Select your Date column and Current Value column
2. Go to Insert → Chart
3. Choose a Line chart
4. Add a second series for Total Invested to see both lines on the same chart

The gap between the two lines is your P&L. When Current Value is above Total Invested, you're in profit. When it dips below, you're in a drawdown.

Advanced: Multi-Coin DCA Portfolio

If you DCA into several coins, combine them into a single dashboard:

For a more complete portfolio setup with allocation percentages and 24h changes, see our crypto portfolio tracker in Google Sheets guide.

DCA Frequency: Weekly vs. Monthly

How often should you DCA? The answer depends on your budget and patience, but the spreadsheet makes it easy to compare.

Weekly DCA Example

$50 per week into ETH over 12 weeks:

Weekly DCA gives you more data points and a smoother average cost. Monthly DCA is simpler to manage and uses fewer CoinTable requests. For most people, monthly is the practical choice.

Tips for Your DCA Spreadsheet

1. Lock historical prices — Once you record a purchase, paste the price as a value (Ctrl+Shift+V) so it doesn't change. Only the "Current Value" column should use live CoinTable formulas.

2. Automate logging — Use Google Apps Script with a time trigger to append a new row on your DCA schedule automatically.

3. Use number formatting — Format dollar columns as currency, BTC columns with 6-8 decimal places, and percentage columns as percentages.

4. Color-code P&L — Apply conditional formatting: green for positive P&L, red for negative.

5. Set realistic intervals — Weekly, bi-weekly, or monthly are the most common DCA frequencies. Daily DCA generates too many rows and eats through CoinTable requests faster.

Getting Started

1. Install CoinTable — Get it from Google Workspace Marketplace
2. Create the columns — Use the layout from this guide
3. Enter your first purchase — Date, amount, and price
4. Add formulas — Running total, current value, and P&L
5. Repeat on schedule — Add a new row each time you buy

If you want a ready-to-use layout, our best crypto Google Sheets templates article includes a DCA template you can copy and start using immediately.