Guide

Trading journal in Notion: how to build it and where it ends

Notion works for a trade journal if you take few trades and care about notes. Below are the database structure, the formula and a plain list of limits.

Updated: November 22, 20263 min read

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:

PropertyTypePurpose
TradeTitleInstrument and date, for example "EURUSD 12 Jan"
DateDateFor the calendar and grouping by week
InstrumentSelectBreakdown by instrument
DirectionSelectLong or Short
SetupSelectA fixed list of three to five names
Risk, $NumberPlanned loss at the stop
Result, $NumberOutcome including commissions
RFormulaResult divided by risk
PlannedCheckboxWhether the plan was followed
StateSelectCalm, 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.

Frequently asked questions

Can I keep a trading journal in Notion?

Yes. A database with properties for risk, result and setup and an R formula covers the basics at a small number of trades.

How do I calculate R-multiple in Notion?

Create a Formula property and divide the trade result by the risk. Both values are stored in Number properties.

Can Notion import trades from MT5?

Notion has no built-in link to trading platforms. Trades are entered by hand.

Which is better for a journal: Notion or Excel?

Notion is more convenient for notes and screenshots, Excel for calculations. For statistics by setup a spreadsheet is the better fit.