Trading Journal Template for Indian Intraday Traders

A useful trading journal template should record more than your profit or loss. For Indian intraday traders, the essential fields include the date, instrument, entry and exit, quantity, setup, stop-loss, target, P&L, mistakes, discipline and lessons learned.

You can maintain these records in Excel, Google Sheets, a notebook, or a dedicated trading journal app. The important part is to record your trades consistently and review them regularly.

If you are new to trading journals, you can also read our guide on "why every intraday trader should maintain a trading journal" to understand why consistent journaling matters.

What Should a Trading Journal Include?

A simple trading journal does not need dozens of columns.

For most intraday traders, these are the essential fields:

Trade Details

Date
Instrument
Buy/Sell
Entry Price
Exit Price
Quantity or Lots
Profit or Loss

Trade Plan

Trading Setup
Reason for Entry
Stop-Loss
Target

Trade Review

Mistake
Emotion
Whether the trading plan was followed
Lesson learned

The exact fields can vary depending on your strategy, but the objective remains the same:

Record the trade and the decision behind it.

Simple Trading Journal Template

You can use the following structure in Excel, Google Sheets, a notebook, or a trading journal app.

Date:
When did you take the trade?

Instrument:
Which stock, index, or option did you trade?

Buy/Sell:
Was it a buy or sell trade?

Entry Price:
At what price did you actually enter?

Exit Price:
At what price did you actually exit?

Quantity/Lots:
How much did you trade?

Stop-Loss:
What was your planned stop-loss?

Target:
What was your planned target?

P&L:
What was the final profit or loss?

Setup:
What trading setup caused you to enter?

Entry Reason:
Why did you take the trade?

Mistake:
Did you make any trading or execution mistake?

Emotion:
Were you calm, impatient, fearful, overconfident, or experiencing FOMO?

Plan Followed:
Did you follow your trading rules?

Lesson:
What did you learn from this trade?

This simple format is enough to start building a useful trading journal.

1. Record the Date and Instrument

Start with the basic information about the trade.

For example:

Date: 2 October 2026
Instrument: NIFTY
Segment: Intraday
Direction: Buy

For options, you can additionally record the strike price and expiry.

Keeping this information consistent makes it easier to review your trades later.

2. Record Your Actual Entry and Exit

Record where you actually entered and exited the position.

Do not replace the actual execution price with the price you wanted to get.

For example:

Planned Entry: ₹100
Actual Entry: ₹103

This difference can become important when reviewing your execution.

3. Record Quantity or Lot Size

Your journal should also record your position size.

For equity trades, record the number of shares.

For derivatives, record the number of lots or relevant quantity.

This helps you understand whether changes in position size affected your results.

4. Record Your Stop-Loss and Target

If your strategy uses a stop-loss and target, record them as part of your original trade plan.

For example:

Entry: ₹250
Stop-Loss: ₹240
Target: ₹270

Later, compare the original plan with what actually happened.

This can help you identify behaviours such as:

Moving your stop-loss
Exiting too early
Entering without a defined risk level
Increasing risk after a losing trade

5. Record the Trading Setup

This is one of the most useful fields in a trading journal.

Instead of simply writing:

NIFTY — Profit ₹800

record the setup behind the trade.

For example:

Setup: Breakout above resistance with confirmation.

Other possible setup names could include:

Breakout
Pullback
Support/Resistance
Trend continuation
Reversal
VWAP setup
Opening range breakout

Use consistent names for your setups. This makes your journal easier to analyse later.

6. Record Why You Took the Trade

Your journal should answer one simple question:

Why did I enter this trade?

For example:

Price broke resistance and the setup was confirmed according to my trading plan.

This is different from simply recording the entry price.

A trading journal should capture the decision, not just the transaction.

7. Record Your Mistake

Not every losing trade is necessarily a mistake.

A valid setup can fail.

Therefore, separate the trade result from the trading mistake.

For example:

Result: Loss
Setup: Valid breakout
Mistake: None

