Template guide

Free Trading Journal Template India

A structured trading journal template for Indian traders — works in Excel and Google Sheets. Track every trade, calculate P&L, log mistakes, and measure discipline. Or skip the spreadsheet entirely and use TJL Pro (7-day free trial).

Excel / Google Sheets Template

Prefer a spreadsheet? Make one with these columns and you have the same record TJL Pro keeps for you:

Date · Instrument · Side · Entry · Exit · Size · Stop · Target · R-multiple · Result · P&L · Setup · Rule broken? · Mistake · Notes · Chart link

RECOMMENDED

TJL Pro — Free App

No spreadsheet maintenance. Import a CSV from any broker. Auto-calculates everything. AI Coach. 7-day free trial.

Start free →

What the template tracks

Date & time
Instrument (NIFTY, BANKNIFTY, stock, etc.)
Segment (EQ / F&O / CUR)
Side (BUY / SELL)
Quantity / Lots
Entry price
Stop-loss level
Target price
Exit price
Gross P&L
Brokerage & charges
Net P&L
R:R ratio (auto-calculated)
Win / Loss
Setup name
Trade thesis
Mistakes made
Emotion at entry
Discipline score (1–5)
Notes

Spreadsheet vs TJL Pro — what's the difference?

FeatureExcel/SheetsTJL Pro
Manual data entryRequired every tradeCSV import from broker
P&L calculationsManual formulasAuto-calculated
Win rate / Profit factorBuild yourselfAuto-calculated
Calendar heatmapNot availableBuilt-in ✅
AI Coach feedbackNot availablePro plan ✅
Mobile accessAwkwardYes — web app ✅
Effort per week2-3 hours10-15 minutes

Frequently asked questions

What should a trading journal template for India include?

An Indian trading journal template should track: date, instrument (including F&O contract details), segment (EQ/F&O), entry price, exit price, quantity/lots, net P&L after brokerage, setup name, mistakes, and emotion. NSE/BSE specific fields like lot size, expiry date, and strike price are useful for F&O traders.

Should I use Excel or a trading journal app?

Excel works for tracking raw data but has no automatic performance calculations, no AI analysis, and requires manual upkeep. A dedicated app like TJL Pro auto-calculates win rate, profit factor, equity curve, and lets you import directly from a broker CSV — saving hours of manual entry every week.

Is TJL Pro really free?

Yes. Every TJL Pro account starts with a free 7-day Pro trial — no credit card needed. It includes trade journal, CSV import from any broker, P&L calendar heatmap, performance analytics, mistakes tracker, and rule book.

Can I import my Excel trading log into TJL Pro?

If your Excel data came from a any broker tradebook export, you can upload it directly to TJL Pro. For custom Excel formats, importing directly isn't supported yet — but you can always add trades manually.

Skip the spreadsheet — try TJL Pro free

Import a CSV from any broker. Analytics auto-calculated. No formulas needed.

Get started free