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 (free forever).
Excel / Google Sheets Template
Manual spreadsheet with all the right columns for Indian traders. Free to download and customise.
Copy to Google SheetsTJL Pro — Free App
No spreadsheet maintenance. Import from Zerodha, Upstox, Angel One. Auto-calculates everything. AI Coach. Free forever plan.
Start free →What the template tracks
Spreadsheet vs TJL Pro — what's the difference?
| Feature | Excel/Sheets | TJL Pro (Free) |
|---|---|---|
| Manual data entry | Required every trade | CSV import from broker |
| P&L calculations | Manual formulas | Auto-calculated |
| Win rate / Profit factor | Build yourself | Auto-calculated |
| Calendar heatmap | Not available | Built-in ✅ |
| AI Coach feedback | Not available | Pro plan ✅ |
| Mobile access | Awkward | Yes — web app ✅ |
| Effort per week | 2-3 hours | 10-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 Zerodha/Upstox — saving hours of manual entry every week.
Is TJL Pro really free?
Yes. TJL Pro has a free forever plan covering 50 trades/month with 1 account — no credit card needed. It includes trade journal, CSV import from Zerodha/Upstox/Angel One, 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 Zerodha, Upstox, or Angel One 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 from Zerodha, Upstox, or Angel One. Analytics auto-calculated. No formulas needed.
Get started free