Free Trading Journal Template for Indian Traders

Columns to include

Keep one row per completed trade if your workflow is simple. For multi-leg options, use a trade ID so several legs can be reviewed together without pretending they were one fill.

Formulas that are mathematically sound

For a long position, gross P&L is (exit price − entry price) × quantity. For a short position, it is (entry price − exit price) × quantity. Net P&L is gross P&L − charges.

If planned risk is positive, realised R-multiple is net P&L ÷ planned risk. Enter the risk in rupees, not as a percentage, unless you first convert the percentage into a rupee amount. Do not hard-code brokerage, taxes or statutory rates: they vary by broker, product and regulation.

• Use data validation for direction and market.
• Store a date and time consistently, preferably in separate columns.
• Use a link to a screenshot rather than embedding large images in every row.
• Add a unique trade ID before importing or merging data.

A workable sheet layout

Create an Inputs sheet for trades, a Lists sheet for strategy and mistake tags, and a Review sheet for pivot tables or summaries. Protect formula columns so a hurried edit does not change historical results.

The free editable Excel template is linked below. Enter charges from the completed contract note instead of hard-coding a current fee schedule.

When a spreadsheet becomes difficult

Spreadsheets become fragile when you reconcile repeated fills, calculate costs, review multi-leg trades, keep screenshots, and maintain formulas across many months. They are still a sensible starting point: the warning sign is not the number of rows alone, but the amount of manual reconciliation and the number of places a value can disagree.

Build the workbook in layers

Start with a Trades sheet that stores one completed trade or one leg, depending on the structure you choose. Add a stable trade ID, leg ID and strategy tag before adding charts. A separate Lists sheet can hold allowed markets, strategies, mistake tags and emotional tags; data validation prevents spelling variations from splitting your reports.

Keep a Raw Import sheet if you paste broker data. Never overwrite it with cleaned values. Use a Clean Trades sheet for normalised fields, then a Review sheet for pivots and charts. This separation gives you an audit trail when a total changes and prevents a dashboard formula from silently changing the source record.

• Freeze the header row and filter by date.
• Use ISO-style dates or a single consistent date format.
• Record timestamps in IST when the source provides them.
• Keep charges as a separate input rather than hiding them in gross P&L.
• Back up the workbook before changing formulas.

Formula edge cases to handle

For a long trade, price P&L is (exit − entry) × quantity. For a short trade, it is (entry − exit) × quantity. If a position is scaled, calculate each leg first and then sum the legs. Do not multiply a premium difference by an assumed lot size when quantity already contains the traded units.

Realised R-multiple needs a positive planned-risk denominator. If the stop was not defined before entry, leave R blank rather than inventing a risk number after the result. If the position was adjusted, preserve both original planned risk and the adjustment note. For a multi-leg strategy, keep gross and net results at both leg and strategy level.

Avoid putting current brokerage, STT, GST, stamp duty or exchange rates directly into a template without a source and effective date. Charges vary by product, broker and regulation, so use the applicable contract note as the final record and check the broker's current official charges before estimating them.

Turn the sheet into a review routine

After each session, complete the execution fields while the sequence is fresh. At the end of the week, filter for missing screenshots, missing reasons and untagged mistakes before reading the P&L. Then compare strategy, time window, direction, holding time and average loss. Finish with one written change for the next week.

A template is successful when it is completed consistently, not when it contains the most columns. If copying and reconciling broker data takes longer than the review itself, that is the point at which an automated import workflow becomes worth evaluating.