Notion appeals because the journal, the notes and the screenshots live in one place. A database in Notion works like a table in which every row has its own page. That suits a trade journal: the row holds the numbers, the page holds the chart and the review.
Database structure
Create a database called "Trades". One entry is one trade. The properties:
| Property | Type | Purpose |
|---|---|---|
| Trade | Title | Instrument and date, for example "EURUSD 12 Jan" |
| Date | Date | For the calendar and grouping by week |
| Instrument | Select | Breakdown by instrument |
| Direction | Select | Long or Short |
| Setup | Select | A fixed list of three to five names |
| Risk, $ | Number | Planned loss at the stop |
| Result, $ | Number | Outcome including commissions |
| R | Formula | Result divided by risk |
| Planned | Checkbox | Whether the plan was followed |
| State | Select | Calm, tired, irritated, rushed |
The formula for the R property: round(prop("Result, $") / prop("Risk, $") * 100) / 100.
What goes on the trade page
Inside each entry, make a page template with three blocks: a screenshot of the chart at entry, a screenshot after the close and three lines of text. Why you entered, what happened, what you would change. The template is set once in the database settings and is applied to every new entry.
Views
- Table. The main view for data entry.
- Calendar by date. Shows trading days and breaks.
- Board by setup. Trades grouped by strategy.
- "Not planned" filter. All rule-breaking trades in one list.
In the bottom row of the table, turn on the sum and the average for the R column. The average R is the expectancy of all trades. Group the table by setup and the same average is calculated for each group.
Where Notion stops being enough
- Every trade is typed in by hand. At five trades a week that is bearable. At five a day the journal gets abandoned.
- No link to the trading account. You copy prices, size, commissions and times from the terminal, typos included.
- Statistics end at sum and average. Win rate by setup, profit factor, drawdown and an equity curve need workarounds or outside spreadsheets.
- No trade charts. You take the screenshot and paste it yourself.
- Mobile entry is slow. Filling in ten properties on a phone takes time.
What to choose
Notion is a good fit if you trade rarely and the journal is mainly a place for notes. If you need statistics, start with a spreadsheet: the trading journal template for Excel has the formulas set up.
If you take many trades, move to a journal with automatic import. Tradeart pulls trades from MetaTrader 5, cTrader and DXtrade on its own, calculates statistics in R and keeps notes and screenshots next to each trade. More on the automated trading journal page.
