Notion trading journal template: build one in 15 minutes

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
- Download the CSV: trading-journal-template.csv. No email needed. It has 17 columns and 5 rows marked EXAMPLE.
- Start the import. In Notion, go to Settings > Import > CSV, or type
/csvon a page. - Upload the file and choose to create a new database.
- Pick where it goes, then map each CSV column to a property type, using the table below.
- 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:
- No formulas come in. A new CSV import cannot create formulas or rollups, so you add them afterwards (below).
- Negative numbers can trip it. If P&L $ or other numbers do not import correctly, Notion says to map that column to Text. The formulas below have a version for that.
- Check the dates. Notion says dates import in MM/DD/YYYY format. Our file uses 2026-11-02, so check the first example row reads 2 November 2026.
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.
| Property | Type | What it is for |
|---|---|---|
| Date | Date | The calendar view, and results by day and month |
| Time | Text | The entry time, for results by session |
| Market | Select | Finds the markets that quietly cost you |
| Direction | Select | Long or Short |
| Setup | Select | A fixed list of 5 to 8 names, so setups can be grouped |
| Entry, Stop, Target, Exit | Number | The plan and what really happened |
| Size | Number | Lots, contracts or shares |
| Risk $ | Number | What a full stop-out costs; the R formula is built on it |
| P&L $ | Number | The result in money, after costs if you have them |
| R multiple | Formula | P&L divided by risk (delete the imported column, add the formula) |
| Followed plan (Y/N) | Select | Y or N: separates bad luck from broken rules |
| Emotion | Select | Calm, FOMO, Hesitant, Revenge and so on |
| Mistake | Select | One tag per error, so each habit gets a price |
| Note | Text, or the title | One sentence on why you took it |
| Result | Formula (new) | Win, Loss or Breakeven, for filters |
| Plan break R | Formula (new) | The R of trades where you broke the plan |
| Chart | File (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.
| Row | P&L $ | Risk $ | Followed plan | R multiple | Result | Plan break R |
|---|---|---|---|---|---|---|
| 1, EURUSD | 400 | 200 | Y | 2 | Win | 0 |
| 2, GBPUSD | -200 | 200 | Y | -1 | Loss | 0 |
| 3, USDJPY | 200 | 200 | Y | 1 | Win | 0 |
| 4, US500 | -400 | 200 | N | -2 | Loss | -2 |
| 5, EURUSD | 200 | 200 | N | 1 | Win | 1 |
| Calculate | Average 0.2 | Sum -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.
- Calendar. A Calendar view shows each trade on its Date, so busy days and gaps show at a glance.
- By setup. A Table or Board, then View settings > Group > Setup. Read the R multiple column inside each group.
- Losing trades. A Table with View settings > Filter, on Result, set to Loss. Read the Mistake and Emotion columns.
- Plan breaks, if you want a fourth: filter on Followed plan (Y/N), set to N.
Choose "Save for everyone" on a filter if you share the database.
How to journal trades in Notion each day
- At entry: add a new page. Fill Date, Time, Market, Direction, Setup, Entry, Stop, Target, Size and Risk $.
- At the close: fill Exit, P&L $, Followed plan, Emotion and Mistake. R multiple and Result work themselves out.
- Add the chart to the Chart property while it is still on screen.
- Once a week: open the By setup and Plan breaks views. Our guide to how to review trades has the 30-minute routine.
When Notion stops being enough
Notion is a good notebook for a handful of trades a week. These are the places it gets hard:
- Every trade is typed or imported by you. Notion's import help covers files such as CSV. It describes no broker connection, so MT4 or MT5 history comes in by hand.
- Formulas work page by page. Notion's formula help shows them reading a page's own properties and pages linked to it. A running daily loss, or "minutes since my last loss", needs relations and rollups you build and keep up.
- No drawdown alerts. Nothing in the setup above warns you as a day nears your daily loss limit, or as a trailing drawdown closes in.
- Prop rules need care. Firms measure daily loss and max loss in different ways. Check yours on our prop firm rules pages.
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
- Download the free CSV
- Import it: Settings > Import > CSV
- Set the property types, delete the examples
- Add the R multiple and Result formulas
- Add the calendar, setup and losing-trade views
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:
- Import data into Notion: the CSV import, Merge with CSV, dates, numbers and the no-formulas rule
- Formulas: adding a formula property
- Formula syntax: prop, round, ifs, if, toNumber and the comparison operators
- Database properties: Number, Select, Date, Text, Formula and File
- Views, filters and sorts: adding views, Calendar, Group and Filter
- Tables: Calculate, Sum and Average
- Intro to databases: changing a property type
- Terms: R-multiple, expectancy, win rate
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.
Stop guessing. Start tracking.
30-day money-back guarantee · Cancel anytime · First 50 trades free
Find your edge →