Spotcrm may be more practical than a cryptocurrency template if you want to track each position from purchase to closing. Free access supports up to five active cryptocurrencies, with transactions and calculations in one web record.

Selling changes your portfolio too

After several DCA purchases, a partial sale changes the units you still hold and their remaining cost. Spotcrm records the sale, calculates its realised gain and preserves the average purchase price of the remaining units.

Fictional example, excluding fees: you buy two units at 10 USDT each and sell one at 12 USDT. You receive 12 USDT, but the gain is 2 USDT. You retain one unit with a cost and average purchase price of 10 USDT.

Close without erasing the history

Once the quantity reaches zero and there are no pending orders, you can archive the position. Its history remains available, separate from active positions. You keep the purchases and sales that explain the result.

Excel provides [tables with formulas and filters]. A template can meet these needs if designed for them; in Spotcrm, tracking purchases, sales and closed positions is already part of the system.

If you prefer to manage your spot trading without building that process in a spreadsheet, you can start free. This example is not investment advice.

In just one click, you can try our system.

Try free Spotcrm ↗