Trading journal

Notion trading journal template: build one in 15 minutes

Nathan · RB Trading Updated 9 Nov 2026 7 min read
A wooden library card catalogue, with the title Notion trading journal
Photo: MarkBuckawicki, CC0, via Wikimedia Commons

We do not sell a Notion template, and you do not need one. You can build a Notion trading journal in about 15 minutes: import our free CSV, which Notion turns into a database, set the property types, then add three formulas and three views. Every step was checked against Notion's help pages on 9 Nov 2026.

This guide covers the import, the property list, three formulas you can paste, the views worth adding, a daily routine, and where Notion stops being enough. Want Excel or Google Sheets instead? Our free trading journal template has both, with the formulas built in.

How to import the free CSV into Notion

  1. Download the CSV: trading-journal-template.csv. No email needed. It has 17 columns and 5 rows marked EXAMPLE.
  2. Start the import. In Notion, go to Settings > Import > CSV, or type /csv on a page.
  3. Upload the file and choose to create a new database.
  4. Pick where it goes, then map each CSV column to a property type, using the table below.
  5. Check the example rows, then delete them and log your own trades.

Notion's help page says "CSV imports create a new Notion database": rows become pages and columns become properties. Three more things it says are worth knowing before you start:

Already have a journal database in Notion? Notion's Merge with CSV adds rows to it, matched to your existing properties. It adds rows only and does not update ones you have.

The properties: name, type and what each one is for

The names match the CSV headers, so the formulas below work without edits. In the mapping step, check which column Notion makes the page title: a short text column such as Note suits it. Keep Date as a Date property, because the calendar view needs it.

PropertyTypeWhat it is for
DateDateThe calendar view, and results by day and month
TimeTextThe entry time, for results by session
MarketSelectFinds the markets that quietly cost you
DirectionSelectLong or Short
SetupSelectA fixed list of 5 to 8 names, so setups can be grouped
Entry, Stop, Target, ExitNumberThe plan and what really happened
SizeNumberLots, contracts or shares
Risk $NumberWhat a full stop-out costs; the R formula is built on it
P&L $NumberThe result in money, after costs if you have them
R multipleFormulaP&L divided by risk (delete the imported column, add the formula)
Followed plan (Y/N)SelectY or N: separates bad luck from broken rules
EmotionSelectCalm, FOMO, Hesitant, Revenge and so on
MistakeSelectOne tag per error, so each habit gets a price
NoteText, or the titleOne sentence on why you took it
ResultFormula (new)Win, Loss or Breakeven, for filters
Plan break RFormula (new)The R of trades where you broke the plan
ChartFile (new)A screenshot with entry, stop and exit

To change a type later, open any trade, hover a property, click the ⋮⋮ handle to its left and change the property type.

Three Notion formulas to paste in

To add one: select the slider icon at the top of the database, then Edit properties > New property > Formula, name it, and select Edit formula. Each formula below uses only functions on Notion's formula syntax page.

1. R multiple. Name it R multiple. It divides the money result by the money at risk and rounds to 2 places:

round(prop("P&L $") / prop("Risk $"), 2)

If you mapped P&L $ or Risk $ to Text, wrap each one in toNumber, which reads a number from text:

round(toNumber(prop("P&L $")) / toNumber(prop("Risk $")), 2)

Fill Risk $ on every trade. Without it there is no R.

2. Result. Win, Loss or Breakeven, using ifs, which returns the value for the first true condition:

ifs(prop("P&L $") > 0, "Win", prop("P&L $") < 0, "Loss", "Breakeven")

If P&L $ came in as Text, use toNumber(prop("P&L $")) in both places. A trade still open, with no P&L $ yet, shows Breakeven until you fill it in.

3. Plan break R. Shows the trade's R when you broke the plan, and 0 when you kept it:

if(prop("Followed plan (Y/N)") == "N", prop("R multiple"), 0)

Then add the totals. Click a column's header, hover over Calculate and pick Sum or Average. Average on R multiple is your average R per trade, your expectancy. Sum on Plan break R is what broken rules cost you.

Worked example: the five EXAMPLE rows

Example. These are the made-up rows in the CSV, with round numbers. They are not real trades or trade calls.

RowP&L $Risk $Followed planR multipleResultPlan break R
1, EURUSD400200Y2Win0
2, GBPUSD-200200Y-1Loss0
3, USDJPY200200Y1Win0
4, US500-400200N-2Loss-2
5, EURUSD200200N1Win1
CalculateAverage 0.2Sum -1

Average R of +0.2 a trade, and a net minus 1R from the two plan breaks. Row 4 is the one to read: a moved stop turned a minus 1R loss into minus 2R.

Want the thinking behind the plan column, risk first, each week? Get the free letter

Which views to add to a Notion trading journal

To add a view, select + next to your database name, pick a type and name it. Filters and groups live under the settings menu, in View settings.

Choose "Save for everyone" on a filter if you share the database.

How to journal trades in Notion each day

When Notion stops being enough

Notion is a good notebook for a handful of trades a week. These are the places it gets hard:

When you hit those, a spreadsheet does more maths: our Excel and Google Sheets template has a prop floor sheet and a weekly review, and our guide to stopping revenge trading has formulas that read the trade before. A dedicated journal does the logging too. The RB Trading Pro Journal syncs MT4 and MT5 or takes a CSV, and has a prop firm tracker with drawdown and daily-loss alerts, AI trade reviews and a P&L calendar. The first 50 trades are free, with no card.

What to do this week

What to do this week

Questions traders ask

Is there a free Notion trading journal template?

We do not publish a Notion template. You can build your own in about 15 minutes: import our free CSV into Notion, which turns it into a database, then add three formulas and three views, as this page shows.

How do I make a trading journal in Notion?

Import a CSV of trading columns with Settings, Import, CSV, or type /csv on a page. Map each column to a property type, add formula properties for R multiple and win or loss, then add a calendar view, a view grouped by setup and a filtered view of losing trades.

Can Notion work out the R multiple of a trade?

Yes. Add a formula property with round(prop("P&L $") / prop("Risk $"), 2). Notion's CSV import cannot create formulas, so add it after the import. Use Calculate, then Average, on that column to see your average R per trade.

Is Notion good enough for a trading journal?

For a few trades a week, yes. It gets harder when you want trades to arrive from your broker, a running daily loss across trades or drawdown alerts. A spreadsheet or a dedicated journal handles those better.

Sources and definitions

Every Notion step and formula on this page was checked on Notion's own help pages on 9 Nov 2026:

Notion changes its menus from time to time. If a step looks different, the help pages above are the latest word. Educational, not financial advice.

RB Trading Pro Journal

Stop guessing. Start tracking.

30-day money-back guarantee · Cancel anytime · First 50 trades free

Find your edge →
Trading JournalNotionTemplate