This is a simple Excel dollar cost averaging table for managing crypto and other trades, feel free to use it if you find it helpful.
You can use this table to track your trades, and it will automatically calculate your average purchase price as well as minimum sale price in order to take profit.
Enter your tokens in the left column, followed by the quantity you purchased and the cost per unit.
The table will calculate your total purchase price and DCA, outputting everything at the bottom right.
You can easily modify the formulas to adjust fee percentages, etc.