Home › Templates › Crypto trading journal

Crypto Trading Journal Template

A free crypto trading journal for Excel and Google Sheets that logs spot and perpetual futures trades, subtracts maker/taker fees and adds or subtracts funding, and shows net P/L in your quote currency, R-multiple and return on margin. A summary tab measures your win rate, expectancy, average R, fees as a share of gross P/L and funding totals, by pair, setup and month, with an equity curve.

Download Excel template (.xlsx) 628 KB · no macros · Excel 2016+, Google Sheets and LibreOffice · v1.0, 30 Oct 2026

Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no add-on, no exchange connection or API key.

Preview: the first 10 rows of the Example Journal tab (30 fictional trades on made-up "Exchange A/B/C", August to October 2026, 10,000 USDT start). Prices are illustrative, not real market quotes; fee rates and funding are invented. Amounts in USDT.
Closed (UTC)PairMarketSideLev.SizeEntryExitFeesFundingNet P/LROn margin
04 Aug 15:15BTC/USDTPerpLong5x0.0909112,000114,2007.17−3.05189.76+1.90R9.3%
05 Aug 20:40ETH/USDTSpotLong–1.254,1004,02010.15–−110.15−1.10R−2.1%
07 Aug 22:10SOL/USDTPerpShort3x25195.00186.201.910.98219.07+2.19R13.5%
10 Aug 20:30BTC/USDTPerpLong10x0.1429114,500113,70016.300.00−130.62−1.31R−8.0%
14 Aug 12:20ETH/USDTSpotLong–0.8334,1804,47018.01–223.56+2.24R6.4%
15 Aug 07:05XRP/USDTPerpShort5x1,4293.053.124.41−0.22−104.66−1.05R−12.0%
19 Aug 12:00BTC/USDTPerpShort5x0.0909116,200114,1004.193.17189.87+1.90R9.0%
20 Aug 16:45SOL/USDTPerpLong10x40201.00198.007.98−0.80−128.78−1.29R−16.0%
21 Aug 19:00SOL/USDTPerpLong15x50199.00197.009.900.00−109.90−1.10R−16.6%
26 Aug 23:30ETH/USDTPerpLong3x14,2504,4801.75−2.12226.13+2.26R16.0%
Example Journal: balance after each of 30 fictional trades, from 10,000.00 to 11,530.09 USDT; deepest drawdown −238.68 USDT10,00010,50011,00011,500051015202530Trade # (Aug to Oct 2026, fictional; balance in USDT)deepest drawdown: −238.68 USDT after trade 9

Chart: balance after each closed trade, from the same tab. The workbook draws this equity curve as a native chart on the Summary tab.

Tracking holdings or taxes, not trades? For long-term coins use the crypto portfolio tracker. For cost basis and gains by tax year use the crypto tax spreadsheet. For stocks and other markets the general trading journal template fits better.

What's inside the spreadsheet

TabWhat you typeWhat it calculates
Start hereNothingSteps, definitions, fee and funding notes, colour key, limits, disclaimer
JournalStarting balance and quote currency once, then one row per closed trade (1,000 rows)Entry value, margin used, gross P/L, fees, net P/L, risk to stop, R-multiple, planned reward:risk, return on margin, trade #, month, balance, drawdown, result
SummaryNothing21 totals (win rate, expectancy, average R, profit factor, fees as % of gross, funding received and paid, max drawdown); tables by pair, setup, market, mistake tag and month (36 months); equity curve and net P/L by setup chart
Example Journal / Example SummaryAlready filled30 fictional trades so you can see every formula working
ListsOptional edits10 pairs, market, side, 6 setups and 8 mistake tags for the dropdowns

The crypto fields

