Trader journal — a professional template with 25 columns

Mark kept a five-column trader journal for his entire first year of trading — date, pair, entry, exit, result. By the end of the twelfth month his account stood at minus €4,200, but when he tried to answer the question of which of the setups he was using had actually generated the loss, the journal stayed silent. After he migrated to a professional twenty-five-column template and rewrote the previous one hundred and seventy-one trades into it, one concrete situation accounted for sixty-four percent of the year’s losses: entries on exotic pairs during the publication of US labour-market data. Cutting that segment in year two flipped the result from minus €4,200 to plus €8,100 on the same underlying strategy. In this article we walk through how to build such a journal from scratch, why five columns are never enough, which twenty-five columns make up the professional standard, and how Excel, TraderSync and Edgewonk fit into the work.

Why five columns are not enough

The most common retail trader journal has between five and seven columns — date, currency pair, entry price, exit price, monetary result, sometimes stop loss and take profit. That layout answers a single question: how much did you make. It does not answer a far more important one: why you made it — or why you lost. Without an answer to that second question, the trader does not improve the strategy. They simply repeat the same mistakes with different random outcomes.

A professional trader journal carries twenty-five standard columns — a number that recurs in the writing of Brett Steenbarger, in the Edgewonk documentation, and in the templates used by proprietary-trading firms such as FTMO and The5%ers. The figure is not arbitrary. It comes from four functional blocks: ten columns of trade data, five risk columns, five setup-analysis columns and five execution-review columns. Each block addresses a different layer of self-understanding, and removing any one of them leaves a black hole in the analysis.

The crucial distinction on which the whole structure rests is the split between input data (what the trader keyed in by hand at the moment of opening the position) and output data (what the spreadsheet or app computed on its own from those inputs after the position closed). Input data answers the question “what did I do”; output data answers “what came of it”. Together they create a picture on which strategic decisions can be made. Separately, each layer is incomplete.

Ten columns of trade data — the foundation of any journal

The first ten columns are the indispensable minimum. Without any one of them no later metric can be computed — which is why we call this block the foundation. The trader keys these values in by hand at the moment of opening and closing the position; six fields at entry (date, time, pair, direction, entry price, stop loss, take profit, position size) and four at exit (exit date, exit time, exit price, monetary result).

For a single standard lot of EUR/USD with an ECN broker the round-trip transaction cost is typically eight to thirteen euros — seven to ten in commission plus a spread of one to three. The monetary result in column ten has to include all of those costs, otherwise the later analysis rests on inflated numbers. Most brokers split these items in the history export, so the trader has to sum them in the spreadsheet.

Five risk columns — the layer most retail traders skip

The second group of columns answers the question “how much did I risk and how much did I make relative to that risk”. Most retail traders skip this block altogether and rely on a raw euro or dollar figure. The problem is that the raw figure conflates two different effects — the quality of the strategy and the size of the position. A trader who made €800 on a position with €400 of risk achieved a result twice as good as one who made €1,200 on a position with €1,000 of risk. The nominal amount is larger in the second case, but the trade quality is worse.

The five risk columns look as follows. Column eleven — risk percentage, the stop-loss distance times pip value times position size, divided by account balance. The professional standard is one percent per trade; values above two percent are dangerous, above five percent are a mistake. Column twelve — R-multiple, the monetary result divided by the initial monetary risk. A €150 profit on €50 of risk is plus 3R; a €50 loss on €50 of risk is minus 1R. This is the only metric that allows a fair comparison between two trades of different sizes.

Column thirteen — maximum intra-trade drawdown, measured from the peak unrealised gain to the closing result. A position that ran to plus 4R but was closed at plus 1R suffered an internal drawdown of 3R — a piece of information critical for evaluating position management. Column fourteen — share of portfolio, the exposure of the position relative to the total of all open positions. It catches excessive concentration on a single pair or a single direction. Column fifteen — correlation with other open positions; two long positions on EUR/USD and GBP/USD with a correlation of plus 0.90 are in reality a single position twice the size.

Five setup-analysis columns — the answer to “why did I enter”

The third group is the most distinctive feature of a professional journal. It answers the question that an amateur journal ignores: why was this particular trade opened in the first place. The five fields in this block are: setup type, timeframe, confluence factors, macroeconomic context and the trader’s emotional state at entry.

Column sixteen — setup type — is categorical. The trader picks from a closed list of their own patterns: breakout from support or resistance, pullback in a trend, reversal formation, news scalp, range trade, harmonic pattern, divergence. The list should not exceed eight to ten items — a larger list makes later segmentation impossible. After a hundred trades it becomes visible which of these patterns delivers positive expectancy and which merely seems to work.

Column seventeen — the timeframe on which the position was spotted (M15, H1, H4, D1). After sixty trades one timeframe usually turns out to produce markedly better results than the others — less a matter of objective superiority than of fit with the trader’s personal rhythm. Column eighteen — the number of confluence factors (from zero to five-plus). Confluence means the alignment of independent signals: a support level plus the 200-period moving average plus an RSI divergence plus a triangle breakout. Full analysis after a hundred trades shows that trades with confluence of three or more factors have a win rate fifteen to twenty percent higher than trades on a single signal.

Column nineteen — news context. A text or categorical field: “pre-NFP”, “post-FOMC”, “around the ECB”, “quiet day, no scheduled data”. The trader learns quickly whether the strategy works better in low-volatility or high-volatility conditions. Column twenty — emotional state on a 1–10 scale, where 10 means full composure and confidence in the setup, and 1 means trading from revenge, frustration or fear. This single number, read across a hundred trades, exposes a reality that most retail traders do not want to see: positions opened with an emotional score below four have statistically negative expectancy and should be eliminated from the plan, however technically reasonable the setup may appear.

Five execution-review columns — post-trade analysis in concrete numbers

The fourth and final block is the execution review — what English-language literature calls post-trade analysis. It concerns not the trade itself but the quality of its execution against the original plan. Five fields: plan adherence, mistake count, lesson in one sentence, screenshot link, monthly tag.

Column twenty-one — plan adherence on a 1–10 scale. A 10 means entry, stop loss and exit happened exactly as designed before opening. A 5 means the trader changed something along the way — moved the stop loss, closed early, added size. A 1 means the position no longer had anything to do with the original plan. The correlation of this score with the R-multiple, read across a hundred trades, gives a hard answer to the question of whether straying from the plan costs or saves money. In ninety percent of cases the answer is the same: every one-point drop below seven costs roughly 0.3R in result on average.

Column twenty-two — mistake count. A numeric field from zero upward. Mistakes are defined by the trader before the season starts (a typical list: entering without a stop loss, moving the stop loss against price, adding to a losing position, closing a winning position before the target out of fear, opening a trade on a signal that was not in the plan). The mistake count per trade correlates strongly and negatively with the result — obvious in itself, but only the act of writing it down triggers the self-disciplining mechanism.

Column twenty-three — lesson in one sentence. A free-text field, no more than thirty words. “Entered too early, plan required H1 candle confirmation.” “Closed at plus 0.8R because of weekend fear, plan was plus 2R.” Read once a month, those sentences form a journal of error patterns — one of the most powerful learning tools available.

Column twenty-four — link to a chart screenshot at entry and exit. The simplest approach is to save them in a cloud folder and paste the hyperlink. Column twenty-five — a monthly tag, a simple category such as “January-NFP-tilt” or “February-EURUSD-range” — allows quick search through the journal by market phase. A fuller list of ten complementary metrics worth tracking alongside the twenty-five columns is laid out in the article on trading statistics.

Excel versus TraderSync versus Edgewonk — when to change tools

All twenty-five columns can be built in Excel in five to seven hours of work. Excel has three advantages no paid tool can match: full control of the data structure, no monthly fee, and — the most important — the requirement that the trader write every formula themselves. A trader who has once personally typed the R-multiple formula into a cell understands the metric more deeply than one who reads the same number off a TraderSync dashboard.

The threshold at which Excel starts to feel like a limitation sits around a thousand trades a year. Above that, manual data entry becomes tiring and the absence of automatic broker import begins to cost real time. At that point a move to TraderSync ($29 a month) makes sense — a tool that connects directly to most ECN brokers, imports history automatically, and produces ready dashboards for expectancy, profit factor, R-multiples and drawdown over monthly windows. Edgewonk ($169 one-time) goes a step further on psychological analysis — it offers detailed reports on emotional state, plan adherence and mistake tagging that TraderSync does not match in depth.

A VBA macro — one routine for automatic metric calculation

Most calculations in the spreadsheet can be handled by cell formulas (SUM, AVERAGE, IF, INDEX, MATCH). Two operations, however, are easier to automate through a VBA macro: refreshing all pivot tables with a single click, and generating a monthly report with expectancy, profit factor, R-multiples and a list of the ten best and ten worst trades of the period. Below is working code to paste into the VBA editor (Alt+F11 in Excel, Module1).

