| Date | Asset | Side | Quantity | Price / Unit | Fee | Fee % | |
|---|---|---|---|---|---|---|---|
| Fee is in quote currency. Fee % applies to notional. | |||||||
| Date | Asset | Side | Quantity | Price/Unit | Fee | Fee % |
|---|---|---|---|---|---|---|
| 2025-09-01 | BTC | Buy | 0.005 | 60000 | 2 | 0.05 |
| 2025-09-10 | BTC | Buy | 0.003 | 58000 | 1.5 | 0.05 |
| 2025-10-01 | BTC | Sell | 0.002 | 62000 | 2 | 0.05 |
| 2025-10-15 | ETH | Buy | 0.5 | 2300 | 0.8 | 0.10 |
| 2025-10-20 | ETH | Buy | 0.25 | 2400 | 0.6 | 0.10 |
Weighted average buy price (per asset):
WABP = (Σ (qty × price) + fees_included) ÷ Σ qty
Where Σ qty and Σ (qty × price) include only Buy rows. If “Include fees in cost” is Yes, we add flat fee plus fee%×(qty×price).
Simple average price (prices of Buy rows only): SAP = (Σ price) ÷ n
Break-even price with sell fee for remaining holdings:
BreakEven = RemainingCost ÷ ((1 − sell_fee%) × RemainingQty)
After Sells, remaining cost = WABP_before_sells × RemainingQty (average-cost method).
- Enter each trade as a separate row with quantity, price, and fees.
- Choose whether to include fees in cost basis and set expected sell fee %.
- Review per-asset summaries to see weighted and simple averages.
- Export your table and summaries as CSV or PDF for records.
What is the crypto average price?
Average price summarizes multiple trade entries into a single representative cost per unit. Two common views are:
- Weighted average price: includes quantity weights and, optionally, fees in cost.
- Simple average price: arithmetic mean of buy prices, ignoring quantities.
Weighted = (Σ qty×price + fees) ÷ Σ qtySimple = (Σ price) ÷ nWorked example: BTC average price calculation
Using the example dataset (fees included in cost):
| Date | Side | Qty | Price | Fee | Fee % | Cost |
|---|---|---|---|---|---|---|
| 2025-09-01 | Buy | 0.005 | 60,000 | 2.00 | 0.05 | 302.15 |
| 2025-09-10 | Buy | 0.003 | 58,000 | 1.50 | 0.05 | 175.587 |
| Totals (buys) | 0.008 | 477.737 | ||||
- Weighted average buy price ≈
477.737 ÷ 0.008 = 59,717.125 - Simple average price =
(60,000 + 58,000) ÷ 2 = 59,000 - After selling
0.002BTC, remaining quantity =0.006.
Impact of sell fees on break‑even price
Remaining cost uses the average‑cost method. With remaining cost ≈ 358.30275 and quantity 0.006 BTC:
| Expected sell fee % | Break-even price |
|---|---|
| 0.00% | 59,717.13 |
| 0.10% | 59,776.91 |
| 0.30% | 59,896.82 |