Skip to content

    Trading Journal Format: Filled Examples and Daily to Monthly Layouts

    Quick answer

    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.

    10 November 2026
    21 min read
    4,039 words

    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.

    1. Trade details: when, what and how you traded.
    2. Plan: written before you place the order. Setup, reason, entry, stop, target and size.
    3. Result: written after you exit. Actual prices, exit reason, profit or loss.
    4. Charges: everything you paid, so you can see the net result.
    5. 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.

    Extra fields for an F&O trading journal format. Values are made up. Checked 10 Nov 2026.
    FieldWhat to writeExample
    UnderlyingThe index or stock the contract is onNIFTY
    Expiry dateThe contract's expiry dateNext Tuesday's weekly expiry
    StrikeThe strike price24,500 (example)
    CE or PECall (CE) or put (PE)CE
    Lots and quantityLots traded and total unitsOne lot, quantity typed in by you
    Premium in and outOption price per unit at entry and exit₹120 and ₹132
    Expiry tagExpiry day, day before expiry, or other dayExpiry day
    LegFor spreads, which leg this row isBull 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.

    Example trades, not real. Charges use Upstox's published rates and NSE circulars NSE/FATAX/73524 and NSE/FA/73061, checked 10 Nov 2026. Each total is rounded once, at the end, to the paisa.
    FieldRow 1: DeliveryRow 2: IntradayRow 3: Index option
    Segment and productCash, CNCCash, MISF&O, bought and sold same day
    SideBuyBuyBuy a call (CE)
    SetupPullbackBreakoutBreakout
    Planned entry, stop, target₹1,500, ₹1,440, ₹1,620₹800, ₹795, ₹812₹120, ₹105, ₹145
    Quantity20 shares100 shares100 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.88R1.05R0.75R
    Followed planYesNo (exited early)No (exited early)
    EmotionCalmNervousRushed
    LessonHolding to the target paid offLet trades reach target or stopDo 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 journal format. Example values are made up. Checked 10 Nov 2026.
    Daily fieldWhat to writeExample
    Trades takenCount for the day2
    Plan followedTrades that followed the plan1 of 2
    Net P&LSum of the day's net P&LLoss of ₹380
    Daily loss limitDid you stop at your limit?Yes
    Biggest mistakeOne tagMoved stop
    One thing done wellOne lineSkipped a trade outside my setups
    Mood at closeOne wordFrustrated
    TomorrowOne thing to do or avoidNo 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.

    Example week of trades, made up for this guide. Planned risk ₹1,000 per trade. Checked 10 Nov 2026.
    TradeSetupNet P&LR multipleFollowed plan
    1Breakout+₹1,8001.8RYes
    2Breakout-₹1,000-1RYes
    3Breakout+₹2,2002.2RYes
    4Pullback-₹1,000-1RNo
    5Pullback-₹600-0.6RNo
    6Pullback+₹1,5001.5RYes
    7Breakout-₹1,000-1RYes
    8Pullback+₹9000.9RYes
    9Pullback-₹1,000-1RNo
    10Breakout+₹2,4002.4RYes

    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.

    1. Check that every trade of the week is logged, with charges.
    2. Fill in the summary fields above.
    3. Sort the rows by setup, then by "Followed plan".
    4. Read the lesson column and pick the mistake that cost the most.
    5. 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 journal format. Example values are made up and use the example week above. Checked 10 Nov 2026.
    Monthly fieldWhat it tells youExample
    Net P&L after chargesYour real result₹4,200
    Charges, and their share of gross P&LHow much costs take₹575 of ₹4,775 gross, about 12%
    Maximum drawdownThe deepest fall from a peak in your running total₹1,600
    Trades by setupWhere your effort goes5 breakout, 5 pullback
    Weakest time of dayWhen you trade badlyMost losses in the first hour
    Mistakes ranked by countWhich mistake repeatsMoved stop, then early exit
    One change for next monthA single, clear changeNo 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

    General comparison of journal formats. Not a ranking of any product. Checked 10 Nov 2026.
    FormatSetup effortSpeed of entryReviewCommon problems
    Notebook or printed PDFNoneFast for notes, slow for numbersHard: you add up by handNo totals, hard to search, easy to skip charges
    Excel or Google SheetsAn hour or two to buildMediumGood if the formulas are rightBroken formulas, missed rows, messy free-text tags
    Journal appSign up and learn the formFast formsCharts and totals are readyYou 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.

    1. What was my net P&L after all charges?
    2. What share of my gross profit went to charges?
    3. Which setup made the most money after charges?
    4. Which setup lost money?
    5. How many trades broke my plan, and what did they cost?
    6. What are my average win and my average loss?
    7. What is my expectancy per trade in R?
    8. What was my largest drawdown?
    9. At what time of day do I trade worst?
    10. Which mistake did I repeat most often?

    Trading journal format FAQ

    Sources

    Related Topics

    trading journal formattrading journal examplestrading journal exampletrading journal samplef&o trading journal formatintraday trading journal formatdaily trading journal formatweekly trading review formatmonthly trading journal format

    Related Articles