FieldWhy it is there
Open and close time (UTC)Crypto trades around the clock. One time zone avoids month and day mix-ups, and funding times are usually set in UTC.
Exchange, pairFree text and a pair dropdown (BASE/QUOTE). Results can be grouped by pair. You can type a pair that is not listed.
Market (Spot / Perp), sideSpot or perpetual futures, long or short. Gross P/L flips sign for shorts.
LeveragePerps only. Sets margin used and return on margin. Leave blank for spot (margin = the full position value).
Size (coin units)Amount of the base coin, e.g. 0.0909 BTC. Not contracts and not dollars.
Entry, stop, target, exitStop gives risk and R-multiple; target gives the planned reward:risk.
Entry fee %, exit fee %The maker or taker rate charged on each fill, copied from your trade history. A maker rebate is a negative rate.
Funding (+/−)Perps only. The total funding for the position from your funding history: positive if received, negative if paid.
Setup, mistake tag, notesDropdowns so the Summary can group results. Use "None" for a clean trade.

How to use it

  1. On Journal, type your starting balance in C3 and your quote currency in C4 (for example USDT). Keep one quote currency per copy; the sheet does not convert USD, USDT or USDC.
  2. When a trade closes, add a row: open and close time in UTC, exchange, pair, Spot or Perp, Long or Short, leverage for perps, size in coins, entry, stop, target and exit price.
  3. Open your exchange's trade history. Type the fee rate on the entry fill and on the exit fill (maker or taker).
  4. For perps, open the funding history, add up the funding for that position and type the total with its sign.
  5. Pick a setup and a mistake tag. Leave the grey columns alone: they fill in gross P/L, fees, net P/L, R-multiple, return on margin and the balance.
  6. Once a week or month, read Summary: what fees and funding cost, which pairs and setups made or lost money, and how the equity curve moved.

Closed part of a position? Log each partial close as its own row with the size that was closed, so each row has one exit price.

Fees and funding: how exchanges charge them

Maker and taker fees

Most exchanges charge a percentage of each fill. Coinbase's help page on Coinbase Advanced fees explains: "Orders that provide liquidity (maker orders) are charged different fees than orders that take liquidity (taker orders)." A resting limit order is usually a maker fill; a market order is a taker fill.

Kraken's help article "How trading fees work on Kraken" (last updated October 1, 2026) says its fee "ranges from -0.02% (maker) to 0.80% (taker) of the total cost (value) of the order" and depends on your 30-day volume, the pair and whether the order is maker or taker. Its worked example: an order worth $10,000 at a 0.25% taker rate costs "$10,000 x (0.25 / 100) = $25". The journal uses the same arithmetic on both sides of the trade:

Fees = size × entry price × entry fee %  +  size × exit price × exit fee %

Fee rates change with your volume tier, the market (spot or futures) and any discounts, so the template asks you to type the rate from your own fills rather than looking it up.

Funding on perpetual futures

A perpetual contract has no expiry date. The US Commodity Futures Trading Commission's one-page explainer "Crypto Asset Perpetual Contracts" describes the funding rate as "a periodic payment between the long and short sides of the contract" and says: "When a perpetual contract trades above the spot price, the traders with long positions make payments while the traders with short positions receive payments; and vice versa."

Binance's "Introduction to Binance Futures Funding Rates" gives the formula "Funding Amount = Nominal Value of Positions * Funding Rate" and says: "The default funding interval is every 8 hours at 00:00 (UTC), 08:00 (UTC), and 16:00 (UTC)." It adds: "If you close your position prior to the funding time, you will not pay or receive any funding." Other exchanges can use other intervals, so check the contract you trade.

The journal does not estimate funding. Rates change every interval and are applied to the position value at that time, so you type the total from your funding history.

CostSpotPerpetual futuresSign in the journal
Trading fee (maker/taker)Yes, on each fillYes, on each fillRate typed as positive; a rebate as negative
FundingNoYes, at each funding time while the position is open+ received, − paid

The formulas, explained

Exact formulas from the file, row 7 of Journal. Columns: F Long/Short, G leverage, H size, I entry, J stop, K target, L exit, M entry fee %, N exit fee %, O funding. C3 = starting balance.

