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
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.PDFF&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.ExcelIron Condor & Credit Spread Journal
Track defined-risk option spreads with max loss, margin, adjustments, and net credit received.ExcelDirectional Option Buyer Journal
Premium paid, % move needed, theta bleed, and time-exit rules for CE/PE directional trades.ExcelBank Nifty Futures (NRML) Trend Journal
Points-to-rupee conversion, overnight holds, and trend-follow exits for Bank Nifty futures.ExcelStock F&O Journal (Ban-list & Liquidity Tags)
Individual stock options and futures with F&O ban watch, liquidity warnings, and roll notes.ExcelNet P&L After STT & Brokerage Tracker
Gross-to-net reconciliation with STT, brokerage, and exchange charges for honest F&O review.PDFNSE Holiday + Expiry Calendar 2026
Nifty weekly (Tuesday) and monthly (last Tuesday) expiry dates, NSE holidays, and session notes for planning size and setups.Intraday and cash equity · 5
Nifty/Bank Nifty Intraday Journal (MIS)
MIS product type, session buckets, forced square-off flags, and first-hour vs midday stats.ExcelOpening Range Breakout (ORB) Intraday Log
15-minute opening range, breakout direction, volume confirmation, and session outcome tracking.ExcelFirst-Hour Scalping Journal
Ultra-fast MIS logging with time-of-exit, tick-to-rupee conversion, and overtrading day flags.ExcelCash Equity (CNC) Swing Journal
Delivery holds, multi-day R-multiple, STCG context, and symbol-level swing statistics.ExcelBroker CSV → Metrics Analyzer
Import Zerodha/Dhan exports and auto-calculate win rate, profit factor, max drawdown, and expectancy.Review and discipline · 8
Weekly Friday Review Sheet
Seven-step Friday ritual: tagged trades, losers review, discipline score, and one change for Monday.PDFPre-Trade Checklist (India)
Five binary gates before capital: market filter, setup grade, rupee risk, session context, and rule check.PDFPost-Trade Review Template
Planned vs actual entry, stop honoured, checklist used, emotion present: a post-mortem for each trade.ExcelTrading Mistake & Discipline Log
Log revenge trades, oversizing, FOMO entries, and early exits with rupee cost and corrective action.PDFEmotion & FOMO Tracker
Pre-trade mood, confidence score, FOMO triggers, and post-trade reflection for psychology patterns.PDFTrading Rules One-Pager
Printable one-page rules: market filter, setup criteria, entry trigger, sizing, exits, and logging.PDFTrading Plan Worksheet (Annual ₹ Targets)
Annual rupee goals, process milestones, drawdown tripwires, and allowed setups for the year.ExcelMonthly Performance Report (₹)
Monthly net P&L, setup-level stats, discipline trend, and written reflection in rupees.Risk and strategy edge · 4
Position Sizing Worksheet (Lots + Shares)
Calculate exact lots or shares from capital, risk %, stop distance, and NSE lot size.ExcelRisk Management Dashboard (₹ Drawdown Limits)
Daily loss cap, max drawdown tracker, position size alerts, and rupee risk budget per week.ExcelSetup Edge Tracker by Strategy Tag
Win rate, expectancy, profit factor, and sample size per setup, so you can decide what to scale or retire.ExcelBacktesting & Paper Trade Log
Document historical setup tests, paper trade outcomes, and sample size before going live.Tax and reference · 3
F&O Turnover Worksheet (ITR-3 Filing)
Calculate F&O turnover using the absolute profit method for ITR-3 and audit threshold checks.ExcelAdvance Tax Quarterly Planner for Traders
Estimate Jun/Sep/Dec/Mar advance tax instalments on trading income with buffer notes.PDFOption Greeks Quick-Reference Card (India)
Delta, gamma, theta, vega on one printable page with Nifty/Bank Nifty examples.How to use a template with your journal
Four steps, the same for every spreadsheet here.
- 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.
- 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.
- 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.
- 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 freeTemplate
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: