A trading journal is a decision and performance record, not just a list of wins and losses. The useful part is the connection between what you planned, what you actually did, what it cost, and what happened afterward. A good template makes those fields consistent enough to review without turning every trade into an administrative project.

This guide gives you one journal structure that can be implemented in Excel, Google Sheets, Notion or Obsidian. It also shows which metrics are worth calculating, how to review the data without over-interpreting a small sample, and how to reconcile your personal journal with broker records.

What a Trading Journal Should Do

A broker statement can tell you what was executed. A trading journal adds the context that an account statement usually cannot capture: the setup, market condition, planned risk, reason for entry, reason for exit, process mistakes, screenshots and post-trade lessons. The journal should help you answer specific questions such as “Which setups have actually produced acceptable results after costs?” and “Where do I keep breaking my own rules?”

It should not be treated as a substitute for official transaction records. FINRA recordkeeping guidance recommends retaining and reviewing account records such as confirmations and statements. Use those records to reconcile prices, quantities, fees and transactions rather than assuming a manually entered spreadsheet is authoritative.

Core Fields for a Useful Trading Journal Template

Start with a single trade table. Add fields only when they answer a review question you expect to ask later. The following structure works across asset classes, with a few forex-specific additions for spread, financing and currency exposure.

Field Why record it Example / note
Trade ID Stable reference for screenshots, notes and partial fills. T-0241
Open / close date and time Lets you segment by session, holding period and event timing. Use one timezone consistently.
Instrument Identifies the market or pair. EUR/USD, GBP/JPY, XAU/USD, equity ticker, etc.
Direction Required to interpret price movement correctly. Long / Short
Strategy / setup Lets you compare like-for-like trades. Breakout, pullback, mean reversion, event setup.
Timeframe Adds context to the setup. M15, H1, Daily, etc.
Entry / exit price Execution data for reconciliation and analysis. Prefer broker-confirmed figures.
Position size Needed to understand exposure and P/L. Units, lots, shares or contracts.
Initial stop / planned invalidation Captures the risk plan before outcome is known. Price level or rule.
Initial risk amount Lets you normalize results as R-multiples. Currency amount actually at risk under the plan.
Target / exit rule Records what would have ended the trade favorably. Price target, trailing rule, time stop.
Fees / commissions / financing Prevents gross P/L from looking better than net results. Include relevant costs from the broker.
Net P/L Primary outcome field after applicable costs. Reconcile to the broker or platform record.
R-multiple Normalizes outcome by initial planned risk. Net P/L ÷ Initial Risk Amount.
Market condition Allows regime-based review. Trending, ranging, high volatility, event-driven.
Plan followed? Separates strategy outcome from process deviation. Yes / No, or a simple adherence score.
Reason for exit Shows whether exits matched the plan. Target, stop, time exit, discretionary override.
Notes / lesson Captures what numbers cannot. What was known at entry; what changed; what to repeat/avoid.
Screenshot / chart link Preserves visual context. Before/after chart or note link.

Do Not Recalculate Broker P/L with an Oversimplified Formula

The source material included a sample Excel formula that subtracts entry and exit prices using whichever is larger. That is not a valid generic trading P/L formula: it can turn losing price moves into positive differences, does not distinguish long from short trades, and ignores size, commissions, financing and instrument-specific contract values.

For the journal, treat broker-confirmed net P/L as the reconciliation field whenever possible. If you also calculate P/L yourself, document the instrument conventions. A simple cash-equity long trade might use (Exit Price – Entry Price) × Quantity – Costs, while a short reverses the price difference. Forex and derivatives can additionally require contract size, tick/pip value, quote-currency conversion and financing treatment.

Useful Metrics: What They Mean and What They Do Not Mean

Metric Useful calculation Interpretation caveat
Win rate Winning trades ÷ closed trades. A high win rate can coexist with poor results if losses are much larger than wins.
Average win / average loss Average positive net P/L versus absolute average negative net P/L. Review alongside trade count and distribution, not as a standalone score.
Profit factor Gross profits ÷ absolute gross losses. Describes the recorded sample; it does not prove a future edge.
Expectancy Win rate × average win – loss rate × average loss. Depends on the sample and cost assumptions remaining representative.
R-multiple Net P/L ÷ initial planned risk. Only meaningful if initial risk was defined consistently before the trade.
Maximum drawdown Largest peak-to-trough decline in the chosen equity series. Historical drawdown is not a maximum future loss.
Plan adherence Trades following the documented plan ÷ reviewed trades. Useful for process review even when the trade outcome was negative.
Performance by setup / regime Group metrics by strategy, timeframe, market condition or session. Small subgroups can create misleading conclusions.

