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 →| Time | Symbol | Side | Entry | Exit | Lots | Session Tag | Net P&L | Forced Square-off |
|---|---|---|---|---|---|---|---|---|
| 09:32 | NIFTY 25000 CE | Long | 112 | 127 | 2 | open | +1,865 | No |
| 13:05 | NIFTY 25100 PE | Long | 85 | 71 | 2 | close | −1,890 | Yes |
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).
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
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
- Pick three session tagsUse open, midday and close, and define the times once.
- Log right after each exitIntraday details fade fast. Fill the row within minutes of closing.
- Flag forced exitsSet Forced Square-off to Yes whenever the broker closed the position.
- 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.
Related templates
Read next
Free calculators
Terms on this sheet
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.