ExcelFree · no sign-upIntraday and cash equity

Nifty/Bank Nifty Intraday Journal (MIS)

A 19-column Excel log for intraday MIS trades in Nifty and Bank Nifty, with a session tag for when you traded and a flag for positions your broker squared off for you.

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
TimeSymbolSideEntryExitLotsSession TagNet P&LForced Square-off
09:32NIFTY 25000 CELong1121272open+1,865No
13:05NIFTY 25100 PELong85712close−1,890Yes
Illustrative MIS rows, 2 lots of 65. The second was closed by the broker’s auto square-off.
FormatExcel (.xlsx)
Trade Log sheet19 columns
Best forIntraday index traders
Fill itEvery session

What is inside

Intraday results often depend on the hour more than the setup. The Session Tag (open, midday or close) lets you total P&L by part of the day and see if one stretch keeps costing money.

Forced Square-off marks trades your broker closed near the end of the day because you did not. These are exits you did not choose, so count them separately from stop-outs when you score your discipline.

Trade Log · 19 columns

One row per intraday trade.

  • Date
  • Time
  • Symbol
  • Side
  • Product
  • Entry
  • Exit
  • Lots
  • Setup Tag
  • Session Tag
  • Planned ₹ Risk
  • Gross P&L
  • STT
  • Brokerage
  • Net P&L
  • R-Multiple
  • Violations
  • Notes
  • Forced Square-off

Worked example

An exit you did not choose

Bought 2 lots of Nifty 25,100 PE at ₹85 under MIS, planning to exit by 3:00 p.m. The position was left open and auto squared off at ₹71 (illustrative).

Gross P&L
−₹1,820
Net P&L
−₹1,890
R-multiple
−0.97R
Forced
Yes

The loss was within plan, but the exit was not yours. Some brokers also charge a fee for auto square-off; check your contract note.

The numbers

Gross = (71 − 85) × 65 × 2−₹1,820
Net = Gross − charges−1,820 − 70 = −₹1,890
R = Net ÷ ((85 − 70) × 130)−1,890 ÷ 1,950 = −0.97R

Formulas to paste in

The download has headers and a sample row, not formulas. These match its column letters.

Gross P&L (L2), long option, lot size 65
=(G2-F2)*H2*65
Net P&L (O2)
=L2-M2-N2
Net P&L by session
=SUMIF(J:J,"midday",O:O)

How to fill it

  1. Pick three session tagsUse open, midday and close, and define the times once.
  2. Log right after each exitIntraday details fade fast. Fill the row within minutes of closing.
  3. Flag forced exitsSet Forced Square-off to Yes whenever the broker closed the position.
  4. Total by session on FridayUse SUMIF on Session Tag to see which part of the day pays.

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

Questions traders ask

What time does MIS auto square-off happen?

It depends on the broker and the segment, usually in the last part of the session. Check your broker’s published square-off times and plan your own exit before them.

Can I log Bank Nifty futures here?

Yes. Put BANKNIFTY FUT in Symbol, prices in Entry and Exit, and use a lot size of 30 in your formulas.

Is the Nifty/Bank Nifty Intraday Journal (MIS) 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.