Home › Templates › Futures trading journal
Futures Trading Journal Template
A free futures trading journal for Excel and Google Sheets. Pick the contract and type entry, exit, stop and fees: the sheet turns the move into ticks and dollars with each contract's tick value, then reports net P&L, R-multiple, win rate, profit factor, expectancy, max drawdown and an equity curve.
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 and no broker connection: you type each trade yourself.
| # | Entry | Symbol | Side | Qty | Entry | Exit | Stop | Ticks | Gross | Fees | Net | R |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 01 Oct 09:42 | MES | Long | 2 | 6,000.00 | 6,003.00 | 5,998.00 | 12 | $30.00 | $2.00 | $28.00 | 1.40 |
| 2 | 01 Oct 11:05 | MES | Short | 2 | 6,008.50 | 6,010.50 | 6,010.50 | -8 | −$20.00 | $2.00 | −$22.00 | -1.10 |
| 3 | 02 Oct 09:35 | ES | Long | 1 | 6,015.25 | 6,013.25 | 6,013.25 | -8 | −$100.00 | $3.00 | −$103.00 | -1.03 |
| 4 | 02 Oct 10:30 | MNQ | Long | 3 | 21,050.00 | 21,057.50 | 21,045.00 | 30 | $45.00 | $3.00 | $42.00 | 1.40 |
| 5 | 04 Oct 18:30 | GC | Long | 1 | 2,500.0 | 2,499.0 | 2,499.0 | -10 | −$100.00 | $3.00 | −$103.00 | -1.03 |
| 6 | 05 Oct 09:50 | CL | Short | 1 | 65.40 | 65.22 | 65.55 | 18 | $180.00 | $3.00 | $177.00 | 1.18 |
| 7 | 05 Oct 13:15 | MCL | Short | 2 | 65.10 | 65.25 | 65.25 | -15 | −$30.00 | $2.00 | −$32.00 | -1.07 |
| 8 | 06 Oct 08:20 | 6E | Long | 1 | 1.10000 | 1.10070 | 1.09950 | 14 | $87.50 | $3.00 | $84.50 | 1.35 |
| 9 | 06 Oct 10:05 | NQ | Short | 1 | 21,120.00 | 21,124.00 | 21,124.00 | -16 | −$80.00 | $3.00 | −$83.00 | -1.04 |
| 10 | 07 Oct 09:33 | ES | Short | 1 | 6,030.00 | 6,026.00 | 6,032.00 | 16 | $200.00 | $3.00 | $197.00 | 1.97 |
What's inside the spreadsheet
| Tab | What you type | What it calculates |
|---|---|---|
| Start here | Nothing | Steps, the maths, colour key, leverage warning with CFTC and NFA quotes, limits, disclaimer |
| Contracts | Optional edits: 10 CME Group contracts are pre-filled; 20 empty rows for your own | Point value (tick value ÷ tick size). Source URL and check date on every pre-filled row |
| Journal | One row per closed trade (500 rows): entry and exit date/time, symbol (dropdown), Long/Short, contracts, entry, exit, stop, target, fees per contract per side, setup, session, notes | Ticks, points, gross P&L, fees, net P&L, initial risk $, R-multiple, planned reward:risk, holding time, weekday, result, cumulative P&L, drawdown and a row check |
| Summary | Nothing | 22 totals (net P&L, win rate, average win and loss, profit factor, expectancy in $ and R, max drawdown and more), tables by symbol, setup, weekday and session, equity curve chart |
| Example Journal, Example Summary | Already filled | 30 fictional trades across all 10 contracts, so you can see every formula working |
| Lists | Optional edits | Setup and session names for the dropdowns |
Other BeCoin journals cover different jobs: the general trading journal tracks emotions and rule breaks, the day trading journal adds daily loss limits, and the forex trading journal counts pips and lots. This one is built around futures contract specs: ticks, tick value and per-side fees.
Pre-filled contract specs (CME Group)
Each row was checked on 1 Nov 2026 against the exchange's own rulebook chapter or contract-spec page; the link and date are also in the workbook. Point value is the dollar change for a 1.00 move in the quoted price, per contract.
| Symbol | Contract | Exchange | Tick size | Tick value | Point value | Source |
|---|---|---|---|---|---|---|
| ES | E-mini S&P 500 | CME | 0.25 | $12.50 | $50 | CME Group |
| MES | Micro E-mini S&P 500 | CME | 0.25 | $1.25 | $5 | CME Group |
| NQ | E-mini Nasdaq-100 | CME | 0.25 | $5.00 | $20 | CME Group |
| MNQ | Micro E-mini Nasdaq-100 | CME | 0.25 | $0.50 | $2 | CME Group |
| CL | Light Sweet Crude Oil (WTI) | NYMEX | 0.01 | $10.00 | $1,000 | CME Group |
| MCL | Micro WTI Crude Oil | NYMEX | 0.01 | $1.00 | $100 | CME Group |
| GC | Gold | COMEX | 0.10 | $10.00 | $100 | CME Group |
| MGC | Micro Gold | COMEX | 0.10 | $1.00 | $10 | CME Group |
| 6E | Euro FX (EUR/USD) | CME | 0.00005 | $6.25 | $125,000 | CME Group |
| ZN | 10-Year U.S. Treasury Note | CBOT | 0.015625 (½ of 1/32) | $15.625 | $1,000 | CME Group |
Specs can change. Exchanges amend contract rules from time to time. Check the exchange page before you rely on a number, and edit the yellow cells if anything differs. Margin is deliberately not in the sheet: it is set by the exchange and your broker and changes often.
Treasury prices: ZN trades in 32nds and half-32nds of a point. Type decimal prices: 110'16 = 110.5 and 110'16.5 = 110.515625. One tick (½ of 1/32) is 0.015625 points = $15.625.
How to use it
- Open Contracts. Confirm the tick size and tick value of each contract you trade. Add any other contract in an empty row (symbol, tick size, tick value).
- Open Lists and rename the setups and sessions to match your own plan.
- After each trade closes, add a row on Journal: dates and times, symbol, Long or Short, contracts, entry, exit, stop, target, your fee per contract per side, setup and session. Keep rows in the order trades closed.
- Read column AF (Check). It flags an unknown symbol, a price that is not on the tick grid, a missing direction and a stop on the wrong side of the entry.
- Open Summary for the totals, the tables by symbol, setup, weekday and session, and the equity curve.
- Once a week, compare the setups and sessions: which have a positive average R over enough trades to mean something, and which do not.
Use the position size calculator before the trade to pick the number of contracts for your stop; the journal measures what happened after.
Ticks, points and tick value
A futures price moves in fixed steps called ticks. The exchange sets the tick size (for ES, 0.25 index points) and what one tick is worth per contract (for ES, $12.50). The journal works in ticks so one formula handles every market:
- Points = exit − entry, with the sign flipped for a short.
- Ticks = points ÷ tick size.
- Gross P&L = ticks × tick value × contracts.
- Fees = fee per contract per side × 2 sides × contracts.
- Net P&L = gross P&L − fees.
Micro contracts use the same tick size as their full-size version but a tenth of the value: MES ticks are $1.25 against $12.50 for ES; MNQ ticks are $0.50 against $5.00 for NQ. A 10-tick move on one ES contract is $125.00; on one MES it is $12.50.
The formulas, explained
Exact formulas from the file, row 6 of the Journal (A–D dates and times, E symbol, F direction, G contracts, H entry, I exit, J stop, K target, L fee per contract per side). Contracts rows 6–35 hold the specs; the Journal reads rows 6 to 505.
| Field | Formula |
|---|---|
| Tick size (P) | =IF(E6="","",IFERROR(INDEX(Contracts!$D$6:$D$35,MATCH(E6,Contracts!$A$6:$A$35,0)),"")) |
| Tick value (Q) | =IF(E6="","",IFERROR(INDEX(Contracts!$E$6:$E$35,MATCH(E6,Contracts!$A$6:$A$35,0)),"")) |
| Points (R) | =IF(OR(N(P6)<=0,N(Q6)<=0,AND(F6<>"Long",F6<>"Short"),NOT(ISNUMBER(H6)),NOT(ISNUMBER(I6)),N(G6)<=0),"",(I6-H6)*IF(F6="Short",-1,1)) |
| Ticks (S) | =IF(R6="","",ROUND(R6/P6,2)) |
| Gross P&L (T) | =IF(R6="","",S6*Q6*G6) |
| Fees total (U) | =IF(R6="","",N(L6)*2*G6) |
| Net P&L (V) | =IF(R6="","",T6-U6) |
| Initial risk $ (W) | =IF(OR(R6="",NOT(ISNUMBER(J6))),"",IF(OR(AND(F6="Long",J6>=H6),AND(F6="Short",J6<=H6)),"",ROUND(ABS(H6-J6)/P6,2)*Q6*G6)) |
| R-multiple (X) | =IF(OR(W6="",V6=""),"",V6/W6) |
| Holding time, minutes (Z) | =IF(OR(R6="",NOT(ISNUMBER(A6)),NOT(ISNUMBER(B6)),NOT(ISNUMBER(D6))),"",ROUND((IF(ISNUMBER(C6),C6,A6)+D6-A6-B6)*1440,0)) |
| Cumulative net (AC) | =IF(R6="","",SUM($V$6:V6)) |
| Running peak (AD) | =IF(R6="","",MAX(0,MAX($AC$6:AC6))) |
| Drawdown (AE) | =IF(R6="","",AC6-AD6) |
| Summary: win rate | =IF(B5=0,"",B6/B5) |
| Summary: profit factor | =IF(B14=0,"",B13/-B14) |
| Summary: expectancy ($) | =IF(B5=0,"",B12/B5) |
| Summary: expectancy (R) | =IF(B19=0,"",AVERAGE('Journal'!$X$6:$X$505)) |
| Summary: max drawdown | =IF(B5=0,"",-MIN('Journal'!$AE$6:$AE$505)) |
| Summary: net P&L by symbol | =IF(A31="","",SUMIFS('Journal'!$V$6:$V$505,'Journal'!$E$6:$E$505,A31)) |
ROUND(…,2) on ticks removes floating-point noise (0.18 ÷ 0.01 can come out as 17.9999…). A short flips the sign of points through IF(F6="Short",-1,1). Initial risk ignores fees, so a trade that ends exactly at its stop shows an R slightly below −1.00. Profit factor and expectancy use net P&L, after fees.
Worked example from the sample data
The Example tabs hold 30 fictional trades from 1 to 22 Oct 2026. Prices and fees are made up to show the maths.
Trade 1: long 2 MES
Entry 6,000.00, exit 6,003.00, stop 5,998.00. Points = 3.00; ticks = 3.00 ÷ 0.25 = 12. Gross = 12 × $1.25 × 2 = $30.00. Fees = $0.50 × 2 × 2 = $2.00, so net = $28.00. Risk = 8 ticks × $1.25 × 2 = $20.00, so R = 28 ÷ 20 = 1.40.
Trade 10: short 1 ES
Entry 6,030.00, exit 6,026.00. Points = (6,026 − 6,030) × −1 = 4.00 = 16 ticks. Gross = 16 × $12.50 = $200.00; fees $3.00; net $197.00. The stop was 2 points (8 ticks, $100.00) away, so R = 1.97.
Trade 12: long 1 ZN
Entry 110.5 (110'16), exit 110.59375 (110'19). Points = 0.09375 = 6 ticks of 0.015625. Gross = 6 × $15.625 = $93.75; fees $3.00; net $90.75. Risk 4 ticks = $62.50, so R = 1.45.
Trade 15: a scratch is still a loss
Long 1 ES, out at the entry price: 0 ticks, $0.00 gross, −$3.00 after fees. The sheet counts it as a loss, which is why fees matter for win rate.
Drawdown
Cumulative net P&L peaked at $344.25 after trade 13, then fell to −$118.25 after trade 21 (seven losses in eight trades, including a 2-contract ES stop for −$206.00). The drop of $462.50 is the max drawdown. The sample ends at $179.75 net: 15 wins, 15 losses, average win $83.55, average loss −$71.57, profit factor 1.17, expectancy $5.99 or 0.13R per trade (29 trades had a stop; trade 19 had none, so it has no R).
By symbol
| Symbol | Trades | Win rate | Net P&L | Avg / trade | Avg R | Profit factor |
|---|---|---|---|---|---|---|
| ES | 5 | 40% | $32.00 | $6.40 | 0.27 | 1.10 |
| MES | 5 | 40% | −$28.00 | −$5.60 | -0.14 | 0.58 |
| NQ | 3 | 33% | −$69.00 | −$23.00 | -0.30 | 0.63 |
| MNQ | 4 | 75% | $56.00 | $14.00 | 0.40 | 3.55 |
| CL | 3 | 67% | $101.00 | $33.67 | 0.16 | 1.82 |
| MCL | 2 | 50% | $40.00 | $20.00 | 0.27 | 2.25 |
| GC | 2 | 50% | $44.00 | $22.00 | 0.22 | 1.43 |
| MGC | 2 | 50% | $25.00 | $12.50 | 0.10 | 1.78 |
| 6E | 2 | 50% | $19.00 | $9.50 | 0.15 | 1.29 |
| ZN | 2 | 50% | −$40.25 | −$20.12 | 0.20 | 0.69 |
By weekday
| Weekday | Trades | Win rate | Net P&L | Avg / trade | Avg R | Profit factor |
|---|---|---|---|---|---|---|
| Mon | 6 | 33% | −$67.00 | −$11.17 | -0.45 | 0.77 |
| Tue | 5 | 40% | $29.50 | $5.90 | 0.21 | 1.23 |
| Wed | 5 | 60% | $83.50 | $16.70 | 0.32 | 1.31 |
| Thu | 7 | 86% | $336.75 | $48.11 | 0.83 | 16.31 |
| Fri | 6 | 33% | −$100.00 | −$16.67 | -0.11 | 0.61 |
| Sun | 1 | 0% | −$103.00 | −$103.00 | -1.03 | 0.00 |
The Sunday row is the fictional GC trade entered on a Sunday evening and stopped overnight. With two to seven trades per group, none of these differences means anything yet: a group needs many more trades before a pattern is worth acting on.
Leverage and margin: read this before trading futures
A futures contract controls far more value than the margin posted for it. With a point value of $50, one ES contract gains or loses $1,000 on a 20-point move, whatever margin the broker holds. That is why the journal records risk in dollars and in R.
The CFTC's Basics of Futures Trading page warns that "Speculating in commodity futures and options is a volatile, complex and risky venture that is rarely suitable for individual investors or “retail customers”" and that "Many individuals lose all of their money, and can be required to pay more than they invested initially".
NFA's Investor Best Practices adds: "because of the leverage involved in futures, the profit and loss fluctuations may be wider than in most types of investment activity and you may be required to cover deficiencies due to losses over and above what you had expected to commit to futures."
To see how leverage scales a move, try the leverage P&L calculator. To check the reward against the risk before entry, use the risk/reward calculator.
Common mistakes
- Using a stock-style P&L. (exit − entry) × contracts is wrong for futures. Multiply by the point value, or count ticks × tick value.
- Typing Treasury prices in 32nds. 110.16 is not 110'16. Convert to decimals (110.5).
- Round-turn fees typed as per side. The fee column is per contract, per side; the sheet doubles it. If your statement shows a round-turn cost, type half of it.
- Mixing micros and minis. MES and ES share a price but not a tick value. Pick the right symbol from the dropdown.
- Moving the stop, then logging the new one. R only means something if the stop is the one you had at entry.
- Sorting the Journal by symbol. Drawdown and the equity curve follow row order. Keep rows in the order trades closed.
Limits
- One row = one entry and one exit. For scale-ins or partial exits, use average prices or split the trade into rows.
- All P&L is in US dollars (every pre-filled contract is USD). No currency conversion.
- No margin, account balance or contract-roll tracking; fees are what you type.
- Weekday uses the entry date as typed, in your own time zone.
- Session names are your labels, not exchange hours.
FAQ
What should a futures trading journal include?
At minimum: date and time, contract symbol, long or short, number of contracts, entry, exit, stop, fees, and the setup you traded. Futures add one thing a stock journal does not need: each contract's tick size and tick value, because P&L is counted in ticks. This template keeps those specs on a Contracts tab and adds R-multiple, holding time and session so you can compare trades of different sizes and markets.
How do you calculate profit and loss on a futures trade?
Count the ticks the price moved in your favour, multiply by the tick value and by the number of contracts, then subtract fees. Example from the sample data: long 2 MES from 6,000.00 to 6,003.00 is 12 ticks; 12 × $1.25 × 2 = $30.00 gross, minus $2.00 of fees (0.50 per contract per side) = $28.00 net.
What is the tick value of ES and MES futures?
CME Group's rulebook sets the E-mini S&P 500 (ES) at $50 times the index with a minimum increment of 0.25 index points, equal to $12.50 per contract. The Micro E-mini S&P 500 (MES) is $5 times the index, so the same 0.25-point tick is $1.25. Specs can change, so check the exchange before trading.
How do you calculate the R-multiple of a futures trade?
Divide the trade's net P&L by the initial risk. Initial risk is the distance from entry to stop in ticks × tick value × contracts. A long 1 ZN trade in the example risked 4 ticks × $15.625 = $62.50 and made $90.75 after fees, so R = 90.75 ÷ 62.50 = 1.45.
Can you lose more than you invest in futures?
Yes. The CFTC's Basics of Futures Trading page says: "Many individuals lose all of their money, and can be required to pay more than they invested initially". Margin is only a deposit; losses are not capped at it.
Can I use this futures trading journal in Google Sheets?
Yes. In Google Sheets choose File → Import → Upload and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. The formulas use INDEX, MATCH, SUMIFS, COUNTIFS, AVERAGEIFS, ROUND and IF, which work in Excel 2016+, Google Sheets and LibreOffice. There are no macros.
Related tools and templates
- Position size calculatorContracts for a given stop and risk
- Risk/reward calculatorReward vs risk before entry
- Leverage P&L calculatorHow leverage scales a move
- Trading journal templateEmotions and rule breaks
- Day trading journalDaily loss limits
- Forex trading journalPips, lots and pairs
- Trading performance reportMonthly results
- All templatesFree spreadsheets
Educational template only, not financial advice. Futures trading involves leverage and can lose more than the money deposited. Example data is fictional: the trades, prices and fees are made up to show the formulas and are not market data, real results or a recommendation. Contract specs, CFTC and NFA material were retrieved on 1 November 2026.