Page 1 of 1

My weekly scalp journal template Google Sheet

Posted: Mon Sep 14, 2026 10:59 pm
by LondonScalper
Weekly scalp journal template (Google Sheet) -- fields that survived declutter.

I have killed more journal columns than I have kept. What remains for the weekly sheet:
  • Date, session, symbol, setup tag
  • R result, hold time, cost/slip tags
  • Process grade (A/B/C) separate from P&L
  • One-word emotion
  • Note (one sentence max)
Sunday: filter C-process and expensive-cost rows first. Then one best and one worst. The sheet is not a diary novel. If a column did not change a rule in ninety days, I delete it.

Happy to compare templates -- what fields do you keep that I dropped, and which ones actually changed your next week?

Sheet hygiene: one tab for raw tickets, one for weekly summary pivots. I do not mix prep notes into the same columns as fills. Colour only process C rows so the eye goes there first. Pretty dashboards that you do not act on are another form of clutter. If you use Google Sheets, lock the header and freeze the tag columns -- small frictions that keep Sunday structured.

Re: My weekly scalp journal template Google Sheet

Posted: Sun Oct 11, 2026 6:53 pm
by Shadow Trader
The process grade separate from P&L is the column that changed the most for me. I'd add one field you might have dropped: planned exit versus actual exit, in R.

That single number showed me I was closing winners at 0.7R on average when the plan said 1.2R. The R result column alone hid it, because those trades were still winners and looked fine.

The ninety day rule for deleting columns is a good one. I deleted a market condition column after a few months because I wrote trending on almost every row, which meant it told me nothing.

The other thing I'd suggest for the sheet is a column for whether the trade was on the plan list or an improvised one. In my case improvised trades made up about 15% of tickets and almost all of the losses.

Do you use dropdowns for the tags, or free text? I found free text drifts, and after a month I had five spellings of the same setup.

Re: My weekly scalp journal template Google Sheet

Posted: Mon Oct 12, 2026 8:44 pm
by Shadow Trader
Coming back to the Sunday review part: how much time does it actually take you? I found the review was where my journal died, not the logging.

When I had more than about eight columns, Sunday took over an hour, and by the third week I was skipping it. Cutting down to your kind of list got it to around 20 minutes, which I can keep up.

One trick that helped was a pivot that counts trades per setup tag per week, next to the average R. If a setup has fewer than five trades in a week, I don't judge it at all that week, just carry it forward.

Otherwise I kept reacting to two bad trades on a setup and changing a rule that was fine.

The other edge case is weeks with very few trades. I still do the review, but only the process grades, because the R numbers on five tickets are noise.

Do you have a minimum sample before a weekly review changes a rule?

Re: My weekly scalp journal template Google Sheet

Posted: Tue Oct 13, 2026 8:50 am
by Fairman
LondonScalper wrote: Process grade (A/B/C) separate from P&L
What decides the letter? This is the column that makes the Sunday filter work, so the rules behind it matter more than any other field. If the grade is given after the trade closes, even with good intentions a winner tends to drift up to an A and a loser down to a B. Two ways around that: grade at entry, before the result exists, or define each letter by a checklist, for example A means every item on the plan was met, B means one item missed, C means a rule was broken. Which way does your sheet work, and do you ever go back and regrade when the screenshot tells a different story from the note?

Re: My weekly scalp journal template Google Sheet

Posted: Sun Nov 01, 2026 8:22 pm
by FXS Prop Desk
Grading at entry is the key point. A checklist-based grade has another advantage: it can be checked later by someone else, or by yourself weeks after. If the A grade means every item was met, a quick review of the screenshots will confirm it. A grade based on feeling cannot be checked at all. Over time, the checklist version also shows which item, when missing, makes the most difference to results.