By VestAI Research | Published: April 2026 | 11 min read
Free Trading Journal Template (Excel + App) for Indian Traders
Every profitable trader tracks their trades. But most Indian traders who want to start journaling face a simple problem: where do you begin? What exactly should you track? How do you calculate the real P&L after STT, stamp duty, and other Indian charges? This guide gives you a complete trading journal template structure that works in Excel or Google Sheets, explains every field you should track and why it matters, and then shows you why a purpose-built app like VestAI can save you hours of manual work every week.
Skip the Spreadsheet — Use VestAI’s Free Journal
Auto charge calculation, Zerodha CSV import, calendar heatmap, and AI analysis. No manual formulas.
Open Trading Journal — FreeWhat Every Indian Trader Should Track
A trading journal is only as useful as the data you put into it. Track too little and you miss critical patterns. Track too much and you abandon the journal because it takes too long to fill. Here are the essential fields that give you maximum insight with minimum effort:
Trade Identification
Date, time, symbol (e.g., RELIANCE, NIFTY 24500 CE), exchange (NSE/BSE), and segment (equity delivery, intraday, futures, options). This is the foundation — every other metric depends on these fields being accurate.
Entry and Exit Details
Entry price, exit price, quantity (or lot size for F&O), and direction (long/short). For options, also record the strike price, expiry date, and premium paid or received. These fields let you calculate gross P&L and hold time.
Indian Trading Charges
STT, stamp duty, exchange transaction charges, SEBI turnover fee, brokerage, and GST. These vary by segment — STT on equity delivery is 0.1% on both buy and sell sides, but on intraday it is 0.025% on sell side only. Options have different STT on exercise vs. square-off. Getting these right is critical for knowing your true net P&L.
Strategy and Setup
Tag each trade with the strategy you used — breakout, pullback, VWAP, support/resistance, moving average crossover, earnings play, etc. Over 50+ trades, this reveals which strategies have positive expectancy and which ones you should stop using.
Emotional State
Before entering the trade, note your emotional state: calm/planned, anxious, FOMO (fear of missing out), revenge (after a loss), or overconfident (after a big win). This is the most powerful field in any trading journal — it exposes the behavioral patterns that are silently destroying your capital.
Notes and Observations
A free-text field for anything else: market conditions (trending, choppy, gap-up/down), news events (RBI policy, earnings, global cues), what you did right, what you did wrong, and what you would do differently next time. These notes become invaluable during weekly reviews.
Excel Trading Journal Template Structure
Here is the column-by-column structure for a trading journal in Excel or Google Sheets. You can create this yourself in under 30 minutes:
| Column | Field Name | Example | Formula / Notes |
|---|---|---|---|
| A | Date | 20-Apr-2026 | Manual entry |
| B | Time | 09:22 | Entry time (IST) |
| C | Symbol | RELIANCE | NSE symbol |
| D | Segment | Intraday | Delivery / Intraday / Futures / Options |
| E | Direction | Long | Long / Short |
| F | Quantity | 100 | Shares or lots |
| G | Entry Price | 2,450.50 | Manual entry |
| H | Exit Price | 2,478.00 | Manual entry |
| I | Gross P&L | ₹2,750 | =(H-G)*F (for longs) |
| J | Brokerage | ₹40 | ₹20/order x 2 (Zerodha) |
| K | STT | ₹62 | Varies by segment (see charge table) |
| L | Other Charges | ₹28 | Stamp + Exchange + SEBI + GST |
| M | Net P&L | ₹2,620 | =I-J-K-L |
| N | Strategy | Breakout | Use consistent tags |
| O | Emotion | Calm | Calm / FOMO / Revenge / Anxious |
| P | Notes | Clean breakout above resistance | Free text |
Tips for Setting Up the Template
- Use data validation dropdowns for Segment, Direction, Strategy, and Emotion columns to maintain consistency
- Create a separate sheet called “Charge Rates” with all Indian charge percentages, and reference those cells in your formulas — this way you update rates in one place when they change
- Use conditional formatting to color profitable trades green and losing trades red
- Create a summary sheet with SUMIF and COUNTIF formulas for strategy-wise and month-wise P&L
- Back up your spreadsheet regularly — losing your trade data is painful
How to Calculate Indian Charges in Excel
This is where most spreadsheet-based journals fall apart. Indian trading charges are complex — they vary by segment, by buy/sell side, and some are calculated on turnover while others are calculated on premium or settlement value. Here is a simplified breakdown:
STT (Securities Transaction Tax)
Equity Delivery: 0.1% on both buy and sell turnover. Intraday: 0.025% on sell-side turnover only. Futures: 0.02% on sell-side turnover. Options: 0.1% on sell-side premium (on exercise, 0.125% of settlement value). In Excel, use an IF formula based on the Segment column to apply the correct rate.
Stamp Duty
Charged on buy-side only. Equity Delivery: 0.015%. Intraday: 0.003%. Futures: 0.002%. Options: 0.003%. This is a relatively small charge but adds up for active traders.
Exchange Transaction Charges + SEBI Fee + GST
Exchange charges vary (NSE charges different rates for different segments). SEBI fee is ₹10 per crore of turnover. GST is 18% on (brokerage + exchange charges). Building accurate formulas for all of these in Excel is tedious and error-prone — and the rates change periodically.
For a detailed breakdown of all Indian trading charges by segment, see our complete trading journal guide which includes the full charge table for equity delivery, intraday, futures, and options.
Why Trading Journal Apps Beat Spreadsheets
Spreadsheets are a great starting point, but most traders who use them seriously for more than 2-3 months hit the same walls. Here is why a purpose-built trading journal app is worth considering:
Auto Charge Calculation
Apps like VestAI calculate STT, stamp duty, exchange charges, and GST automatically for every trade type. No formulas to build, no rates to update manually. You enter a trade and see the true net P&L instantly.
CSV Import from Brokers
Instead of typing each trade manually, import your Zerodha tradebook CSV in one click. VestAI parses all fields — symbol, quantity, price, trade type — automatically. This saves hours per week for active traders. Read the step-by-step process in our Zerodha journal guide.
Visual Analytics
Calendar heatmaps, P&L charts, strategy-wise breakdowns, and day-of-week analysis are built in. In Excel, you would need to create charts manually and update them as new data comes in. An app does this automatically and presents the data in a more intuitive visual format.
AI-Powered Pattern Detection
This is something spreadsheets simply cannot do. Orion, VestAI’s AI engine, reads your complete trade history and detects behavioral patterns: revenge trading sequences, FOMO vs. planned trade performance, overtrading on volatile days, and your best/worst trading hours. No formula can replicate this kind of analysis.
Consistency and Discipline
The number one reason traders abandon spreadsheet journals is that manual data entry gets tedious. An app with CSV import and auto-calculation removes the friction. The easier it is to log trades, the more likely you are to actually do it consistently.
No Formula Maintenance
When Indian charge rates change (STT rates were last revised by the government in the 2024 budget), you need to update every formula in your spreadsheet. An app handles this automatically — the developers update the rates and every user benefits immediately.
When a Spreadsheet Journal Makes Sense
To be fair, there are situations where a spreadsheet journal is the right choice:
- Low trade frequency: If you take 2-5 trades per week (delivery or swing trades), manual entry is manageable and the overhead is minimal.
- Custom analysis needs: If you want to track highly specific metrics or run custom analysis that no app supports, Excel’s flexibility is unmatched.
- Learning phase: Building a journal from scratch in Excel forces you to understand every charge and every metric. This educational value is real — many traders learn more about Indian charges by building the formulas than by reading about them.
- Privacy concerns: A local Excel file stays on your computer. If you are uncomfortable storing trade data in the cloud, a spreadsheet gives you full control over your data.
The best approach for many traders is to start with a spreadsheet to understand the fundamentals, then migrate to an app like VestAI once the manual work becomes a barrier to consistency. For a broader comparison of journal apps, see our best trading journal apps in India guide.
Ready to Move Beyond Spreadsheets?
VestAI’s trading journal automates everything — charges, analytics, pattern detection. Free forever, no credit card needed.
Open Trading Journal — FreeImport your Zerodha CSV and see your real P&L in under 2 minutes.
Frequently Asked Questions
Can I use Google Sheets instead of Excel for my trading journal?
Yes, Google Sheets works well and is completely free. The template structure described in this article works in both Excel and Google Sheets. Google Sheets has the added benefit of cloud access from any device and the GOOGLEFINANCE() function for live stock prices. However, Google Sheets is slower than Excel for large datasets (500+ trades).
How many columns should a trading journal have?
A good trading journal for Indian traders should have at least 15-18 columns: Date, Time, Symbol, Segment (Equity/F&O), Trade Type (Buy/Sell), Quantity, Entry Price, Exit Price, Gross P&L, STT, Stamp Duty, Exchange Charges, GST, Net P&L, Strategy, Emotional State, and Notes. You can add more columns as needed — lot size for F&O, strike price and expiry for options, hold time, risk-reward ratio, etc.
Why should I track emotions in my trading journal?
Emotions drive most trading mistakes. When you tag each trade with your emotional state (calm, anxious, FOMO, revenge, overconfident), you can later compare the win rate and P&L of trades taken in different emotional states. Most traders discover that calm, planned trades have 20-30% higher win rates than emotional or FOMO entries. This data-driven insight is more powerful than any willpower-based approach to trading discipline.
Is an app better than a spreadsheet for trading journal?
For most traders, yes. Apps like VestAI automate the tedious parts — Indian charges calculation, CSV import from Zerodha, analytics computation, and pattern detection. A spreadsheet requires you to build and maintain all of this manually. The main advantage of spreadsheets is unlimited customization, but 90% of traders do not need that level of customization — they need automation and consistency.
Want more insights like this?
Get free stock analysis, market insights, and investment ideas delivered to your inbox.
No spam. Unsubscribe anytime.
Related Articles
- Free Trading Journal for Indian Traders — Complete guide to VestAI’s journal with all features
- How to Maintain a Trading Journal — Daily, weekly, and monthly review process
- Best Trading Journal Apps India — Compare 10 journal apps for Indian traders
- Intraday Trading Journal — Special journaling techniques for day traders