Trader's Second Brain Trader's Second Brain

7 Free Trading Journal Templates: Excel, Notion & Sheets (2026)

Download a free Excel trading journal with a trade log and weekly review, choose the email-delivered Notion starter, or build a custom Excel or Google Sheets blueprint. Keep the smallest format that supports a repeated review.

Quick Answer

Download the free Excel starter without an email form: it has a trade log and weekly review for 250 closed trades. Enter verified net P&L and review one currency at a time. The Notion starter is delivered by email; the six Excel, Google Sheets and review blueprints below remain build-it-yourself options. Google Sheets import of the Excel file has not been verified.

Free TSB trading journal
Free plan · no card required

Start with the free TSB journal.

Import or log trades in TSB, then review setups, sessions, and recurring mistakes.

Start free journal →
Trader's Second Brain preview

Free starter options: Download the free Excel starter below without an email form, or choose the simple Notion journal delivered by email. The six build-it-yourself blueprints remain available for Notion, Excel, and Google Sheets; those blueprints are instructions, not additional downloads.

The right free trading journal is the one whose input cost matches the review you will actually perform. A beautiful template with fields you never use is worse than a twelve-column log you review every week.

For a ready-made starting point, download the Excel starter or use the simple Notion journal. For a custom spreadsheet, build the Sheets or Excel blueprint below. The seven options on this page are clearly labeled so “free template” never hides an email requirement, missing file, or paid upgrade.

FREE START · 3 OPTIONS

Choose how you want to start

03 · SKIP THE WORKBOOK

Analyze trades in the app

Import or log trades, then review patterns.

Find trade leaks →

Free here: an Excel starter download, the email-delivered Notion starter, and every blueprint below. The Excel file has a trade log and weekly review for 250 closed trades. Enter verified net P&L; it does not calculate results from entry and exit prices or convert currencies. Google Sheets import has not been verified.

All Free Templates and Blueprints

1. TSB Simple Notion Trading Journal — Ready-Made

Availability: currently offered. The public page asks for a first name and email, then says the Notion template is sent to the inbox. Follow the delivered link and inspect the workspace before adding real account information.

Best for: a trader who already uses Notion and wants a simple qualitative habit without spreadsheet setup.

Read the free Notion journal guide. Notion's own documentation explains that duplicating a public page creates a copy in your workspace; you need the appropriate Notion session and permissions.

2. Google Sheets Core Trade Log — Build It Yourself

Availability: blueprint in this article, not a TSB download. Paste this tab-separated header line into A1:

Date Symbol Direction Entry Exit Stop Size Net P&L Initial Risk R-Multiple Setup Notes

Use =IF(OR(H2="",I2="",I2=0),"",H2/I2) for R-Multiple and build the remaining dashboard from the Google Sheets journal guide.

3. Excel Table Trade Log — Build It Yourself

Availability: blueprint in this article, not a downloadable TSB workbook. Use the same core columns, select the range, and create an Excel Table named Trades. Structured references make formulas readable and expand with new table rows.

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

Microsoft documents the structured-reference syntax used by Excel Tables. Verify your Excel version and locale before copying separators or function names.

4. Universal CSV Trade Log — Build It Yourself

Availability: a portable schema, not a styled dashboard. Use it when you want a neutral interchange file:

closed_at,symbol,direction,quantity,entry_price,exit_price,fees,net_pnl,initial_risk,setup,notes

CSV preserves rows and values, not workbook formulas, dropdowns, charts, or multiple tabs. Keep the original broker export unchanged and create a separate normalized copy.

5. Weekly Review Template — Build It Yourself

Create one row per week with: week ending, trade count, net P&L, total R, max drawdown, best setup, largest rule deviation, one behavior to keep, and one change to test. This is a review layer, not a replacement for the trade log.

6. Trading Playbook Template — Build It Yourself

Create one row or page per setup with: setup name, market context, entry trigger, invalidation, initial stop method, target logic, permitted sessions, disqualifiers, annotated example, and last review date. The playbook states what should happen; the trade log records what did happen.

7. Prop-Program Constraint Tracker — Build It Yourself

Use one row per exact program, not one row per firm. Record the program, country, nominal size, current phase, checked price, profit target, daily loss, maximum loss, minimum days, payout terms, platform, restrictions, official source, and date checked. Mark a missing fact as Needs confirmation instead of guessing.

Keep the tracker generic until you select a program. Once you shortlist a challenge, copy its current written rules into a dedicated row and retain the official link and check date beside them.

What's Inside the Verified Notion Template