Another trade might look like:

Result: Loss
Setup: No valid setup
Mistake: Entered because of FOMO

This distinction becomes useful during your trading review.

8. Track Whether You Followed Your Trading Plan

Add a simple field:

Plan Followed: Yes / No

You can also track specific rules:

Entry rule followed
Stop-loss followed
Position size followed
Exit rule followed
Daily loss limit followed

The purpose is to measure your actual execution against your own trading rules.

9. Track Your Trading Emotions

If emotions affect your decisions, add an emotion field to your journal.

For example:

Calm
Fear
FOMO
Revenge
Overconfidence
Impatience

You can then connect the emotion with the trading mistake.

For example:

Emotion: FOMO
Mistake: Entered before confirmation.

After recording enough trades, you may start noticing repeated behavioural patterns.

10. Write One Lesson After Every Trade

You do not need to write a long paragraph after every trade.

One clear sentence is enough.

For example:

Wait for confirmation instead of entering during the initial move.

Or:

The setup was valid, but I exited before the planned target.

The goal is to make your future review easier.

Should You Include Trading Charges?

If you want to understand your actual performance, distinguish between gross P&L and net P&L.

Trading costs in India can include brokerage and applicable statutory and exchange charges, depending on the broker and product.

For accurate calculations, use the charges shown in your broker's contract note rather than relying on a permanently fixed rate.

Excel or Google Sheets: Is It Enough?

For a small number of trades, Excel or Google Sheets can be a practical way to start.

You can create simple fields for:

Date
Instrument
Entry
Exit
Quantity
P&L
Setup
Mistake
Lesson

You can then calculate metrics such as:

Total P&L
Number of trades
Winning trades
Losing trades
Win rate
Average win
Average loss

The main challenge is not creating the spreadsheet.

It is maintaining it consistently.

As the number of trades grows, manually entering executions, maintaining formulas and reviewing large amounts of data can become time-consuming.

When Should You Review Your Trading Journal?

Recording trades is only the first step.

You also need to review them regularly.

Daily Review

At the end of the trading day, ask yourself:

1. Did I follow my trading plan?
2. Did I take any unnecessary trades?
3. Did I break any trading rules?
4. What was my biggest mistake today?
5. What is one thing I can improve tomorrow?

Weekly Review

At the end of the week, look for repeated patterns.

Ask:

Which setups did I trade?
Which mistakes appeared repeatedly?
Did I take trades outside my plan?
Did I overtrade after losses?
Did I follow my daily loss limit?
Which behaviour affected my execution?

The purpose of a weekly review is not simply to count profitable and losing trades.

It is to understand how you traded.

If you want a step-by-step guide to the overall journaling process, read "How to Maintain a Trading Journal for Intraday Trading"

Trading Journal vs Trade Log

A trade log mainly tells you:

What happened?

A trading journal tries to capture:

What happened → Why it happened → Whether the plan was followed → What can be learned

That additional context is what makes a journal useful for reviewing trading behaviour.

How to Start Your Trading Journal

You don't need to wait for the perfect template.

Start with these 10 fields:

1. Date
2. Instrument
3. Entry
4. Exit
5. Quantity
6. P&L
7. Setup
8. Mistake
9. Plan Followed?
10. Lesson

Record every trade consistently.

After several weeks, review the data and look for repeated patterns in your trading.

If maintaining a spreadsheet manually becomes difficult, a dedicated trading journal can reduce the amount of manual record-keeping by bringing trade records, performance data and review into one place.

You can learn more about the idea behind Save Your Trade in "Why Save Your Trade"

Final Takeaway

A trading journal is not simply a record of your profits and losses.

For an Indian intraday trader, a useful journal should connect:

The trade → The plan → The execution → The result → The lesson

Start simple.

Record every trade.

Review your mistakes regularly.

Look for repeated patterns in your trading behaviour.

The best trading journal template is ultimately the one you can maintain consistently and actually review.