Choosing Which Numbers to Track in Your Journal
A journal with fifty columns will not be maintained. A journal with three will not teach you much. The right set is small, and each field earns its place by answering a question you will actually ask.
Start with identification fields: date, time, pair, direction, and session. These let you slice results later.
Add execution fields: entry price, stop price, target price, exit price, lot size, and risk in currency and as a percentage of the account. From these you compute the result in R.
Add classification fields: setup name, timeframe, higher-timeframe trend, and whether a news event was near. These show which setups and conditions pay.
Add behavior fields: whether the trade followed the plan, and a one-word emotional state at entry. This is where much of the learning hides.
Add cost fields: spread at entry, commission, and swap. Many traders skip these and overestimate their edge.
Finally, add a short free-text note for the reasoning, and a link or file name for a screenshot.
That is about twenty fields, but most are quick selections or automatic calculations. Use dropdowns where possible to keep categories consistent, since typing "breakout" three different ways ruins later analysis.
Review the fields every few months and remove any you have never used.
Practical step: list your journal fields, and beside each write the question it helps you answer. Delete any without an answer.
Choosing Which Numbers to Track in Your Journal
Choosing Which Numbers to Track in Your Journal
It’s Fairman 
Re: Choosing Which Numbers to Track in Your Journal
Dropdowns are the unsung hero here. My early journal had breakout, BO and brk for the same setup, and the stats by setup were useless until I cleaned it up. In Google Sheets or Excel you can use data validation to turn a column into a fixed list, which takes a couple of minutes to set up. Do the same for session, pair, direction and the emotion field. Then every filter and formula works without surprises. It also speeds up logging, because you're picking from a short list instead of typing. Anything that makes the journal faster to fill in is worth doing, since the best journal is the one you actually keep using.
It’s Fairman 
Re: Choosing Which Numbers to Track in Your Journal
I'd keep the emotion field to a single word on purpose. If it's a paragraph, you'll stop filling it in after a week. A fixed short list works even better, something like calm, bored, anxious, frustrated, excited, tired. With six or seven options you can later count how each one performs. Most people discover that trades entered while bored or frustrated have clearly worse results than calm ones, and once you see it in your own numbers it's hard to ignore. The free text note is where you can explain more if something unusual happened. The single word is just for the statistics, so keep it quick and honest.
It’s Fairman 
-
Shadow Trader
- Posts: 5594
- Joined: Wed Sep 09, 2026 5:19 pm
Re: Choosing Which Numbers to Track in Your Journal
One field worth adding to the execution group is the maximum adverse excursion, meaning how far price went against the trade before it closed. It takes ten seconds to read off the screen and it answers a question the other fields cannot, whether the stop is too wide or too tight.
Say you look back at 40 winning trades and most of them never went more than a third of the way to the stop. That suggests the stop could be tighter and the position larger for the same risk, though it needs a decent sample before acting on it.
Maximum favourable excursion is the mirror image. If winners regularly reach twice the target before turning, the exit rule is leaving money behind.
On the emotion dropdown, one more option worth having is confident. Overconfidence after a run of wins tends to produce different mistakes from boredom, mostly oversizing rather than forced entries.
The other trap with twenty fields is filling them in at the end of the day from memory. Do people log during the trade, right after it closes, or in one batch after the session?
Say you look back at 40 winning trades and most of them never went more than a third of the way to the stop. That suggests the stop could be tighter and the position larger for the same risk, though it needs a decent sample before acting on it.
Maximum favourable excursion is the mirror image. If winners regularly reach twice the target before turning, the exit rule is leaving money behind.
On the emotion dropdown, one more option worth having is confident. Overconfidence after a run of wins tends to produce different mistakes from boredom, mostly oversizing rather than forced entries.
The other trap with twenty fields is filling them in at the end of the day from memory. Do people log during the trade, right after it closes, or in one batch after the session?
-
FXS Prop Desk
- Posts: 1689
- Joined: Wed Oct 07, 2026 9:52 am
Re: Choosing Which Numbers to Track in Your Journal
A field that earns its place quickly is "planned versus actual": whether the trade followed the plan fully, partly, or not at all. Combined with the result in R, it separates losses caused by the system from those caused by execution. After a few months, that single field often explains more about performance than any of the price-based fields.
Reviewing the field monthly, rather than per trade, keeps the habit light.
Reviewing the field monthly, rather than per trade, keeps the habit light.
FXS Official Team | The Idea Lab & Strategy
-
Shadow Trader
- Posts: 5594
- Joined: Wed Sep 09, 2026 5:19 pm
Re: Choosing Which Numbers to Track in Your Journal
One risk with twenty fields is that slicing them together leaves very few trades in each group. Say a journal holds 200 trades, then five setups across three sessions already makes 15 groups averaging about 13 trades, and adding six emotion tags spreads it to roughly two per cell.
At that size almost any pattern can appear by chance. A sensible rule is to look at one field at a time and only cross two fields once each group has around 30 trades.
A field that is cheap and surprisingly telling is the trade number within the day. It fills itself in if the journal has a date and time, and it shows whether the third trade of a session behaves differently from the first.
Time held is another one that can be calculated rather than typed. Comparing it between winners and losers often shows losers being held longer than the plan allows.
On the dropdown idea, it pays to freeze the list once trading starts. Adding a new setup name every few weeks splits the history into pieces that never get big enough to judge, so do people here merge rare setups into a catch all category?
At that size almost any pattern can appear by chance. A sensible rule is to look at one field at a time and only cross two fields once each group has around 30 trades.
A field that is cheap and surprisingly telling is the trade number within the day. It fills itself in if the journal has a date and time, and it shows whether the third trade of a session behaves differently from the first.
Time held is another one that can be calculated rather than typed. Comparing it between winners and losers often shows losers being held longer than the plan allows.
On the dropdown idea, it pays to freeze the list once trading starts. Adding a new setup name every few weeks splits the history into pieces that never get big enough to judge, so do people here merge rare setups into a catch all category?
-
Shadow Trader
- Posts: 5594
- Joined: Wed Sep 09, 2026 5:19 pm
Re: Choosing Which Numbers to Track in Your Journal
Magic numbers and order comments are tags attached to orders, mostly used by automated systems. They look unimportant until something goes wrong.
When several strategies or experts run on one account, the magic number identifies which one opened each trade. Without it, a script might close or modify trades that belong to a different one. With manual trading mixed in, the confusion gets worse.
Comments help with tracking and review. A short tag showing the setup type and the session makes later analysis easier, and it appears in the account history without extra work.
Good habits include using a distinct magic number per strategy, never reusing numbers across accounts without checking, and setting comments that include a version label for the strategy.
It also pays to test the behaviour of the system when the platform restarts. Some scripts lose track of trades they opened before the restart if the identification was not handled properly.
When a platform is restarted, scripts relying on stored magic numbers need to rediscover existing positions. Logging the number of open trades per magic number at start-up catches orphaned positions early.
How do you keep track of which trades belong to which strategy when several run together?
When several strategies or experts run on one account, the magic number identifies which one opened each trade. Without it, a script might close or modify trades that belong to a different one. With manual trading mixed in, the confusion gets worse.
Comments help with tracking and review. A short tag showing the setup type and the session makes later analysis easier, and it appears in the account history without extra work.
Good habits include using a distinct magic number per strategy, never reusing numbers across accounts without checking, and setting comments that include a version label for the strategy.
It also pays to test the behaviour of the system when the platform restarts. Some scripts lose track of trades they opened before the restart if the identification was not handled properly.
When a platform is restarted, scripts relying on stored magic numbers need to rediscover existing positions. Logging the number of open trades per magic number at start-up catches orphaned positions early.
How do you keep track of which trades belong to which strategy when several run together?