A trading journal built as three linked databases rather than one flat table.

How to use this

  1. Open Setups and replace the five examples with your own strategies. Each one needs all four layers filled in: Context, Level, Trigger, Confirmation.
  2. Log trades in Trades. Only the R-Multiple column is calculated, so never type into it.
  3. Link every trade to its Setup. This is what makes the rollups work, and skipping it makes the whole structure pointless.
  4. Every Sunday, open Weekly Reviews and write one line on what you will change.

The one number that matters

Open any Setup page and read Expectancy (R). It is the average of the R-Multiple across every trade linked to that setup.

Positive means you make money over enough trades. Negative means you do not, no matter how good the win rate looks.

Any setup with 30 or more trades and negative expectancy gets its Status changed to Retired. That single action is worth more than any amount of additional journaling.

What a spreadsheet cannot do, and neither can this

MAE and MFE — how far a trade moved against you, and how far it moved in your favour, before it closed — need tick-by-tick price data for the life of each trade. Notion has entry and exit prices and nothing in between, so no formula can produce them.

Those two metrics are what tell you whether your stops are in the wrong place and whether you are cutting winners early. For most traders the exit leak is the largest single recoverable source of return.

For those, plus automatic import from 700+ brokers, TraderWaves is free permanently: https://traderwaves.com


Educational template only. Not financial advice. Trading carries risk of loss. TraderWaves is operated by Wallace FX Ltd, London, United Kingdom.

Setups

Weekly Reviews

Trades