FieldFormula
Entry value (S)=IF(OR(H7="",I7=""),"",H7*I7)
Margin used (T)=IF(S7="","",IF(N(G7)>0,S7/G7,S7))
Gross P/L (U)=IF(OR(H7="",I7="",L7=""),"",(L7-I7)*H7*IF(F7="Short",-1,1))
Fees (V)=IF(U7="","",S7*N(M7)+L7*H7*N(N7))
Net P/L (W)=IF(U7="","",U7-V7+N(O7))
Risk to stop (X)=IF(OR(H7="",I7="",J7=""),"",ABS(I7-J7)*H7)
R-multiple (Y)=IF(OR(W7="",N(X7)=0),"",W7/X7)
Planned reward : risk (Z)=IF(OR(I7="",J7="",K7=""),"",IF(I7=J7,"",ABS(K7-I7)/ABS(I7-J7)))
Return on margin (AA)=IF(OR(W7="",N(T7)=0),"",W7/T7)
Balance after trade (AD)=IF(W7="","",N($C$3)+SUM($W$7:W7))
Summary: funding paid (B11)=SUMIFS(Journal!$O$7:$O$1006,Journal!$AB$7:$AB$1006,">0",Journal!$O$7:$O$1006,"<0")
Summary: fees as % of gross P/L (B14)=IF(B4=0,"",IF(B8<=0,"gross P/L not above 0",B9/B8))
Summary: expectancy per trade (B18)=IF(B4=0,"",B5/B4*N(B16)+B6/B4*N(B17))
Summary: average R (B19)=IF(COUNT(Journal!$Y$7:$Y$1006)=0,"",AVERAGE(Journal!$Y$7:$Y$1006))
Summary: net P/L for one pair (D38)=SUMIFS(Journal!$W$7:$W$1006,Journal!$D$7:$D$1006,$A38)
Summary: next month (I39)=IF(I38="","",IF(EDATE(I38,1)>MAX(Journal!$AC$7:$AC$1006),"",EDATE(I38,1)))

N() turns a blank cell into 0, so a spot trade with no funding and no leverage still calculates. R-multiple uses net P/L after fees and funding, divided by the price risk to your planned stop. The balance uses a range that grows row by row ($W$7:W7, then $W$7:W8 …), so log trades in the order they closed. Expectancy on Summary is win rate × average win + loss rate × average loss: the average net P/L of the trades you logged.

Worked example from the sample data

Trade 1: a BTC/USDT perp long at 5x

When fees and funding change the result

The 30 trades together

30closed trades (Aug–Oct 2026)
53.3%win rate (16 of 30)
1,530.09net P/L, USDT
303.11trading fees, USDT (16.3% of gross P/L)
−21.43funding net, USDT (11.38 received, −32.81 paid)
51.00expectancy per trade (measured), USDT
+0.51Raverage R per trade
−238.68max drawdown (trade by trade), USDT

Spot and perp trades side by side. In this sample, spot fees were 24% of spot gross P/L and perp fees 11% of perp gross P/L, because the fictional spot rates are higher:

MarketTradesWin rateNet P/LFeesFundingAvg R
Spot862%574.70177.370.00+0.72R
Perp2250%955.40125.73−21.43+0.43R
SetupTradesWin rateNet P/LFeesFundingAvg R
Breakout825%−372.96130.54−4.27−0.47R
Pullback771%490.5076.00−15.89+0.70R
Range fade333%88.0312.671.65+0.29R
Trend continuation6100%1,383.0151.56−11.10+2.31R
Reversal367%258.0815.597.87+0.86R
News30%−316.5716.750.31−1.05R
Mistake tagTradesWin rateNet P/LFeesFundingAvg R
None2070%2,265.53167.83−9.72+1.13R
Moved stop10%−128.787.98−0.80−1.29R
Chased entry20%−238.1623.820.00−1.19R
Too much leverage20%−241.1632.030.88−1.21R
Revenge trade10%−109.909.900.00−1.10R
Exited early367%98.2357.21−0.53+0.33R
Ignored funding10%−115.674.33−11.26−1.16R
Month (close)TradesWin rateGross P/LFeesFundingNet P/LBalance at month end
Aug 20261155%623.06129.01−2.04492.0110,492.01
Sep 20261155%599.9894.24−1.20504.5410,996.55
Oct 2026850%631.5979.85−18.19533.5511,530.09

