Skip to content

    Trading journal guide for Indian traders

    Quick answer

    Learn how to keep a trading journal: why it helps, a starter template, daily to monthly reviews, notebook vs Excel vs app, and tax records for Indian traders.

    31 January 2026
    11 min read
    2,102 words

    A trading journal is a record of your trades, the decisions behind them and what you learned afterwards. Start by recording the instrument, direction (buy or sell), quantity, entry, exit, costs and reason for each trade. Then check the record against your broker documents before reviewing patterns. This guide shows how to keep planned risk separate from the actual result, including when you exit in parts.

    Start with a question your record can answer

    Choose a question about your own process: ‘Did I move my stop?’, ‘Did I enter before my setup was complete?’ or ‘Did charges consume the gross profit?’ These questions need different evidence. A result column alone cannot answer them.

    Write the entry reason before the outcome is known when possible. After the trade, add what happened without rewriting the original plan. If you fill a record later, label reconstructed details and leave anything you cannot recover as unknown.

    Why keep a trading journal

    Memory is kind to traders. You remember the clean entries and forget the late ones. A written record shows what you actually did, trade after trade, so you can see patterns that a single good or bad day hides.

    • Repeat mistakes become visible. If five of your last ten losses came after you moved a stop, the record shows it. A feeling does not.
    • You can check rule-following. A written plan beside the result lets you count how often you followed it.
    • Costs stop being a surprise. Recording estimated charges next to gross profit shows how much of a small win is left after costs.
    • Reviews get faster. With the same fields on every trade, a weekly review takes minutes instead of an evening.

    A journal does not predict anything and cannot make a method work. It only gives you honest data about your own behaviour.

    Separate the plan, execution and review

    Suggested journal structure. CME Group trade-log guidance and OneTradeJournal product information checked 15 October 2026; fields here are editorial suggestions.
    Part of the recordSuggested fieldsPurpose
    PlanSetup (reason for entry), intended entry, original stop, target, quantity and planned cash riskPreserve what you intended before the outcome.
    ExecutionContract identity, actual fills (prices and quantities traded), quantities, times, costs and exit reasonRebuild what happened in the account.
    ReviewPlan followed, deviation, emotion and next review questionExplain decisions without confusing them with the result.

    CME Group’s trade-log lesson suggests recording the reason for the trade, entry and exit points, targets and time. It also recommends writing daily conclusions. Treat this as educational guidance, not a legal requirement for your personal journal.

    For Indian options, identify the underlying, expiry, strike and call or put. Record the actual filled quantity as well as lots so an old contract assumption cannot silently change the arithmetic. Keep charges labelled as estimated until you can compare them with the broker document. The options journal guide covers those contract details.

    A starter template: the minimum fields

    If you are starting from zero, begin with ten columns. You can add more later, but a journal with too many fields usually gets abandoned within a month. The sample row below is an invented example, not a real trade.

    Illustrative starter row with made-up prices. Field list is an editorial suggestion.
    DateInstrumentDirectionQuantityEntryStopExitReason for entryFollowed plan?Note
    2026-10-12Sample Nifty call optionBuyAs traded (not lots)₹100₹80₹112Waited for my setup to completeYesExited early, nervous

    Write the instrument fully (underlying, expiry, strike, call or put) and the quantity you actually traded. Add charges once you can compare them with your broker's contract note. For a longer list of columns, see the trading journal template page.

    Worked entry: selling a position in parts

    This fictional cash-share trade is an arithmetic example, with made-up prices and charges. You buy 20 shares at ₹400 with an original stop at ₹395. You later sell 10 shares at ₹410 and the remaining 10 at ₹398. Assume ₹40 in total charges; this is not a quoted brokerage rate.

    • Planned price risk: (₹400 − ₹395) × 20 = ₹100, before costs and any difference between the stop price and the eventual fill.
    • First exit: (₹410 − ₹400) × 10 = ₹100 gross profit.
    • Second exit: (₹398 − ₹400) × 10 = −₹20 gross result.
    • Combined gross profit: ₹100 − ₹20 = ₹80.
    • Net result: ₹80 − ₹40 = ₹40.

    Keep both exit quantities and prices in the record. Writing only the first sale would leave the remaining shares unexplained. In a worksheet, give the linked fills a common trade label; if your chosen form cannot store the fills separately, preserve them in your notes and confirm its quantity and price conventions before using the totals.

    For this example, net result divided by original planned price risk is ₹40 ÷ ₹100 = 0.4R. Here R means the original cash amount at risk before costs. State that convention beside the figure: moving the stop later must not quietly rewrite the original denominator. A stop price does not establish a guaranteed exit price.

    Reconcile before interpreting a chart

    • Match the instrument and contract, not just a shortened symbol.
    • Check that total closing quantity matches the quantity you intended to close.
    • Look for omitted losses, duplicate entries and positions still open.
    • Separate actual costs from estimates and missing amounts.
    • Keep deposits and withdrawals separate from trade profit in any worksheet you build.

    Reconciliation means checking that two records agree. Use the broker record for execution details and your contemporaneous notes for the decision. If they disagree, resolve the difference or mark it visibly. A personal journal does not replace broker statements or establish tax compliance.

    Daily, weekly and monthly review routine

    Different intervals answer different questions. Keep each one short enough that you will really do it.

    Suggested routine. The time estimates are editorial suggestions, not a standard.
    IntervalWhat to checkTime to set aside
    DailyEvery trade has a reason, stop and exit written down. Mark anything you will have to reconstruct.5 to 10 minutes
    WeeklyCount trades where you broke your own plan. Read your notes on the biggest loss and the biggest win.20 to 30 minutes
    MonthlyCompare strategies and time of day. Check net result after costs. Choose one process rule to work on next month.45 to 60 minutes

    Review in a separate session from trading. The daily trading journal page covers the end-of-day habit in more detail.

    Review results without rewriting the story

    Begin with the complete set of closed trades for a chosen period. Separate strategies and markets before comparing them, and keep your definition of a trade consistent. Otherwise the same position can appear as a single decision in one view and several unrelated trades in another.

    Read results beside the notes. A loss with the plan followed raises a different question from a loss caused by an unplanned size increase. A profitable deviation also belongs in the review. Avoid treating a small group of wins as evidence that a change will keep working.

    Choose a specific process question for the next review, such as whether every entry has a written reason. Record the question before gathering the next set of trades. The guide to journal fields helps you remove columns that never answer a question.

    Psychology and emotion tracking

    Add one emotion word to each trade before you look at the profit or loss: calm, rushed, angry, bored, afraid to miss out. After a month, group your trades by that word. Many traders find the rushed or angry trades are the ones that break their own rules. Treat that as something to test in your own data, not as a rule that holds for everyone.

    Notebook, Excel or journaling app

    Editorial comparison, checked 28 Oct 2026.
    OptionEffortAnalysisTypical risk
    Paper notebookLow to start; slow to searchYou add up everything by handGaps and unreadable notes
    Excel or Google SheetsMedium; you build and maintain formulasAs good as your formulasBroken formulas and silent arithmetic errors
    Journaling appLow once set upReady-made reportsFields you cannot change, and the app can be wrong too

    All three work if you use them every day. See spreadsheet versus app for a longer comparison.

    Common journaling mistakes

    • Writing the reason after the result is known.
    • Recording only winners, or skipping days that felt bad.
    • Tracking too many fields and quitting.
    • Changing the original stop in the record after the trade.
    • Mixing deposits and withdrawals with trading profit.
    • Judging a method on a handful of trades.

    Where OneTradeJournal fits this workflow

    OneTradeJournal provides manual trade entry, emotion and mistake notes, estimated per-trade charges and reports including win rate, profit factor and drawdown. Trades are entered by hand; exports are available. The free allowance is one trade daily per market, free forever, as checked on 15 October 2026.

    Keep a complete record appropriate to your activity. A selected daily reflection is useful, but its totals describe only those selected entries. Paid AI can discuss your logged trades and can make mistakes. Its answer needs checking against the underlying entries. For format choices, see spreadsheet versus app or the printable journal approach.

    If you would rather not build this yourself, OneTradeJournal is a free trading journal app made for Indian F&O traders. It records the same details described on this page and works out your P&L in rupees.

    Using your journal records at tax time

    Income from futures and options is generally treated as business income in India and reported in the ITR-3 form, but check with a CA for your own case. For F&O, ICAI's guidance note on tax audit describes turnover as the total of the absolute (positive) profit or loss on each squared-off trade, plus rules for premium, so it is not the same as net profit. A day-by-day record of closed trades, quantities and costs gives you the numbers your chartered accountant (CA) will ask for.

    Your journal is a working record. The broker's tax profit-and-loss report, contract notes and bank statements are the documents to reconcile against. Rules and thresholds change, so confirm what applies to you with a CA. Read trading journal for tax and ITR and F&O turnover for more.

    Journal guides by market

    Sources

    Related Topics

    trading journal guidetrading journaltrading journal Indiahow to journal trades

    Related Articles