Notion forex trading journal template: fields and automation
Forex trades are short, frequent and spread across sessions. Here are the Notion fields that matter, and how to stop typing them in.
What a forex journal needs in Notion
Forex trades are short, frequent and spread across pairs and sessions. A generic stock journal misses the fields that matter most for forex. Here is what to add to a trades database.
| Field | Type | Why forex needs it |
|---|---|---|
| Pair | Select | Group results by EURUSD, GBPUSD, USDJPY and so on |
| Direction | Select | See whether you do better long or short |
| Lots | Number | Check sizing consistency |
| Open time, Close time | Date with time | Derive the session and spot trades right after a loss |
| Session | Select (Asian, London, New York) | Compare sessions; fill it from the open time |
| Stop (pips), Target (pips) | Number | Planned risk and reward in pips |
| Result | Number | Profit or loss in account currency, after commission and swap |
| Account | Select or relation | Separate personal and prop accounts |
| Plan followed | Select | Rule adherence is the strongest single predictor you can track yourself |
| Notes | Text | Why you took it, what you would change |
A simple session formula idea
You can add a formula property that reads the hour of the open time and returns a session label. Keep it simple: for example, a formula that checks whether the hour falls in a range and returns Asian, London or New York. Check your broker's server time first, because MT5 times follow the server clock, not your local clock.
Prop firm and multiple accounts
If you trade a challenge account and a funded account, give each its own Account value (or its own database) so results do not blend. See the journal for prop firm traders.
Where a template stops
A Notion forex template is only a layout. MetaTrader 5 cannot send trades to it, so every pair, lot size and time is typed by hand. For a free starting point, download the free Notion trading journal template. For what to record in a forex journal generally, see the forex trading journal guide.
Want the Trades database to fill itself? If you connect Notion, AI Trading Journal creates a daily database and a linked Trades database in your own Notion workspace and writes each closed MetaTrader 5 trade into them about every 5 minutes, with a Notes field it never overwrites. It is Windows-only and MT5-only, with a 7-day free trial and a one-time $19.99. Notion has no built-in link to MT5, so templates alone cannot do this.
What to review weekly
- Which pairs made or lost money this week?
- Which session produced most of the losses?
- Did lot size stay inside your plan?
- How many trades broke your rules, and what did they cost?
The weekly trading review checklist turns these into a 20-minute routine.
An honest note on privacy. Notion is itself a cloud service, so your trades do sit on Notion's servers, in your own workspace, under your own account and token. What AI Trading Journal removes is the extra middleman: there is no separate journal vendor holding your trades and no broker login sent to a website. No tool is risk-free, so protect your accounts, including Notion if you connect it, with a strong password and two-step verification.
This page is general education. It is not trading or investment advice.
A session formula you can paste (adjust the hours)
Notion formulas can read the hour of a date. This example assumes your broker's server time puts the Asian session at hours 0 to 7, London at 8 to 12 and New York from 13 on. The hours are only an illustration, so replace them with the sessions you actually trade, in your broker's server time:
if(hour(prop("Open time")) < 8, "Asian", if(hour(prop("Open time")) < 13, "London", "New York"))
Name the property the formula uses exactly as it appears in your database. Formula syntax can differ between Notion versions, so check it in the formula editor. If you would rather not use a formula, a Select property that you set when you tag the trade works as well.
Views worth creating for a forex journal
| View | How | What it answers |
|---|---|---|
| By pair | Table grouped by Pair, showing the sum of Result | Which pairs make or lose money |
| By session | Table grouped by Session | Where your edge is, and where you leak |
| Rule breaks | Table filtered to Plan followed = No | The trades to read first each week |
| Losers this week | Filter: last 7 days, Result below zero | The Friday review list |
| Daily calendar | Calendar view on the daily database | Streaks and worst days |
Pips and money: record both
Pips tell you about the quality of your entries and exits across pairs; money tells you what you actually made. The two can disagree: a 40-pip winner on 0.10 lots earns $40 on EURUSD, while a 15-pip loser on 1.0 lot costs $150. Storing the stop and target in pips, the lot size, and the result in account currency lets you see whether your sizing is working for or against your pip results. Add a Spread property if you notice costs eating into short trades.
A short weekly forex review in the database
- Open the By pair view for the last 7 days and note the best and worst pair.
- Open the By session view and see which session produced the largest loss.
- Open Rule breaks and read each note.
- Compare the largest lot size this week with your plan.
- Write the one change for next week at the top of a weekly page and link it to the week's trades.
To make the numbers fill themselves, see how to journal MT5 trades in Notion automatically, and for a full dashboard, the Notion trading dashboard. The calculators on this site, such as the position size calculator, help you fill the stop, target and lot fields correctly.
Frequently asked questions
What fields should a forex trading journal have in Notion?
Is there a free Notion forex trading journal template?
Can I automate a Notion forex journal from MT5?
Related guides
- A local trading journal for MT5
- P&L calendar for MT5
- Trade notes, ratings and screenshots
- Trading progress and goals
- Back up your journal and move it to a new PC
- An offline trading journal for Windows
- How to set monthly trading goals
- Import your whole MT5 history
- How to tag trades
- Trade screenshots for your journal
- All trading journal comparisons
Fill your Notion forex journal automatically
Free for 7 days, no card required. After that, a one-time $19.99 purchase. No subscription. Also on the Microsoft Store.
One-time $19.99, no monthly fee · your MT5 login never leaves your PC · trades go into your own journal on your PC, not through our servers.
Start free 7-day trial