Home › Templates › DCA tracker

DCA Tracker Spreadsheet

A free dollar cost averaging spreadsheet that logs every recurring buy, works out units after fees, totals each asset with your average cost, market value and profit or loss, plans a buying schedule, and compares lump sum vs DCA on the same prices.

Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no add-on, no email. The formulas are plain SUMIFS, COUNTIFS, INDEX and EDATE.

Asset	Buys	Invested	Fees	Units	Avg cost	Price now	Value	P/L	P/L %
FUND-A	12	$2,400.00	$12.00	49.4741	$48.51	$55.00	$2,721.08	$321.08	13.38%
COIN-B	12	$1,200.00	$18.00	0.041938	$28,613.41	$34,000.00	$1,425.90	$225.90	18.83%
Total	24	$3,600.00	$30.00				$4,146.98	$546.98	15.19%

Chart: the Example Lump sum tab, $2,400 invested in FUND-A as 12 × $200 (DCA) or all at once in month 1.

What's inside the spreadsheet

How to use it

1. On Summary, type each asset once in column A, for example a fund ticker or a coin symbol.
2. On Buys, add one row per purchase: date, asset (pick it from the dropdown), the amount that left your account including the fee, the fee, and the price per unit from your confirmation.
3. Units, running totals and average cost fill in by themselves. Do not type over the grey columns.
4. When you review, type today's price for each asset in Summary column G. Value, P/L and P/L % update.
5. Check that "not matched to an asset" on Summary shows $0.00. If not, an asset name in the log is spelled differently.
6. Planning a new routine? Fill in Schedule planner to see the dates, total invested and what the fees add up to.
7. Curious how timing matters? Enter a price series in Lump sum vs DCA and compare.

What dollar cost averaging does, and what it does not

Investor.gov (SEC) defines dollar cost averaging as investing "in equal portions, at regular intervals, regardless of the ups and downs in the market." With the same amount each time, you "buy more of an investment when its price is low" and less when it is high. That is why, before fees, your average cost per unit is never above the simple average of the prices you paid.

FINRA, "The Benefits and Limitations of Dollar-Cost Averaging" (May 19, 2026), lists both sides:

• Benefits: it "can remove some of the emotion from investing", and it "can help you limit your losses in the event of significant market declines", because money not yet invested is not hit by the drop.
• Limits: it "often produces lower returns than lump sum investing, especially over longer periods of time". If you pay a fee on each trade, DCA "might result in higher fees than lump sum investing".

No guarantee. The NASD (FINRA's predecessor) standard for investment plan ads, in Notice to Members 98-83, required firms to disclose that such a plan "does not assure a profit and does not protect against loss in declining markets." For DCA material it added that the investor should "consider his financial ability to continue his purchases through periods of low price levels."

The formulas, explained

Exact formulas from the file (row 5 shown). The Buys data sits in rows 5–1004: A = date, B = asset, C = amount, D = fee, E = price, F = units.

The running totals use a range that grows row by row ($C$5:C5, then $C$5:C6 …), so each row shows the position after that buy only.

Worked example from the sample data

FUND-A: $200 a month for 12 months

First buy: ($200.00 − $1.00) ÷ $50.00 = 3.9800 units. After 12 buys FUND-A holds 49.4741 units for $2,400.00, an average cost of $48.51 per unit (fees included). The simple average of the 12 prices is $48.5417. The low prices in February ($42.00) bought the most units (4.7381). At the fictional current price of $55.00, the position is worth $2,721.08: P/L $321.08 or 13.38%.

COIN-B: fractional units

$100 a month with a $1.50 fee bought 0.041938 COIN-B in total, an average cost of $28,613.41. At $34,000.00 that is $1,425.90. The whole example portfolio: $3,600.00 invested, $4,146.98 value, P/L $546.98 (15.19%).

Lump sum vs DCA on the same 12 prices

Putting $2,400 into FUND-A at once in month 1 buys ($2,400 − $1) ÷ $50.00 = 47.98 units, a cost of $50.02 per unit. At the last price of $53.00 that is worth $2,542.94. DCA ended at $2,622.13, $79.19 more, because prices fell in the first months and DCA bought cheaper units then.

The result flips when prices mostly rise. Using the same 12 prices sorted from lowest to highest ($42.00 up to $54.50), the lump sum ends at $3,112.99 and DCA at $2,696.34. Neither path can be known in advance, which is why FINRA describes the trade-off rather than a winner. The comparison ignores interest that cash waiting to be invested could earn.

Common mistakes

• Entering the amount after the fee. Type the cash that left your account in "Amount invested". The sheet subtracts the fee to get units, and keeps the fee in your cost.
• Using the average of prices as your cost. With equal amounts, your real average cost is total invested ÷ total units, which (before fees) is never above the plain average of the prices.
• Spelling an asset two ways. "FUND-A" and "Fund A" are different to SUMIFS. Watch the "not matched" check on Summary.
• Forgetting to update the price. Value and P/L use the price in Summary column G, not a live feed.
• Reading P/L % as an annual return. It is total gain ÷ total invested. Money added last month has had less time to grow than money added a year ago.
• Stopping when prices fall. Low prices are when a fixed amount buys the most units. Only plan an amount you can keep paying.

FAQ

How do I track dollar cost averaging in a spreadsheet?

Log each buy on its own row: date, asset, amount invested, fee and price. Units = (amount - fee) / price. Then total each asset with SUMIFS: invested, units, and average cost = invested / units. Multiply units by today's price for market value. The free template on this page does all of this.

How do you calculate your average cost with DCA?

Divide the total amount invested (fees included) by the total units bought. In the example, FUND-A cost $2,400.00 for 49.4741 units, so the average cost is $48.51 per unit. That is below the simple average of the 12 prices ($48.5417), because a fixed amount buys more units when the price is low.

Does dollar cost averaging guarantee a profit?

No. The NASD (now FINRA) standard for investment plan ads required disclosing that such a plan does not assure a profit and does not protect against loss in declining markets. If the price keeps falling, every buy can end up below its cost.

Is lump sum better than dollar cost averaging?

It depends on the path of prices, which nobody knows in advance. FINRA says DCA often produces lower returns than lump sum investing, especially over longer periods. In return, DCA can limit losses if the market drops sharply soon after you start. The template's Lump sum vs DCA tab shows both on the same prices.

How often should you dollar cost average?

There is no single right frequency. Many people match it to their pay cycle (weekly, every 2 weeks or monthly). If you pay a fee on each trade, more frequent buys mean more fees; FINRA notes DCA might result in higher fees than lump sum investing. The Schedule planner shows the total fee cost of each choice.

Can I use this DCA tracker for crypto?

Yes. Units are shown to six decimals, so fractional coins work. Type the coin as the asset and its price in your currency. Prices are not fetched automatically; update the current price on the Summary tab when you review.

Related tools and templates

• DCA calculatorProject a regular investing plan
• Stock average calculatorAverage price across buys
• Crypto profit calculatorP/L on a coin trade
• Investment fee calculatorWhat fees cost over time
• Compound interest calculatorGrowth with regular deposits
• Stock portfolio trackerTrades, cost basis, P/L, allocation
• Dividend trackerIncome, yield on cost, payments
• All templatesFree spreadsheets

Educational template only, not financial, tax or investment advice. Example data is fictional: FUND-A, COIN-B and all prices and fees are made up. Dollar cost averaging does not guarantee a profit or protect against loss. Quotes from Investor.gov, FINRA and NASD Notice to Members 98-83 were retrieved on 25 October 2026.