Trading Journal Format: Filled Examples and Daily to Monthly Layouts
Trading journal format for Indian traders: filled example rows for delivery, intraday and F&O trades, plus daily, weekly and monthly review layouts to copy.
A trading journal format is the fixed set of fields you fill for every trade. A good one has five groups of fields. They are the trade details, your plan before entry, the result after exit, the charges you paid, and a short note on your own behaviour. Fill the same fields every time. After a few weeks, the rows show you which setups work and which habits keep costing you.
This page shows that format filled in, for Indian traders. You get three trading journal examples: a delivery trade, an intraday trade and an index option trade, with charges worked out line by line. All three are made up. Then there are layouts for a daily, weekly and monthly review, each with a filled example.
You can copy this format into Excel, Google Sheets, a notebook or a journal app. If you would rather print it, use our trading journal PDF. A ready spreadsheet is linked further down.
Key Takeaways
- 1.Split each row in two: plan fields you fill before the order, and result fields you fill after the exit.
- 2.Always record net P&L, after brokerage, STT, exchange charges, stamp duty and GST. On a small option scalp, charges can eat a large part of the profit.
- 3.F&O trades need extra fields: underlying, expiry, strike, CE or PE, lots and premium.
- 4.The R multiple (your profit or loss divided by the risk you planned) lets you compare trades of any size.
- 5.Review at three levels: a short daily note, a weekly check of your numbers and a monthly look at setups, costs and drawdown.
What a good trading journal format looks like
A format is more than a list of columns. The order of the columns should follow your trading day. You plan, you place the order, you exit, and then you look back. So the fields fall into five groups, in this order.
- Trade details: when, what and how you traded.
- Plan: written before you place the order. Setup, reason, entry, stop, target and size.
- Result: written after you exit. Actual prices, exit reason, profit or loss.
- Charges: everything you paid, so you can see the net result.
- Behaviour and review: did you follow the plan, how did you feel, and what did you learn.
The plan fields matter most, and loose notes usually skip them. If you write the stop and target only after the trade, you will often (without meaning to) pick numbers that make the trade look better. Fill the plan part first, even if it is just three numbers typed on your phone.
Keep the row short enough to fill in a few minutes. A big format that you skip on busy days is worse than a small one you fill every day. Start with the core fields below. Add a new field only when you have a question that needs it. For the habit side of journaling, see how to keep a trading journal.
The core fields, in short
Each row of the format holds these fields, in the five groups above. The sample rows further down show every one of them filled in.
- Trade details: date, entry and exit time, instrument, segment, product type and side (buy, or sell for a short). Copy the product label your broker shows. Zerodha's Kite, for example, uses CNC for delivery, MIS for intraday and NRML for F&O you may carry overnight.
- Plan: setup tag, a one-line reason, planned entry, stop loss, target, quantity and planned risk in rupees.
- Result: actual entry and exit, exit reason and gross P&L.
- Charges: total charges, net P&L and the R multiple (net P&L divided by planned risk).
- Behaviour: followed plan (Yes or No), one emotion word, a mistake tag and a one-line lesson.
Two habits keep these fields useful. Use a fixed list (a dropdown in a sheet) for setup, emotion and mistake, so "brkout" and "breakout" do not split one setup into two. And type the quantity yourself every time, because lot sizes change. For what each field means and why it matters, read what to track in a trading journal. For a ready file with these columns, get our free trading journal template for India.
If you only want the numbers side of this format, our guide to the trade log lists the minimum fields with sample logs.
Extra fields for F&O trades
An option or futures trade needs a few more columns. The same index can trade in many contracts at once, so "Nifty call" alone does not tell you which trade you took.
| Field | What to write | Example |
|---|---|---|
| Underlying | The index or stock the contract is on | NIFTY |
| Expiry date | The contract's expiry date | Next Tuesday's weekly expiry |
| Strike | The strike price | 24,500 (example) |
| CE or PE | Call (CE) or put (PE) | CE |
| Lots and quantity | Lots traded and total units | One lot, quantity typed in by you |
| Premium in and out | Option price per unit at entry and exit | ₹120 and ₹132 |
| Expiry tag | Expiry day, day before expiry, or other day | Expiry day |
| Leg | For spreads, which leg this row is | Bull call spread, leg 1 |
Expiry days change, so take them from the exchange, not from old notes. NSE circular NSE/FAOP/68747 (25 June 2025) moved Nifty weekly contracts to Tuesday. It moved Nifty, Bank Nifty, FinNifty, Midcap Nifty, Nifty Next 50 and all stock monthly contracts to the last Tuesday of the month. This applied to contracts expiring on or after 1 September 2025. The same circular lists only monthly and quarterly Bank Nifty contracts, with no weekly. NSE's F&O consolidated circular NSE/FAOP/73928 (28 April 2026) still lists Tuesday expiries. Check NSE's circulars for any later change before you set up an expiry column.
For spreads and other trades with more than one leg, log one row per leg and give every leg the same strategy tag. Add the legs to get the trade's result. Put the planned risk on the first leg only, so R is not counted twice. Our F&O trading journal guide goes deeper on option-specific notes.
Trading journal examples: three filled sample rows
Here are three trading journal examples. Each one fills the same format for a made-up trade. Row 1 is a delivery trade held for some days. Row 2 is an intraday cash trade. Row 3 is a Nifty call option bought and sold on the same day. None of them are real trades. The charges use the rates on Upstox's charges page, opened on 10 Nov 2026. Brokerage is ₹20 per executed order (for intraday, 0.1% if that is lower). STT and exchange charges were checked against NSE's own circulars. Your broker may charge differently.
| Field | Row 1: Delivery | Row 2: Intraday | Row 3: Index option |
|---|---|---|---|
| Segment and product | Cash, CNC | Cash, MIS | F&O, bought and sold same day |
| Side | Buy | Buy | Buy a call (CE) |
| Setup | Pullback | Breakout | Breakout |
| Planned entry, stop, target | ₹1,500, ₹1,440, ₹1,620 | ₹800, ₹795, ₹812 | ₹120, ₹105, ₹145 |
| Quantity | 20 shares | 100 shares | 100 units (an example number, not a real lot size) |
| Planned risk | ₹1,200 | ₹500 | ₹1,500 |
| Actual entry and exit | ₹1,500 and ₹1,620 | ₹800 and ₹806 | ₹120 and ₹132 |
| Gross P&L | ₹2,400 | ₹600 | ₹1,200 |
| Charges | ₹140.02 | ₹75.73 | ₹77.95 |
| Net P&L | ₹2,259.98 | ₹524.27 | ₹1,122.05 |
| R multiple (net) | 1.88R | 1.05R | 0.75R |
| Followed plan | Yes | No (exited early) | No (exited early) |
| Emotion | Calm | Nervous | Rushed |
| Lesson | Holding to the target paid off | Let trades reach target or stop | Do not exit at the first small dip |
How the charges were worked out
Row 1, delivery. Buy value ₹30,000 (20 shares at ₹1,500). Sell value ₹32,400 (20 shares at ₹1,620). Total turnover ₹62,400.
- Brokerage: ₹20 for each of the 2 orders = ₹40.
- STT (securities transaction tax): 0.1% on the buy and 0.1% on the sell = ₹30 + ₹32.40 = ₹62.40.
- NSE exchange charge: 0.00307% of ₹62,400 = about ₹1.92.
- SEBI fee: ₹10 per crore of turnover = about ₹0.06.
- Stamp duty: 0.015% of the ₹30,000 buy = ₹4.50.
- DP charge (taken when shares leave your demat account; Upstox splits it between CDSL and itself): ₹20 on the sell.
- GST: 18% on brokerage, exchange charge and DP charge = about ₹11.14. This follows Upstox's page. Groww's page also adds GST on the SEBI fee, which changes the total by under one paisa here.
- Total: ₹140.02. Net P&L: ₹2,400 minus ₹140.02 = ₹2,259.98.
Row 2, intraday. Buy ₹80,000, sell ₹80,600. Brokerage is ₹40, because 0.1% of ₹80,000 is ₹80, so the ₹20 cap per order applies. STT is 0.025% on the sell only, ₹20.15. The exchange charge is about ₹4.93, the SEBI fee about ₹0.16, stamp duty 0.003% of the buy is ₹2.40, and GST is about ₹8.09. Total ₹75.73.
Row 3, index option. Premium bought ₹12,000, premium sold ₹13,200. Brokerage is ₹40. STT is 0.15% of the ₹13,200 sell premium, ₹19.80 (the rate since 1 April 2026). The NSE options charge is 0.03553% of ₹25,200 total premium, about ₹8.95. The SEBI fee is about ₹0.03, stamp duty 0.003% of the buy is ₹0.36, and GST is about ₹8.81. Total ₹77.95.
One note on STT for option buyers. Row 3 was sold before expiry, so STT fell on the sell premium. If you hold a bought option to expiry and it is exercised (settled in the money), NSE's circular lists this as a separate STT line. Since 1 April 2026 it is also 0.15%; before that it was 0.125%. Add an "exercised" field to your F&O format so these trades are easy to find. For the full list of charges, see brokerage and charges explained.
What these rows teach
- Row 1: STT on both sides was the biggest cost, but the trade kept most of its gain because the move was large.
- Row 2: the plan said ₹812. The nervous exit at ₹806 gave away half of the planned move. The "Followed plan" field catches this.
- Row 3: the option trade was green, but it made only 0.75R after charges because of the early exit. Brokerage was the largest single charge.
Gross vs net: the small option scalp
Charges hurt most on small, quick trades. Say you buy an option at ₹30 and sell at ₹32, quantity 100 (all made-up numbers). Gross profit is ₹200. At the same rates, charges come to ₹54.70. That is ₹40 brokerage, ₹4.80 STT, ₹2.20 exchange charge, ₹0.09 stamp duty and ₹7.60 GST, plus a SEBI fee of about one paisa. Net profit is ₹145.30. Charges took about 27% of the gross profit. If your format records only gross P&L, a month of trades like this looks far better than it really is.
To see where gross and net P&L appear in your broker's report, read our guide to the P&L report.
Daily journal format
The trade rows hold the detail. A daily note takes a couple of minutes after the close. It catches what the rows miss: your state of mind and whether you kept your daily rules.
| Daily field | What to write | Example |
|---|---|---|
| Trades taken | Count for the day | 2 |
| Plan followed | Trades that followed the plan | 1 of 2 |
| Net P&L | Sum of the day's net P&L | Loss of ₹380 |
| Daily loss limit | Did you stop at your limit? | Yes |
| Biggest mistake | One tag | Moved stop |
| One thing done well | One line | Skipped a trade outside my setups |
| Mood at close | One word | Frustrated |
| Tomorrow | One thing to do or avoid | No entries in the first 15 minutes |
If you like to write these daily notes in your own words, in a notebook or an app, see our guide to keeping a trading diary.
Weekly journal format
Once a week, add up the rows and answer a few fixed questions. Here is a made-up week of 10 trades. Each one had a planned risk of ₹1,000, so the R multiple is easy to read.
| Trade | Setup | Net P&L | R multiple | Followed plan |
|---|---|---|---|---|
| 1 | Breakout | +₹1,800 | 1.8R | Yes |
| 2 | Breakout | -₹1,000 | -1R | Yes |
| 3 | Breakout | +₹2,200 | 2.2R | Yes |
| 4 | Pullback | -₹1,000 | -1R | No |
| 5 | Pullback | -₹600 | -0.6R | No |
| 6 | Pullback | +₹1,500 | 1.5R | Yes |
| 7 | Breakout | -₹1,000 | -1R | Yes |
| 8 | Pullback | +₹900 | 0.9R | Yes |
| 9 | Pullback | -₹1,000 | -1R | No |
| 10 | Breakout | +₹2,400 | 2.4R | Yes |
The weekly format has these fields. The answers come from the example week above.
- Win rate: 5 winners out of 10 trades = 50%.
- Average win: ₹8,800 of total wins divided by 5 = ₹1,760.
- Average loss: ₹4,600 of total losses divided by 5 = ₹920.
- Net P&L: ₹8,800 minus ₹4,600 = ₹4,200.
- Expectancy (the average result per trade): ₹4,200 divided by 10 = ₹420, or 0.42R. You get the same answer from (50% of ₹1,760) minus (50% of ₹920).
- Profit factor (total wins divided by total losses): ₹8,800 divided by ₹4,600 = about 1.91.
- Plan breaks: 3 of 10 trades broke the plan. Together they lost ₹2,600. The seven trades that followed the plan made ₹6,800.
- By setup: Breakout made ₹4,400 over 5 trades. Pullback lost ₹200 over 5 trades.
- One rule for next week: for example, trade the pullback setup at smaller size until you know why it fails.
A warning about small samples: 10 trades are far too few to judge a setup. One week tells you what to watch, not what is true. Look for the same pattern over several weeks before you change your rules. For the maths behind these numbers, see how to calculate trading expectancy and the profit factor calculator.
- Check that every trade of the week is logged, with charges.
- Fill in the summary fields above.
- Sort the rows by setup, then by "Followed plan".
- Read the lesson column and pick the mistake that cost the most.
- Write one rule for next week. Only one, so you can tell if it worked.
Monthly journal format
The monthly review steps back. It looks at costs and at drawdown (the drop from your highest running total to a later low). It also shows which setups and times of day work for you. For this example, treat the same 10 trades as one short month, and say the month's charges added up to ₹575 (a made-up figure).
| Monthly field | What it tells you | Example |
|---|---|---|
| Net P&L after charges | Your real result | ₹4,200 |
| Charges, and their share of gross P&L | How much costs take | ₹575 of ₹4,775 gross, about 12% |
| Maximum drawdown | The deepest fall from a peak in your running total | ₹1,600 |
| Trades by setup | Where your effort goes | 5 breakout, 5 pullback |
| Weakest time of day | When you trade badly | Most losses in the first hour |
| Mistakes ranked by count | Which mistake repeats | Moved stop, then early exit |
| One change for next month | A single, clear change | No pullback trades on expiry day |
How the drawdown was found: the running total after each trade was ₹1,800, ₹800, ₹3,000, ₹2,000, ₹1,400, ₹2,900, ₹1,900, ₹2,800, ₹1,800 and ₹4,200. The highest point before the worst fall was ₹3,000, and the low after it was ₹1,400. So the maximum drawdown was ₹1,600. A short drawdown definition is in our glossary.
For the formulas behind win rate, profit factor, drawdown and other numbers, see our guide to trading statistics.
Spreadsheet header row and formulas
To build this format in Excel or Google Sheets, put one header per column in the first row. Use these headers, from column A to column Y. A Date, B Entry time, C Exit time, D Instrument, E Segment, F Product, G Side, H Setup, I Reason, J Planned entry, K Stop, L Target, M Quantity, N Planned risk, O Actual entry, P Actual exit, Q Exit reason, R Gross P&L, S Charges, T Net P&L, U R multiple, V Followed plan, W Emotion, X Mistake, Y Lesson.
For F&O, add five more columns at the end, so the formulas below do not move. They are Z Underlying, AA Expiry, AB Strike, AC CE or PE and AD Lots.
- Planned risk (cell N2): =ABS(J2-K2)*M2
- Gross P&L (cell R2): =IF(G2="Buy",(P2-O2)*M2,(O2-P2)*M2)
- Net P&L (cell T2): =R2-S2
- R multiple (cell U2): =T2/N2
- Win rate: =COUNTIF(T2:T500,">0")/COUNT(T2:T500)
- Average win: =AVERAGEIF(T2:T500,">0")
- Average loss: =AVERAGEIF(T2:T500,"<0")
- Profit factor: =SUMIF(T2:T500,">0")/ABS(SUMIF(T2:T500,"<0"))
- Expectancy: =AVERAGE(T2:T500) in rupees, or =AVERAGE(U2:U500) in R
- Plan-break rate: =COUNTIF(V2:V500,"No")/COUNTA(V2:V500)
Copy the row formulas down the sheet. Type charges (column S) from your broker's contract note, or estimate them with the rates shown above. Add dropdown lists (Data validation in both Excel and Sheets) to columns H, V, W and X so tags stay clean. Enter the 10 example trades to test your sheet. The summary formulas should match the weekly list. You should see a 50% win rate, a ₹1,760 average win and a ₹920 average loss. Profit factor should be about 1.91 and expectancy ₹420.
Sheet, notebook or app: which format fits
| Format | Setup effort | Speed of entry | Review | Common problems |
|---|---|---|---|---|
| Notebook or printed PDF | None | Fast for notes, slow for numbers | Hard: you add up by hand | No totals, hard to search, easy to skip charges |
| Excel or Google Sheets | An hour or two to build | Medium | Good if the formulas are right | Broken formulas, missed rows, messy free-text tags |
| Journal app | Sign up and learn the form | Fast forms | Charts and totals are ready | You get the app's fields, so check what it records |
A sheet works well at the start. It begins to struggle when the rows grow and you want results by setup, by day and by time of day. A wrong formula or a pasted value can quietly change your totals. Our Excel vs app comparison covers this in more detail.
For help choosing between a sheet, a broker report and an app, see our guide to picking a trade tracker.
Tracking this format in OneTradeJournal
OneTradeJournal is a trading journal built for Indian F&O traders, and its trade form follows much of this format. You log each trade by hand, on purpose. There is no broker connection and no file import. Each trade can hold your strategy, stop, target, emotions, mistakes, plan deviation and notes.
For every trade it works out an estimate of brokerage and statutory charges, and shows P&L after them. Treat these as estimates; your broker's contract note is the final word. Its reports include a P&L calendar, equity curve, win rate, profit factor, drawdown, and results by strategy and time of day. That covers most of the weekly and monthly fields above. The free plan lets you log one trade per day per market and is free forever. The AI tools that answer questions about your logged trades come with the paid plan only. You can export your trades to CSV, JSON or TXT at any time.
Mistakes that break a journal format
- Too many columns. If filling a row feels like a chore, you will stop. Cut any field you never look at in a review.
- Free-text tags. Use fixed lists for setup, emotion and mistake, or your counts will split.
- Logging late. Memory changes after the result is known. Fill the plan before the order and the result the same day.
- Skipping trades. Logging only winners, or skipping "small" trades, hides the trades that teach the most.
- Gross P&L only. The scalp example above shows how much charges can take.
- Changing columns mid-month. Change the format at the start of a month so the numbers stay comparable.
- Copying quantity from a lot size table. Lot sizes change. Type the quantity you actually traded.
- No planned stop. Without it you cannot work out R or check your risk reward ratio.
Is your format working? A 10 question check
After a month of data, you should be able to answer each question below from your sheet or app in a few minutes. If you cannot, a field is missing or is not being filled. Then use the answers in a proper trade review.
- What was my net P&L after all charges?
- What share of my gross profit went to charges?
- Which setup made the most money after charges?
- Which setup lost money?
- How many trades broke my plan, and what did they cost?
- What are my average win and my average loss?
- What is my expectancy per trade in R?
- What was my largest drawdown?
- At what time of day do I trade worst?
- Which mistake did I repeat most often?
Trading journal format FAQ
Sources
- NSE circular NSE/FATAX/73524, Changes in rates of STT, 31 March 2026 (checked 10 Nov 2026)
- NSE circular NSE/FA/73061, Revision in Transaction Charges, 27 February 2026 (checked 10 Nov 2026)
- NSE circular NSE/FAOP/68747, Revision in Expiry Day of Index and Stock Derivatives Contracts, 25 June 2025 (checked 10 Nov 2026)
- NSE circular NSE/FAOP/73928, F&O Consolidated Circular, 28 April 2026 (checked 10 Nov 2026)
- Upstox brokerage charges page (checked 10 Nov 2026)
- Groww pricing page, used to cross-check stamp duty, exchange and SEBI fee rates (checked 10 Nov 2026)
- Zerodha Kite Connect documentation, order product types (checked 10 Nov 2026)
Related Topics
Related Articles
Trading Journal Template India: Excel and Sheets Build Guide
Free trading journal Excel for Indian equity and F&O: download the .xlsx with P&L, R-multiple and monthly summary formulas, or build your own in Sheets.
Paper Trading App in India: What Each App Offers and What SEBI Says
Paper trading apps in India compared from their own pages: cost, virtual money and price delay. Plus SEBI's 2024 advisory and how to judge your practice trades.
Share Market Kaise Sikhe: A Step by Step Plan for Beginners in India
Share market kaise sikhe: a 12-week beginner plan, free NISM and NSE resources, real costs of a first trade, SEBI loss data and a journal habit. No promises.
TradingView Paper Trading in India: Steps, Limits and Nifty Rules
TradingView paper trading is free, but its help page lists Indian exchange symbols as non-tradable. Setup steps, NSE data delay, limits and a journal method.
Zerodha Console P&L: How to Read Your Report and What It Misses
Read your Zerodha Console P&L step by step: realised and unrealised P&L, charges, heat map, Tax P&L, Verified P&L, why numbers differ and what it can't show.
TradeZella Price in India: Plans in Dollars and Rupees (2026)
TradeZella price: Essential $35, Pro $59, Ultra $99 a month or $315 to $891 a year. Rupee cost, the July 2026 rise, trial facts and checks for Indian traders.
The trading journal for Nifty, Bank Nifty and Indian F&O. Track your trades, spot patterns, build discipline.
- Log one trade a day by hand, on purpose
- AI mentor finds your repeat mistakes
- Behavioural analytics catch tilt early
- Trading calendar with P&L heatmap
- Pre-trade checklist flags risks
Yearly ₹3,999 · No broker credentials