Avoid treating one metric as a verdict on a strategy. A journal is most useful when you can compare outcome, risk and process together. A losing trade that followed a tested plan is different from a losing trade created by an unplanned override, and the journal should preserve that distinction.

Excel Trading Journal Template: A Practical Setup

Excel works well when you want a structured trade grid, formulas, pivot tables and charts in one workbook. The cleanest setup is to convert the log into an Excel Table rather than maintaining open-ended cell ranges. Microsoft documents that structured references use table and column names and automatically adjust as rows or columns are added or removed.

  1. Create a Trades table. Use the core fields above as headers and keep one completed trade per logical record. If you scale in or out, either log fills separately or define a consistent aggregation rule.
  2. Separate input fields from calculated fields. Entry data, strategy tags and notes are inputs; R-multiple and summary metrics can be formulas.
  3. Use controlled categories. Dropdowns for Direction, Strategy, Market Condition and Plan Followed reduce inconsistent spellings that break later analysis.
  4. Create a Summary sheet. Keep win rate, average win/loss, profit factor, expectancy, drawdown and setup-level summaries separate from raw trade data.
  5. Use pivots and charts for questions, not decoration. Examples: net P/L by strategy, R-multiple by market regime, or adherence by session.

Example formulas below assume the Excel table is named Trades and that Net P/L and Initial Risk are numeric columns. Empty/error handling can be adapted to your workbook.

Win rate
=IFERROR(COUNTIF(Trades[Net P/L],">0")/COUNT(Trades[Net P/L]),0)

Average win
=IFERROR(AVERAGEIF(Trades[Net P/L],">0",Trades[Net P/L]),0)

Average loss (absolute)
=IFERROR(ABS(AVERAGEIF(Trades[Net P/L],"<0",Trades[Net P/L])),0)

Profit factor
=IFERROR(SUMIF(Trades[Net P/L],">0",Trades[Net P/L])/ABS(SUMIF(Trades[Net P/L],"<0",Trades[Net P/L])),0)

R-multiple per trade
=IFERROR([@[Net P/L]]/[@[Initial Risk]],"")

If you publish a downloadable Excel file, test its formulas with long, short, winning, losing, flat and fee-heavy examples before linking it from the page.

Google Sheets Trading Journal Template

Google Sheets can use essentially the same field structure while making collaboration and browser access easier. Current Google documentation supports tables, dropdown/data-validation rules and pivot tables with calculated fields, which are enough for a practical trading journal without building a custom application.

  • Use dropdowns for repeatable tags. Strategy, market condition, session and plan adherence should use controlled values where possible.
  • Use pivot tables for review. Summarize P/L, R-multiple or trade count by strategy, instrument, session or month.
  • Protect formulas and headers. Keep manual entry areas obvious and avoid accidental overwrites of summary logic.
  • Be explicit about sharing. A shared cloud sheet is convenient, but access permissions should match the sensitivity of the account data you choose to store.

Notion Trading Journal Template

Notion is useful when the journal needs richer qualitative context. A database can store number, date, select, multi-select and formula properties, while each trade can also open as its own page for screenshots, a pre-trade thesis and post-trade review.

Property group Suggested Notion properties Why it helps
Execution Instrument, Direction, Open Date, Close Date, Entry, Exit, Position Size, Net P/L Keeps objective trade data filterable.
Risk Initial Risk, Stop, Target, R-multiple Connects outcome to the planned risk.
Classification Strategy, Timeframe, Market Condition, Session Makes database views and filters useful.
Process Plan Followed, Error Type, Confidence / state tag Separates execution discipline from market outcome.
Review Lesson, Screenshot, Linked analysis page Provides the richer narrative that spreadsheets often compress.

Use Notion formulas for simple derived fields, but keep your broker or platform records as the source for executed transaction details. If you need complex portfolio analytics, a spreadsheet or dedicated analytics tool may remain easier to audit.

Obsidian Trading Journal Template

Obsidian is strongest when you want local Markdown notes, linked research and a repeatable trade-review note. Its current Properties system supports structured fields such as text, numbers, dates, checkboxes and tags, and the built-in Templates plugin can insert a standard note structure. That makes it suitable for qualitative journaling even if aggregate quantitative analysis requires more manual work or additional tooling.

---
trade_id: T-0241
date: "{{date}}"
instrument: EURUSD
direction: long
strategy: pullback
timeframe: H1
plan_followed: true
tags:
  - trading-journal
  - forex
---
# Trade Review
## Thesis before entry

## Planned invalidation and risk

## Execution and exit

## What followed the plan?

## What would I change?

## Chart links / screenshots

