Free downloads · Excel and PDF

Free trading journal templates for Indian traders

28 spreadsheets and printable sheets for F&O, intraday, swing trading, risk, review and tax. Columns are built around NSE lots, Tuesday expiries and Indian charges. No sign-up needed.

Updated 18 Oct 2026

Start here

F&O and derivatives · 8

Excel

NSE F&O Options Trading Journal

Log strike, expiry, CE/PE, lots, and net P&L after STT for Nifty, Bank Nifty, and stock options.
PDF

F&O Expiry Week Tracker

Separate expiry-week trades, size rules, and gamma-hour notes for Nifty weekly (Tuesday) and Bank Nifty monthly (last Tuesday) expiry.
Excel

Iron Condor & Credit Spread Journal

Track defined-risk option spreads with max loss, margin, adjustments, and net credit received.
Excel

Directional Option Buyer Journal

Premium paid, % move needed, theta bleed, and time-exit rules for CE/PE directional trades.
Excel

Bank Nifty Futures (NRML) Trend Journal

Points-to-rupee conversion, overnight holds, and trend-follow exits for Bank Nifty futures.
Excel

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

Individual stock options and futures with F&O ban watch, liquidity warnings, and roll notes.
Excel

Net P&L After STT & Brokerage Tracker

Gross-to-net reconciliation with STT, brokerage, and exchange charges for honest F&O review.
PDF

NSE Holiday + Expiry Calendar 2026

Nifty weekly (Tuesday) and monthly (last Tuesday) expiry dates, NSE holidays, and session notes for planning size and setups.

Review and discipline · 8

PDF

Weekly Friday Review Sheet

Seven-step Friday ritual: tagged trades, losers review, discipline score, and one change for Monday.
PDF

Pre-Trade Checklist (India)

Five binary gates before capital: market filter, setup grade, rupee risk, session context, and rule check.
PDF

Post-Trade Review Template

Planned vs actual entry, stop honoured, checklist used, emotion present: a post-mortem for each trade.
Excel

Trading Mistake & Discipline Log

Log revenge trades, oversizing, FOMO entries, and early exits with rupee cost and corrective action.
PDF

Emotion & FOMO Tracker

Pre-trade mood, confidence score, FOMO triggers, and post-trade reflection for psychology patterns.
PDF

Trading Rules One-Pager

Printable one-page rules: market filter, setup criteria, entry trigger, sizing, exits, and logging.
PDF

Trading Plan Worksheet (Annual ₹ Targets)

Annual rupee goals, process milestones, drawdown tripwires, and allowed setups for the year.
Excel

Monthly Performance Report (₹)

Monthly net P&L, setup-level stats, discipline trend, and written reflection in rupees.

How to use a template with your journal

Four steps, the same for every spreadsheet here.

  1. Step 1Pick one log and one review sheetChoose the trade log that matches how you trade (options, intraday, swing) and pair it with the Weekly Friday Review Sheet. Two files are enough to start.
  2. Step 2Set your numbers before the first tradeFill capital, max daily loss and lot sizes (Nifty 65, Bank Nifty 30; check the current NSE circular). Delete the sample row.
  3. Step 3Log every trade the same dayOne row per trade, with a setup tag and net P&L after charges. Missed rows make every average wrong.
  4. Step 4Review on Friday, change one thingTotal the week by setup tag, open the three biggest losers, and write one change for Monday.

Outgrown the spreadsheet?

TradeLyser fills the same columns from your broker and keeps the review numbers up to date.

Try TradeLyser free

Template

Type each trade by hand

Add your own formulas

One file per strategy or month

TradeLyser

Trades arrive by broker sync or CSV import

Win rate, profit factor and drawdown per strategy

Daily journal, rules and calendar in one place

Frequently asked questions

What is a trading journal template?

A spreadsheet or printable page with the columns a trade review needs: date, instrument, size, entry, exit, setup tag, charges and net P&L. You fill one row per trade and read the totals each week.

Are these templates free?

Yes. Every template downloads directly from its page as an Excel file or a PDF. No sign-up or email is needed.

Do the Excel templates work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The workbooks contain headers and a sample row, so nothing breaks in the conversion.

Which template should I start with?

Option traders: the NSE F&O Options Trading Journal. Intraday traders: the Nifty/Bank Nifty Intraday Journal (MIS). Everyone: the Weekly Friday Review Sheet. At tax time: the F&O Turnover Worksheet.

How is a template different from TradeLyser?

A template is a file you fill and maintain yourself. TradeLyser imports trades from supported Indian brokers by sync or CSV and calculates the same numbers for you. The templates are a fine place to start.

Key terms explained

Explore glossary definitions related to Templates: