Posted on 1 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

Donations are highly appreciated:
EOS: binancecleos / 103607768
Algorand: 2UIBSLSJ7Y76USGUENEBQRSVGKVUKODN3NJATMKBM2WFRRTU5J3GZXXKME
ETH: 0xbf23688560b2bc0a786b5b9e4e9668bb578b7ed8

Have a great day!

1 thought on “Dollar Cost Averaging Excel Sheet

  1. Thank you – I needed just a simple one, this is perfect!

Leave a Reply