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 →| Underlying | Strike | CE/PE | Lots | Entry Premium | Exit Premium | Net P&L | Ban-list Tag | Liquidity Note |
|---|---|---|---|---|---|---|---|---|
| STOCK A | 2800 | CE | 1 | 44 | 49 | +2,396 | Bid 40 / Ask 44 | |
| STOCK B | 1500 | PE | 1 | 31 | 27 | −2,080 | ban-watch | OK |
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).
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
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
- Look up the lot sizeStock lot sizes differ by name. Keep each one in a helper column next to the trade.
- Check the ban list before entryIf the stock is near or in the F&O ban period, tag it in Ban-list Tag.
- Note the spreadWrite the bid and ask in Liquidity Note whenever the spread looks wide.
- 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.
Related templates
Read next
Free calculators
Terms on this sheet
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.