Skip to content
The title slide and first slides of the Dollar Cost Averaging Tracker template

Dollar Cost Averaging Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Modern
Difficulty
Beginner
Updated
November 16, 2026

Every slide (6)

Overview

Buying the same dollar amount each month means you get more shares when the price falls and fewer when it rises. Every purchase goes on the Buys tab with a date, fund, amount and price, and the shares are calculated for you. The Average Cost tab adds buys, dollars invested, shares and your true average cost, and sets it beside the plain average of the prices you paid.

Type the price now for each fund and the sheet shows the value, the gain in dollars and the return. Summary charts invested money against value by fund and invested money by month. Sample buys run from June to November across a stock, a global and a bond fund; replace them and rename the funds in the dropdown.

Useful for

  • Find the true average cost of a fund bought monthly
  • Compare your average cost with the plain average price
  • Check how much you invested each month across funds

What's included

  • 4 tabs: Buys, Average Cost, Summary, How to use
  • Buys: a table
  • Average Cost: a table
  • Summary: a dashboard with 4 summary figures
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Buys tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I calculate average cost per share?

Divide the total dollars invested by the total shares owned. With equal monthly amounts, this is lower than the plain average of the prices whenever more shares were bought at lower prices.

What is dollar cost averaging?

It means investing a fixed amount at regular times instead of one lump sum. It spreads out the prices you pay but does not guarantee a gain or protect against loss.

Does this sheet track fees and taxes?

Not separately. Add any fee to the amount invested if you want it to count in the average cost, and keep official statements for tax records.

  • #investment-tracker
  • #dollar-cost-averaging-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More investment tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…