If the primary goal is numerical performance analysis rather than linked notes, Excel or Google Sheets will usually require less setup. If the primary goal is detailed qualitative review, Obsidian or Notion may feel more natural.

How to Review the Journal Without Fooling Yourself

  1. Reconcile first. Check closed trades against broker confirmations or statements so the dataset does not drift from executed reality.
  2. Review process separately from outcome. Mark whether the entry, risk and exit rules were followed before deciding what the trade “teaches.”
  3. Segment only when there is enough data. A strategy with three trades should not be declared your best setup because all three happened to win.
  4. Compare net results. Use commissions, spread/fees and financing where they are relevant to the product.
  5. Look for repeatable errors. Examples include late entries, widening stops, oversizing, trading outside the planned session or taking unplanned setups.
  6. Change one thing at a time. If you revise the strategy, risk rule and exit logic simultaneously, the journal will not tell you which change mattered.

A Practical Review Cadence

There is no universal “best” review schedule because a trader making two trades a month needs a different rhythm from one making twenty trades a day. A practical framework is to log or reconcile soon after the trade, run a batch review at a regular interval, and perform deeper strategy-level analysis only when the sample is large enough to support it.

Review layer Questions to answer
Per trade What was planned? What was executed? Were risk and exit rules followed? What costs were incurred?
Short-cycle review Are fields missing? Are the same process errors repeating? Do broker records match the journal?
Strategy review Which setups or regimes are contributing to net P/L and drawdown? Is the result dependent on a small number of outliers?
Change review What exact rule changed, when did it change, and are post-change results being kept separate from the prior version?

Trading Journal vs. Myfxbook or Automated Analytics

Manual journaling and automated account analytics solve different problems. A service such as Myfxbook can reduce manual work around performance statistics and account history, while a personal journal can record the decision context, process adherence and screenshots that a connected account cannot infer. The strongest workflow can use both: automated records for execution data and a journal for reasoning and review. See the Myfxbook trading tools guide for the account-analysis side of that workflow.

Risk Notes for Forex Traders

A journal can improve the quality of your records, but it does not reduce market or leverage risk by itself. Current CFTC guidance for U.S. retail OTC forex explains that customers trade against the dealer rather than on a centralized exchange and that leverage can amplify losses. Record the broker/entity, product and account assumptions that matter to your results, especially when comparing performance across different accounts or providers.

For risk planning, use the position size calculator to translate a chosen risk amount and stop distance into position size. If your journal tags technical setups, the Forex Technical Analysis guide can provide the broader framework without duplicating it here.

Downloadable Template: What the Page Should Promise

The supplied source copy repeatedly promises a free Excel or trading-journal download, but no actual workbook or downloadable template file was supplied with this content. The page should not use a “Download now” CTA unless a real asset exists, has been tested, and matches the fields/formulas described in the article.

  • If a real .xlsx template is available: place the download near the top of the article, state what sheets/fields it contains, and test formulas before publication.
  • If no file is available: position the article as a build-your-own template guide and remove unsupported “free download” language from the visible CTA/meta copy.
  • Do not make performance promises. The template organizes data; it does not guarantee better returns or “consistent success.”

Frequently Asked Questions

What should a trading journal template include?

At minimum, record the instrument, direction, entry and exit timing, entry and exit prices, position size, applicable costs, net profit or loss, strategy, planned risk, exit reason and a short post-trade note. Add fields only when they support a question you will actually review.

Is Excel or Google Sheets better for a trading journal?

Both can work well. Excel is strong for structured tables, formulas and local workbook workflows, while Google Sheets is convenient for browser access, sharing, dropdowns and pivot-table analysis. The better choice is the one that fits your workflow and data-handling preferences.

Can I use Notion as a trading journal?

Yes. A Notion database can store trade properties, tags and formulas, while each trade can also have a detailed page for screenshots and notes. It is especially useful when qualitative review matters as much as spreadsheet-style metrics.

Can I use Obsidian as a trading journal?

Yes. Obsidian supports structured note properties and reusable templates, making it useful for linked, local Markdown trade reviews. Aggregate statistics may require more manual setup than a spreadsheet.

Which trading journal metrics are most useful?

Useful starting metrics include net P/L, win rate, average win and loss, profit factor, expectancy, R-multiple, drawdown and plan-adherence rate. Review them together and avoid drawing strong conclusions from small samples.

Does a trading journal replace broker statements or trade confirmations?

No. A personal journal adds decision context and analysis, but broker statements and confirmations should remain the records you use to verify executed prices, quantities, fees and account activity.

Is there a free trading journal Excel template to download on this page?

Only claim a downloadable file if the site actually provides and tests one. If no workbook is available, use the field structure and formulas in this guide to build the template in Excel or another supported tool.