Plan Adherence
Yes / (Yes + No)
The percentage of reviewed trades that followed your plan. Unknown is excluded, so an unclear or unwritten plan does not distort the result.
Trading journal template guide
Free Excel trading journal
Trading Journal Excel Template
Record trades, review your decisions and measure whether you followed the plan. The workbook calculates Plan Adherence and Review Coverage automatically. No email gate.
More than a PnL spreadsheet
A high adherence score matters only when enough trades have actually been reviewed. This workbook keeps both numbers visible.
One workbook, four focused sheets
Empty Journal, automatic Summary, three fictional examples and a short Read me. Formulas cover up to 1,000 trade rows.
Workbook preview
See the discipline summary before you download
The downloaded workbook opens on this Summary view. Values below are illustrative; your metrics update from the Journal.
tdlab-trading-journal-template.xlsx
Illustrative previewTDLab / Trading Journal
Discipline summary
Updates automatically from Journal
Trades logged
20
Closed trades
Net PnL
$1,248.60
After costs
Plan adherence
80%
Unknown excluded
Review coverage
50%
10 of 20 labeled
Plan Adherence
Yes / (Yes + No)
How often the plan was followed when its state was known.
Review Coverage
Labeled trades / trades logged
How much of the journal received a plan label.
JournalSummaryExampleRead me
Built-in discipline metrics
Measure the process, not only the PnL
Choose Yes, No or Unknown in the Followed Plan column. The Summary sheet updates automatically as your journal grows.
Review Coverage
Labeled trades / trades logged
The share of your journal labeled Yes, No or Unknown. It shows whether the adherence percentage rests on a meaningful review sample.
Example: 8 Yes, 2 No and 10 unreviewed trades produce 80% Plan Adherence but only 50% Review Coverage. The second number keeps the first one honest.
Inside the Journal
Execution and review in one row
Keep the objective trade record beside the context needed to understand the decision. Filters and controlled dropdowns make repeated review faster and more consistent.
Trade data
Date, account, symbol, side, open and close time, prices, size, fees and Net PnL.
Trade context
Setup, execution quality, mistake, emotion and free-form notes.
Plan review
Label every trade Yes, No or Unknown with a controlled dropdown.
Start simple, then scale
A spreadsheet until the spreadsheet becomes the work
The template helps establish the review habit. TDLab becomes useful when manual tagging, cross-account analysis and repeated pattern detection start taking too much time.