Sub CalculateMetrics()
    Dim ws As Worksheet
    Dim lastRow As Long
    Dim i As Long
    Dim sumWins As Double, sumLosses As Double
    Dim countWins As Long, countLosses As Long
    Dim sumR As Double
    Dim result As Double, rValue As Double

    Set ws = ThisWorkbook.Sheets("Trades")
    lastRow = ws.Cells(ws.Rows.Count, "J").End(xlUp).Row

    For i = 2 To lastRow
        result = ws.Cells(i, 10).Value      ' column 10: monetary result
        rValue = ws.Cells(i, 12).Value      ' column 12: R-multiple
        sumR = sumR + rValue
        If result > 0 Then
            sumWins = sumWins + result
            countWins = countWins + 1
        ElseIf result < 0 Then
            sumLosses = sumLosses + Abs(result)
            countLosses = countLosses + 1
        End If
    Next i

    Dim totalTrades As Long
    totalTrades = countWins + countLosses

    With ThisWorkbook.Sheets("Dashboard")
        .Range("B2").Value = totalTrades
        .Range("B3").Value = countWins / totalTrades
        .Range("B4").Value = sumR / totalTrades              ' expectancy in R
        .Range("B5").Value = sumWins / sumLosses             ' profit factor
        .Range("B6").Value = sumWins - sumLosses             ' net result
    End With

    MsgBox "Metrics calculated for " & totalTrades & " trades.", vbInformation
End Sub

Once pasted and bound to a form button (Developer tab, Insert form control, Button) the whole dashboard refreshes with a single click. Calculation time for a thousand trades does not exceed two seconds on a typical machine. The macro can be extended to segmentation by setup type, chart generation or emailing the report.

Mark’s story — from five columns to twenty-five

Mark traded for the first twelve months with a five-column journal. After a year the account stood at minus €4,200 against a starting balance of €12,000 — a loss of thirty-five percent. He tried to find the cause, but the journal showed only a raw sequence of numbers. There were good and bad months, good and bad weeks — but to the question of which specific trade type was generating the losses, the journal had no answer, because it had no column to draw the distinction.

In January of year two Mark rewrote all one hundred and seventy-one previous trades into a fresh twenty-five-column template. The transfer took three evenings, eight hours of work in total. Once he segmented the data by column sixteen (setup type) and column nineteen (news context), the picture became brutally clear. Scalping exotic pairs (USD/ZAR, USD/MXN, USD/TRY) during US labour-market data releases accounted for sixty-four percent of the annual loss — forty-eight trades from that segment produced minus €2,700 against total risk of €4,800. The win rate of that single segment was thirty-one percent, with expectancy of minus 0.56R.

In February Mark cut the category from the plan. The rest of the strategy remained the same — the same major pairs (EUR/USD, GBP/USD, USD/JPY), the same setups (level breakouts, pullbacks in a trend), the same timeframes (H1 and H4). One thing changed: a ban on trading exotic pairs during NFP, CPI and Fed-decision windows. Year two ended at plus €8,100 over one hundred and forty-two trades. Win rate rose from forty-seven to sixty-four percent. Expectancy moved from minus 0.18R to plus 0.42R. Profit factor climbed from 0.71 to 1.94. The strategy was identical; one segment changed, cut on the basis of data from columns sixteen and nineteen — columns that the five-column journal simply did not contain.

“A trader’s journal is not there so that you remember your trades. It is there so that you see the patterns you cannot see while you are trading. Five columns record; twenty-five columns analyse. The difference between the two is literally the difference between trading blind and trading on evidence.” — Brett N. Steenbarger, The Daily Trading Coach, Wiley, 2009.

Mark’s story is not unusual. Almost every trader who, after a year of five-column journalling, rewrites the data into the full template discovers a single concrete segment responsible for the bulk of the losses. It may be Friday-afternoon trading, attempts to catch tops in an uptrend, entries after the Asian session, trades opened in an emotional state below four, or news-scalping on exotic pairs. The particular segment differs from person to person, but the existence of such a segment is nearly a rule. Without a twenty-five-column journal it cannot be found — there are no columns through which to segment.

What to do tomorrow

1. Open Google Sheets and create a "Journal 2025" file. Type the headers for the twenty-five columns from the article into the first row. Format date columns as dates, numeric columns as numbers with two decimals, percentages as percentages. This step takes ten minutes and is the foundation of everything that follows.
2. Enter the computed formulas in the first ten empty rows. Result = (exit − entry) × position size. R-multiple = result / (risk in pips × pip value). Risk percentage = (risk in account currency) / capital × 100. Two hours spent writing the formulas yourself produce a real understanding of what the journal measures — without that understanding no online tool will help you.
3. Enter the last twenty trades from your broker history. If you have a demo or live history, open the broker client portal and key the last twenty trades into the journal by hand. Manual entry is intentional — each trade forces you to recall the entry context, the emotional state, the plan adherence. After those twenty entries you will see the first patterns.
4. Create a second sheet with aggregate metrics. Expectancy = AVERAGE of the R-multiple column. Profit factor = SUMIF for positive results divided by SUMIF for negative ones. Win rate = COUNTIF for results greater than zero divided by the total number of trades. These three numbers are the foundation of strategy evaluation and should always be visible in the sheet header.
5. Schedule a weekly journal review. Every weekend, for at least thirty minutes, open the sheet, review the week, tag the monthly column (25), write the lesson of the week in a single sentence. It is not extra work — it is the only work that actually builds competence. A journal without a weekly review is a text file, not an analytical tool.