Posted on Leave a comment

Dollar Cost Averaging Excel Sheet

This is a simple Excel dollar cost averaging table, handy for crypto trading and stuff. Feel free to use it if you find it helpful.

Enter the unit quantity (BTC, Dollars, etc) and the cost per unit. At the bottom the table will calculate your average unit cost, as well as total units and total cost.

The bottom four rows will calculate a recommended minimum sell price assuming 1% fees, you can modify the formula to any % fees. You can modify the “Example Sell Price” field to see potential gains or losses.

Dollar Cost Averaging Template

Leave a Reply