In this fictional sample, breakout and news trades lost money and every mistake tag except "Exited early" had a negative total. 30 trades are far too few to rely on. Win rate, expectancy and average R describe the rows already logged; they are not a forecast. Read tables like these as questions to check over months of your own data.

Common mistakes

Before you trade crypto or crypto derivatives

The UK Financial Conduct Authority reminds consumers (last updated 6 February 2026): "if you buy cryptoassets you should be prepared to lose all the money you invest." In October 2020 the FCA published rules banning "the sale, marketing and distribution to all retail consumers of any derivatives (ie contract for difference – CFDs, options and futures) and ETNs that reference unregulated transferable cryptoassets by firms acting in, or from, the UK." Check the FCA website for the rules in force when you trade.

The SEC's investor alert "Exercise Caution with Crypto Asset Securities" (March 23, 2023) says such investments "can be exceptionally volatile and speculative, and the platforms where investors buy, sell, borrow, or lend these securities may lack important protections for investors."

Leverage and liquidation. The CFTC's perpetuals explainer lists best practices for traders, including: "Understand how leverage and margin requirements affect liquidations and liquidation thresholds", "Actively monitor open positions" and "Never risk more than you can afford to lose." It also says: "Only trade on CFTC-registered exchanges." This journal records results after a trade closes. It does not calculate liquidation prices or warn you in real time.

FAQ

What should a crypto trading journal include?

For each closed trade: open and close time in UTC, exchange, pair, spot or perpetual futures, long or short, leverage, size in coins, entry, stop, target and exit price, the fee rate on each side, funding for perps, setup, a mistake tag and notes. From those, a journal can work out gross P/L, fees, net P/L, R-multiple, return on margin and a running balance, then group results by pair, setup and month.

How do you calculate fees on a crypto trade?

Multiply the value of each fill by the fee rate for that fill, then add the entry and exit sides. Kraken's help page gives the example of a $10,000 order at a 0.25% taker rate: $10,000 x (0.25 / 100) = $25. In the template, entry fee = size x entry price x entry fee %, and exit fee = size x exit price x exit fee %.

How does the funding rate affect profit on a perpetual futures trade?

Funding is a periodic payment between longs and shorts. Binance gives the formula Funding Amount = Nominal Value of Positions * Funding Rate, with a default interval of every 8 hours. A long pays when the rate is positive and receives when it is negative. In the example, a BTC/USDT long held for 4 days paid 11.26 USDT in funding, on top of 4.33 USDT of trading fees.

What is a good win rate for crypto trading?

There is no win rate that is good on its own. Win rate only means something together with the size of the average win and the average loss. In the fictional example, a 53.3% win rate came with an average win of 187.73 USDT and an average loss of −105.26 USDT. The journal measures these numbers for your own trades; it does not predict them.

How do you calculate return on margin with leverage?

Margin used is the position value divided by the leverage. Return on margin is net P/L divided by that margin. At 5x, a 1% move in your favour is about 5% on margin, and a 1% move against you is about 5% off it. In the example, trade 1 made 189.76 USDT on 2,036.16 USDT of margin, a 9.3% return on margin, but only 1.90% of the account.

Can I use this crypto trading journal in Google Sheets?

Yes. In Google Sheets choose File → Import → Upload and pick the .xlsx, or upload it to Drive and open it with Google Sheets. The formulas use functions that exist in Excel 2016+, Google Sheets and LibreOffice (SUMIFS, COUNTIFS, AVERAGEIF, SUMPRODUCT, EDATE).

Related tools and templates

Educational template only, not financial, tax or investment advice. Crypto trading is high risk; with leveraged derivatives you can lose your whole margin quickly, and crypto derivatives may not be available to retail consumers where you live. Example data is fictional: "Exchange A/B/C", all prices, fee rates, funding amounts and results are made up, and prices are illustrative, not real market quotes. Exchange and regulator material was retrieved on 30 October 2026.