First-Hour Scalping Journal
A 10-column Excel log built for speed: time, symbol, seconds in trade, net P&L, a running trade count and an overtrading flag for the first hour of the session.
The .xlsx opens in Excel, LibreOffice or Google Sheets (upload it to Drive, then open with Sheets). Delete the sample row before you log real trades.
See a worked example →| Time | Symbol | Side | Sec in Trade | Net P&L | Trades Today | Overtrading? |
|---|---|---|---|---|---|---|
| 09:18 | NIFTY CE | Long | 45 | +620 | 1 | No |
| 09:31 | NIFTY PE | Long | 70 | +530 | 3 | No |
| 09:52 | NIFTY CE | Long | 25 | −410 | 6 | Yes |
What is inside
Scalping errors come in clusters. A trader who is fine for three trades often takes the next six to win back one loss. Trades Today and Overtrading? make that point visible on the row where it happened.
Seconds in Trade helps too. If your winners last 40 to 90 seconds and your losers last five minutes, you are holding losers in hope, and the fix is a time stop.
Trade Log · 10 columns
One short row per scalp.
- Time
- Symbol
- Side
- Sec in Trade
- Entry
- Exit
- Net P&L
- Trades Today
- Overtrading?
- Notes
Worked example
A morning that ran past the cap
Nine scalps by 10:15. The first three made a net ₹1,150; the six after the cap lost a net ₹2,400 (illustrative).
Stopping at the cap would have ended the day ₹1,150 up. Count overtrading days each month.
The numbers
Formulas to paste in
The download has headers and a sample row, not formulas. These match its column letters.
- Trades Today (H2), times in column A
- =COUNTIF($A$2:A2,"<>")
- Overtrading? (I2), cap of 5
- =IF(H2>5,"Yes","No")
How to fill it
- Set your daily capPick a maximum number of trades for the first hour and write it at the top of the sheet.
- Log every scalpEven a 20-second trade gets a row. Missing rows hide overtrading.
- Stop when the flag turns YesTreat the flag as a hard stop for the day.
- Count flagged daysEach month, compare P&L on flagged and unflagged days.
Same review, without the typing
TradeLyser imports trades from supported Indian brokers by sync or CSV, with charges, and shows win rate, profit factor and drawdown for each strategy.
Related templates
Read next
Free calculators
Terms on this sheet
Questions traders ask
How many trades is overtrading?
It depends on your setup, but pick a number in advance. If your results after trade five are worse than before it, five is your cap.
Do charges matter for scalping?
Yes. A one-lot Nifty option round trip costs about ₹50 to ₹60 in brokerage, STT, exchange charges, GST and stamp duty (illustrative), so small moves can turn net negative.
Is the First-Hour Scalping Journal free?
Yes. The download link on this page needs no sign-up or email. The workbook ships with column headers and one sample row; add your own formulas or use the ones listed on this page.