Advertisement IC Markets

My weekly scalp journal template Google Sheet

Discuss 1-minute to 15-minute price action setups, fading intraday momentum, key support/resistance zones, and proven short-term trading methodologies.
Post Reply
LondonScalper
Posts: 965
Joined: Sat Sep 05, 2026 7:54 am

My weekly scalp journal template Google Sheet

Post 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.
Recommended broker for automated trading & scalping IC Markets
Shadow Trader
Posts: 5594
Joined: Wed Sep 09, 2026 5:19 pm

Re: My weekly scalp journal template Google Sheet

Post 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.
Shadow Trader
Posts: 5594
Joined: Wed Sep 09, 2026 5:19 pm

Re: My weekly scalp journal template Google Sheet

Post 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?
Fairman
Posts: 6955
Joined: Tue Jul 21, 2026 7:11 am
Location: Abuja

Re: My weekly scalp journal template Google Sheet

Post 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?
It’s Fairman :geek:
FXS Prop Desk
Posts: 1692
Joined: Wed Oct 07, 2026 9:52 am

Re: My weekly scalp journal template Google Sheet

Post 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.
FXS Official Team | The Idea Lab & Strategy
Post Reply