ExcelFree · no sign-upIntraday and cash equity

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 →
Trade Log
TimeSymbolSideSec in TradeNet P&LTrades TodayOvertrading?
09:18NIFTY CELong45+6201No
09:31NIFTY PELong70+5303No
09:52NIFTY CELong25−4106Yes
Illustrative scalps. The flag turns Yes once Trades Today passes a cap of 5.
FormatExcel (.xlsx)
Trade Log sheet10 columns
Best forFirst-hour scalpers
Fill itEvery session

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).

First 3 trades
+₹1,150
Trades 4 to 9
−₹2,400
Day net
−₹1,250

Stopping at the cap would have ended the day ₹1,150 up. Count overtrading days each month.

The numbers

Day net1,150 − 2,400 = −₹1,250
Charges at about ₹55 per one-lot round trip9 × 55 ≈ ₹495

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

  1. Set your daily capPick a maximum number of trades for the first hour and write it at the top of the sheet.
  2. Log every scalpEven a 20-second trade gets a row. Missing rows hide overtrading.
  3. Stop when the flag turns YesTreat the flag as a hard stop for the day.
  4. 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.

Try TradeLyser free

Read next

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.