ExcelFree · no sign-upF&O and derivatives

Bank Nifty Futures (NRML) Trend Journal

A 13-column Excel log for Bank Nifty futures held overnight. It turns stop distance in points into rupee risk and records whether each position was carried overnight.

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
DateSideEntryExitLotsPoints Risk₹ RiskOvernightNet P&LR-Multiple
03/06/2026Long512005085012006,000Yes−11,410−1.90
08/06/2026Short514005095011805,400Yes+12,581+2.33
Illustrative rows for one Bank Nifty lot of 30. Net P&L includes 0.05% STT on the sell side.
FormatExcel (.xlsx)
Trade Log sheet13 columns
Best forPositional futures traders
Fill itEvery trade

What is inside

Bank Nifty futures move in points, but your risk is in rupees. Points Risk times lot size times lots gives ₹ Risk, and that number is what every R-multiple in the sheet is measured against.

The Overnight column matters because a gap can carry price straight through your stop. Filter on it after a month to see whether overnight holds earn enough to justify the gap risk.

Trade Log · 13 columns

One row per futures position.

  • Date
  • Side
  • Entry
  • Exit
  • Lots
  • Points Risk
  • ₹ Risk
  • Overnight
  • Setup Tag
  • Gross P&L
  • Net P&L
  • R-Multiple
  • Notes

Worked example

A stop that did not hold

Long 1 lot of Bank Nifty futures at 51,200 with a 200-point stop, held overnight. It opened lower and was closed at 50,850 (illustrative).

Planned risk
₹6,000
Gross P&L
−₹10,500
Net P&L
−₹11,410
R-multiple
−1.90R

The loss was almost twice the plan because of the overnight gap. Log it in Notes as a gap-through-stop, not as a normal stop-out.

The numbers

₹ Risk = Points Risk × Lot size × Lots200 × 30 × 1 = ₹6,000 (check the current NSE circular, lot sizes are revised periodically)
Gross = (Exit − Entry) × 30(50,850 − 51,200) × 30 = −₹10,500
Charges incl. 0.05% STT on the sell side≈ ₹910
R = Net ÷ ₹ Risk−11,410 ÷ 6,000 = −1.90R

Formulas to paste in

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

₹ Risk (G2)
=F2*30*E2
Gross P&L (J2), long
=(D2-C2)*30*E2
R-Multiple (L2)
=K2/G2

How to fill it

  1. Fill Points Risk at entryWrite the stop distance in points before you place the order.
  2. Mark overnight holdsSet Overnight to Yes for any position carried past the close.
  3. Use contract-note netCopy Net P&L from the contract note so STT and other charges are included.
  4. Compare overnight and intradayEach month, filter on Overnight and compare average R for Yes and No.

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 is the Bank Nifty futures lot size?

30 for contracts from the January 2026 series (check the current NSE circular, lot sizes are revised periodically). Update the formulas if NSE changes it.

How much STT is charged on futures?

From 1 April 2026, STT on futures is 0.05% of the sell-side value. On a 1-lot Bank Nifty exit at 50,850 that is about ₹763.

Is the Bank Nifty Futures (NRML) Trend 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.