ExcelFree · no sign-upF&O and derivatives

Stock F&O Journal (Ban-list & Liquidity Tags)

The 20 option-journal columns plus two more for single stocks: a Ban-list Tag for names in the F&O ban period and a Liquidity Note for wide spreads and slippage.

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
UnderlyingStrikeCE/PELotsEntry PremiumExit PremiumNet P&LBan-list TagLiquidity Note
STOCK A2800CE14449+2,396Bid 40 / Ask 44
STOCK B1500PE13127−2,080ban-watchOK
Illustrative rows with a lot size of 500. Look up each stock’s lot size on the NSE contract list.
FormatExcel (.xlsx)
Trade Log sheet22 columns
Best forStock option traders
Fill itEvery trade

What is inside

Stock options behave differently from Nifty options. Spreads are wider, some strikes barely trade, and a stock can enter the F&O ban period, when new positions are not allowed until open interest falls.

The two extra columns let you filter those trades out. If trades with a liquidity note lose more on average, the fix is to trade fewer names, not to find a new setup.

Trade Log · 22 columns

One row per stock option or future.

  • Date
  • Time
  • Underlying
  • Strike
  • Expiry
  • CE/PE
  • Product
  • Lots
  • Entry Premium
  • Exit Premium
  • Setup Tag
  • Session Tag
  • Planned ₹ Risk
  • Gross P&L
  • STT
  • Brokerage
  • Net P&L
  • R-Multiple
  • Violations
  • Notes
  • Ban-list Tag
  • Liquidity Note

Worked example

The cost of a wide spread

A stock call quoted ₹40 bid and ₹44 ask was bought at ₹44. The fair middle was ₹42, so ₹2 a share went to the spread on entry (illustrative lot of 500).

Spread paid
₹2 a share
Cost per lot
₹1,000
Per round trip
≈ ₹2,000

Write the bid and ask in Liquidity Note when the spread is wide. After a month, compare net P&L on those rows with the rest.

The numbers

Slippage = (Price paid − Mid) × Lot size(44 − 42) × 500 = ₹1,000
Round trip, same spread on exit1,000 × 2 ≈ ₹2,000

Formulas to paste in

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

Gross P&L (N2), lot size in a helper cell X2
=(J2-I2)*H2*X2
Net P&L (Q2)
=N2-O2-P2

How to fill it

  1. Look up the lot sizeStock lot sizes differ by name. Keep each one in a helper column next to the trade.
  2. Check the ban list before entryIf the stock is near or in the F&O ban period, tag it in Ban-list Tag.
  3. Note the spreadWrite the bid and ask in Liquidity Note whenever the spread looks wide.
  4. Filter on both columns monthlyCompare average Net P&L for tagged and untagged trades.

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

Free calculators

Questions traders ask

What is the F&O ban period?

When open interest in a stock’s derivatives crosses the market-wide position limit set by the exchange, the stock enters a ban period. You can reduce existing positions but cannot add new ones until it exits the ban.

Can I log stock futures in this sheet?

Yes. Leave Strike and CE/PE blank and enter the futures price in the premium columns. Use a setup tag that marks it as a future.

Is the Stock F&O Journal (Ban-list & Liquidity Tags) 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.