The public offer describes a simple Notion trading journal. It does not publicly enumerate every database property, formula, dashboard, connector, asset-class variant, or prop-firm tracker before delivery. Therefore this guide does not promise the old list of five modules, eighteen fields, equity charts, or preconfigured firm formulas.

After receiving the link:

  1. Duplicate the page into a test workspace.
  2. List the properties that actually appear in the delivered version.
  3. Enter two fictional trades and check every formula or rollup by hand.
  4. Remove fields you will not review and add only fields tied to a decision.
  5. Confirm the page is private before adding screenshots or account details.

The ready-made free journal, the separately sold TSB Notion system, and the TSB web app are different products. Features or pricing from one should not be attributed to another.

Which Template to Choose

Your priorityStart withTrade-off to test
Ready-made qualitative habitTSB simple Notion journalEmail delivery and the fields in the delivered version
Cloud spreadsheet and sharingGoogle Sheets blueprintManual input, formula protection, offline setup
Structured formulas and local workbook workflowExcel Table blueprintYour license, version, backups, and import process
Portable raw dataCSV schemaNo formulas, views, or multi-tab structure
Habit and decisionsWeekly reviewNeeds an underlying trade log
Setup consistencyPlaybookDoes not calculate performance alone
Challenge-rule complianceProgram constraint trackerEvery value needs an official source and date

You can combine templates, but each should have one job. A practical minimum is one raw trade log plus one weekly decision page. Duplicate metrics across three tools only if you have a reconciliation reason.

The Minimum Fields That Survive a Tool Change

Regardless of format, keep a durable core:

  • timestamp and timezone;
  • account and instrument;
  • direction, quantity, actual entry, and actual exit;
  • initial stop and positive initial risk amount;
  • fees and net P&L;
  • setup label, rule-adherence result, and one concise note.

With those fields you can rebuild win rate, average win and loss, profit factor, realized expectancy, R-multiple, and an equity curve. A screenshot can help explain context, but it should not be the only record of numeric facts.

Free Template vs TSB Products

OptionVerified public roleDo not assume
Free simple Notion journalEmail-delivered starting templatePaid-system modules or web-app automation
TSB Full AccessSeparate, more complete Notion-based productThat it is included in the free journal
Sheets / Excel blueprints hereInstructions you build in your own workbookThat every blueprint is a downloadable file; the Excel starter is linked separately above

Check the current Notion product page and current web-app offer separately. Do not copy a price or feature count from an old article into the decision; live product pages are the source for mutable commercial terms.

Before You Use Any Free Trading Journal Template

  • Use fictional rows to test formulas and views.
  • Confirm who can access shared pages or workbooks.
  • Keep broker credentials, API secrets, and identity documents out of notes.
  • Export a backup in a durable format before reorganizing fields.
  • Write metric definitions so a future tool migration does not change the meaning silently.

A free template is successful when it produces a repeated review and a specific action. Start with the smallest structure that does that, then earn every extra field.

Igor Manuilov
Written and reviewed by
Igor Manuilov
Founder of Trader's Second Brain · Trader since 2014
Editorial accountability

Trader since 2014. Built Trader's Second Brain to make execution review more evidence-based and less dependent on memory, scattered spreadsheets, or vague journaling.

Free TSB trading journal
Free plan · no card required

Start with the free TSB journal.

Import or log trades in TSB, then review setups, sessions, and recurring mistakes.

Start free journal →
Trader's Second Brain preview

Frequently Asked Questions

Quick answers to the most common questions about Free Trading Journal Templates.

Yes. Download the Excel starter without an email form, or request the simple Notion journal by email. The six build-it-yourself blueprints are also free instructions, not six additional downloads. The Excel starter uses verified net P&L for 250 closed trades and reviews one currency at a time; importing it into Google Sheets has not been verified.

Use the ready-made Notion journal for a simple qualitative start, Google Sheets when browser sharing matters, and an Excel Table when structured formulas and workbook control matter. The products do not automatically contain identical fields, so test the exact template or blueprint you choose.

The build-it-yourself schemas can be adapted, but risk and P&L calculations are not universal across asset classes. Add the correct multiplier, point or pip value, fees, financing, and timezone for the instrument; verify the delivered Notion template before assuming a field is included.

You can build a constraint tracker with one row per exact program, including region, size, stage, targets, loss limits, minimum days, payout rules, restrictions, official source, and verified date. Do not assume the free Notion journal includes a preconfigured prop-firm module unless the delivered version shows it.

The free simple Notion journal, the separately sold TSB Notion system, and the TSB web app are different products. Compare the live pages for current features and pricing, and test the exact import and review workflow rather than carrying feature counts from one product to another.