How to keep a trading journal that actually makes you better
Most traders who journal write too much and measure too little. This guide shows the exact fields to record, a two-minute daily routine, the weekly review that finds your edge, and how to read every statistic — with a free journal that does the maths for you.
Why a trading journal is the highest-return habit in trading
Your platform remembers every order, but not why you took it, how you felt or whether you followed your plan. A journal joins the two: the numbers say what happened, your notes say why. Only together do they show which trades to repeat and which to stop.
A journal also turns vague feelings into facts. “I trade badly on Mondays” becomes a number you can check; “that setup works” becomes an expectancy with a confidence range.
Find your real edge
See which setups, hours and markets make money once fees are counted — and which only feel good.
Cut costly mistakes
Tag mistakes and the journal adds up what each one costs you. Moved stops and revenge trades usually top the list.
Size with confidence
Expectancy, drawdown and Monte Carlo tell you how much you can risk without blowing up.
Stay disciplined
Writing the plan before the open and reviewing after the close keeps you honest when the market gets loud.
What to record for every trade
The platform fills in the first fields automatically when you import. The rest takes ten seconds per trade and is where most of the insight comes from.
Instrument and direction
Symbol, long or short, size. Imported automatically.
Entry and exit
Times and prices of the round trip. Imported automatically.
Result after fees
Gross P&L, commissions, net P&L. Imported automatically.
Initial stop
The price where the trade idea was wrong. It defines your risk and your R-multiple.
Setup
The name of the pattern you traded (for example Silver Bullet, opening range breakout, VWAP reclaim).
Context
Session, trend or range day, news, higher-timeframe bias — as tags.
Mistakes
FOMO, no stop, moved stop, oversized, revenge, exited early, off plan… one tag each.
Emotion
Calm, confident, fearful, greedy, frustrated, bored. Patterns appear within weeks.
Rating
1 to 5 stars for the quality of the execution, not the result. A losing A+ trade is a good trade.
Screenshot
The chart at entry and at exit. Nothing beats seeing the trade again during the review.
The daily routine: 2 minutes before, 5 minutes after
Before the open — the plan
Bias, key levels, scheduled news, the setups you will take and the ones you will skip. Write the maximum loss for the day.
During the session — execute
Follow the plan. Do not journal mid-trade; at most, jot a word in the notes.
After the close — import
Import the day's trades from your platform in one file. Duplicates are skipped, so you can import the same file twice.
Tag and rate
Setup, mistakes, emotion and a star rating for each trade. Add the stop if your platform does not export it.
Review — one lesson
What went well, what did not, did you follow the plan? Write one thing to repeat and one thing to stop.
The weekly review that finds your edge
Once a week, filter the last 7 or 30 days and answer these questions with the reports:
- Which setup has the highest expectancy, and is it still positive after fees?
- Which mistake cost the most — and what single rule would prevent it?
- At which hours and on which days do you lose money?
- How do you trade after a loss compared with after a win?
- Do you hold losers longer than winners?
- From which trade number of the day does your performance drop?
- Is your edge statistically significant yet, or do you need more trades?
The trading statistics that matter — and how to read them
The journal computes all of these on the filtered trades. Here is what each one means and what a good value looks like.
Win rate
wins ÷ tradesMeaningless alone: 35% can be excellent with big winners, 80% can lose money. The journal shows its 95% confidence range.
Profit factor
gross profit ÷ |gross loss|Above 1 = profitable. 1.3 to 2 over hundreds of trades is solid; above 3 on few trades usually means a small sample.
Expectancy
mean(net P&L per trade)The value of one trade after fees. In R (result ÷ initial risk) it compares strategies of any size.
Payoff ratio
average win ÷ |average loss|Read it with the win rate: you need win% > 1 ÷ (1 + payoff) to break even.
Max drawdown
max(peak − equity)The deepest fall from a high. Compare it with your account and with prop firm limits.
Sharpe ratio
mean(daily P&L) ÷ σ(daily P&L) × √252Return per unit of volatility. Days without trades count as zero; above 1 is good for a discretionary trader.
Sortino ratio
mean(daily P&L) ÷ downside σ × √252Like Sharpe but only bad days count as risk — fairer for strategies with big winning days.
SQN
√min(N,100) × mean(R) ÷ σ(R)Van Tharp's quality score: below 1.6 poor, 2–2.5 average, 2.5–3 good, 3–5 excellent, above 7 check your data.
Kelly fraction
W − (1 − W) ÷ payoffThe theoretical optimal fraction of capital to risk. Real traders use a quarter to a half of it, because the inputs are uncertain.
t-statistic and p-value
t = mean ÷ (σ ÷ √N)The chance that a strategy with zero edge would have done as well. Below 0.05 means your results are unlikely to be luck.
Probabilities: Monte Carlo, risk of ruin and losing streaks
Your past trades came in one particular order. Monte Carlo simulation shuffles that luck: it builds thousands of futures by drawing your real trading days at random and shows the range of outcomes — the chance of profit, the drawdown you should expect, and the risk of hitting a loss limit.
Losing streaks are the part traders underestimate most. The table below is exact (not simulated): it gives the probability of at least one streak of losses of a given length within your next 100 trades, depending on your win rate.
| Win rate | 5 losses in a row | 8 losses in a row | 10 losses in a row |
|---|---|---|---|
| 40% win rate | 98% | 49% | 20% |
| 50% win rate | 81% | 17% | 4% |
| 60% win rate | 46% | 4% | 1% |
If your win rate is 50%, a streak of 5 losses within 100 trades is not bad luck — it is the expected case. Size so that it does not hurt.
A tagging system that scales
Keep the lists short and consistent: the reports are only as good as your tags.
Setups
ICT Silver Bullet · Turtle Soup · Opening range breakout · VWAP reclaim · Trend pullback
Context tags
Trend day · Range day · News day · London session · New York open
Mistakes
FOMO entry · No stop · Moved stop · Oversized · Revenge trade · Exited too early
Journaling a prop firm evaluation
Prop firm rules turn drawdown into a hard line. Enter your firm's rules in the Prop firm tab: account size, profit target, maximum loss (static from the start, or trailing at the end of each day), daily loss limit and consistency rule.
The journal shows the room you have left before the drawdown limit, your worst day against the daily limit and the share of your profit made on your best day. Then it simulates your next trading days from your own history to estimate the chance of passing — so you can see when to slow down.
How to export your trades from each platform
Export closed trades (or executions) as a file, then drop it into the journal's import window. The journal recognises the platform automatically.
NinjaTrader 8
- Control Center → New → Trade Performance.
- Set the From / To dates, pick your accounts with the filter, set the display unit to Currency.
- Under Display choose Trades (best: P&L, commission, MAE/MFE) or Executions, then Generate.
- Right-click the grid → Export… → save as CSV and drop it here.
MetaTrader 5
- Switch the terminal to English first (View → Languages → English) so the column names are recognised.
- Toolbox → History tab → right-click → choose the period (All History, Last 3 Months…).
- Right-click again → Report → HTML. Drop the saved .html file here.
MetaTrader 4
- Switch the terminal to English first (View → Languages → English).
- Terminal → Account History tab → right-click → choose the period.
- Right-click → Save as Report (or Save as Detailed Report). Drop the .htm file here.
Tradovate
- Account menu → gear icon → Account Reports (web app: Reports).
- Open the Performance tab (or Orders), set From / To.
- Download Report → CSV. These files carry no commissions: add them by hand if you want an exact net.
TradingView
- Paper trading or a connected broker: Trading Panel → Order History → column icon (select all) → Download data → CSV.
- Strategy tester: Strategy Report → List of Trades → Download (CSV).
- Drop the file here: filled orders are grouped into trades automatically.
TopstepX / ProjectX
- Open the Trades tab (not Orders).
- EXPORT (bottom right) → choose the date range → Export → CSV.
- An empty file means the date range is too narrow.
Rithmic R | Trader Pro
- File → Orders History (one day per export) or Recent Orders for today.
- Pick the account and date. In Completed Orders, right-click the headers and add Qty Filled, Order Number and Commission Fill Rate.
- Export to CSV and drop the files here (several days at once is fine).
cTrader
- History tab → Statement → the HTML statement opens in a new tab → save it.
- Drop the .htm file here. cTrader writes times in UTC: choose “UTC → New York” (or your zone) as the time zone.
Match-Trader
- Closed Positions tab → set the date range.
- Click the download icon at the right of the header row → HTML or CSV. Drop the file here.
FTMO (client area CSV)
- In the FTMO client area, open the account and download its trade list as CSV (semicolon-separated).
- Or export the MetaTrader 4 / 5 report as described above: both work.
Interactive Brokers
- Client Portal → Performance & Reports → Flex Queries → Trade Confirmation → Create (+).
- Section Trade Confirmation → Executions, select all fields; format CSV, column headers Yes.
- Run the query, download the CSV and drop it here: fills are grouped into trades with the contract multiplier.
Quantower
- Open the Trades panel (trade history) and set the period.
- Export the table to CSV from the panel menu and drop the file here.
Other platform (any CSV)
- Any other platform: export your closed trades or executions as CSV, TXT, HTML or XLSX.
- The journal guesses the columns; if it cannot, you match them once by hand (symbol, side, quantity, times, prices, P&L).
- No export at all? Fill in the CSV template and import it.
Journaling mistakes to avoid
- Writing paragraphs and measuring nothing: tags and numbers beat essays.
- Rating trades by their result instead of the quality of execution.
- Changing your tags every week: the reports lose their history.
- Drawing conclusions from 15 trades: wait for the confidence range to tighten.
- Ignoring fees: many scalping edges disappear after commissions.
- Skipping the review on red days — the days you learn the most.
New to journaling?
Free trading journal in your browser: import NinjaTrader, MT4/MT5, Tradovate or TradingView trades and get profit factor, Sharpe, drawdown and Monte Carlo odds.
Journal your NinjaTrader trades
Open your NinjaTrader account with our link, trade with our free indicators, and import the Trade Performance export here to measure every setup.
Open my NinjaTrader accountFree NinjaTrader indicators
Partner link. Futures trading involves a substantial risk of loss. Disclaimers
Related concepts and tools
Frequently asked questions
What is a trading journal?
A record of every trade — instrument, entry, exit, size, result — plus the reasons, emotions and mistakes behind it, used to measure and improve your trading.
What should a trading journal include?
The trade data (symbol, direction, size, entry, exit, P&L after fees), the initial stop, the setup, context tags, mistakes, emotion, an execution rating, a screenshot, and a daily plan and review.
How often should I review my trading journal?
Tag your trades every day after the close, and do a deeper review each week with the reports: setups, mistakes, hours and probabilities.
Is a spreadsheet good enough as a trading journal?
It works for logging, but it is slow to maintain and rarely computes drawdown, Sharpe, R-multiples, significance or Monte Carlo. A dedicated journal imports the trades and does the statistics for you.
How many trades do I need before trusting my statistics?
About 30 trades for a first look, 100 or more for reliable conclusions. The confidence ranges and p-value in the journal show when the sample is large enough.
What is the best free trading journal?
Choose one that imports your platform, measures risk (drawdown, Sharpe, R) and keeps your data private. The Trading Evolution journal is free, needs no account and keeps everything in your browser.
How do I journal futures trades from NinjaTrader?
In NinjaTrader 8, open Trade Performance, choose your account and dates, show the Trades list, right-click and export to CSV, then import the file into the journal.
Can a trading journal help me pass a prop firm challenge?
Yes: tracking your cushion to the drawdown limit, your daily loss and your consistency, and simulating your chance of passing, helps you adjust risk before a rule is broken.
Educational content, not investment advice. Statistics describe past results and do not guarantee future performance. Trading involves a substantial risk of loss.
Educational content. These indicators are not investment advice and guarantee no result. Futures trading involves a risk of loss that can exceed the initial investment. Terms of use · Disclaimers