Trade Log: What It Is and How to Keep One in Indian Markets
A trade log is one row per trade with entry, exit, stop, charges and net P&L. See the minimum fields, Indian sample logs and how to turn them into stats.
A trade log is a simple list of your trades, with one row for each trade. Each row holds the facts of that trade. These are the date, what you traded, buy or sell, quantity, entry and exit price, stop-loss, charges and net profit or loss. You fill it in after the trade, from your own records.
About ten fields are enough to start. With them you can work out your win rate, your average win and loss, and whether your trading makes money after charges. Without them, you are guessing.
This page shows the minimum fields and three filled sample logs for Indian markets, with real charge rates. It explains how a log differs from a journal, a tradebook and a contract note. Then it shows how to turn your rows into numbers you can act on.
Key Takeaways
- 1.A trade log is one row per closed trade, written from facts, not feelings.
- 2.The minimum fields are date, instrument, side, quantity, entry, exit, stop-loss, charges, net P&L and a setup tag.
- 3.Always log net P&L (after charges). On small option trades, charges can turn a small gross win into a net loss.
- 4.From the log you can work out win rate, average win, average loss, expectancy, profit factor and maximum drawdown.
- 5.Your broker's tradebook and contract note show what happened. Only your own log shows why, and whether you followed your plan.
- 6.Update the log the same day, review it every week and do a bigger review every month.
What is a trade log?
A trade log is your own record of every trade you closed. Think of it as a register. Each line is one trade. The columns are the same every time, so you can add them up, sort them and compare them.
The key word is facts. Prices, quantity, the stop you set and the money you made or lost. Notes about your mood belong in a trading journal. You can keep both in one place, but the log part must stay clean and complete, including the losing trades.
The words "trade log" are also used for other things. In the US, TradeLog is the name of a tax reporting tool for traders. Interactive Brokers also has a "Trade Log" screen in its Trader Workstation software. Its guide says the screen shows reports of the day's executed orders. This page is about the record you keep yourself.
Trade log, trading journal, tradebook and contract note
Indian traders see four kinds of trade records. They overlap, but each one answers a different question. The table shows what each one holds and what it misses.
| Record | Who makes it | What it holds | What it misses |
|---|---|---|---|
| Your trade log | You | One row per trade: instrument, side, quantity, entry, exit, stop, charges, net P&L, setup tag | Feelings and detailed lessons, unless you add them |
| Trading journal | You | The log plus reasons, emotions, mistakes, screenshots and lessons | Nothing, if kept well. It takes more time to fill in |
| Broker tradebook or trade history | Your broker | Every executed order with time, quantity and price | Your stop-loss, your plan, your reason, and which orders belong to one trade |
| Contract note | Your broker | A confirmation of the day's trades with the charges and taxes on them | Your plan, your stop, and a trade-by-trade P&L |
Upstox's help page describes a contract note as "a confirmation of all your trades done on a particular day". It says the note is sent to your registered email within 24 hours. It has user details, trade details and charges. For a plain guide to each line on it, see our contract note glossary entry.
The broker records tell you what happened. They cannot tell you where your stop was, why you entered, or whether you broke a rule. That is the gap a trade log fills.
To read your broker's record row by row and see how it differs from the order book, see our guide on trade book meaning.
Trade log format: the minimum fields
Start small. A log with ten honest fields that you fill every day is worth more than a sheet with forty columns that you give up on. These are the fields that decide your numbers:
- Date. The day you closed the trade. For a trade held overnight, note the entry date too.
- Instrument. The full name. For options, write the index or stock, the expiry date, the strike and CE (call) or PE (put), the way your broker shows the contract. "Nifty call" alone is too vague to be useful later.
- Side. Buy first (long) or sell first (short).
- Quantity. The number of shares or option units you actually traded. Type it yourself from your order. Lot sizes change, so never fill it from memory.
- Entry price. Your average buy or sell price. Use the exact price from your order history, not a rounded one.
- Exit price. Your average closing price.
- Stop-loss. The price where you planned to get out if you were wrong. It is an easy field to skip, but it is the one that shows your planned risk.
- Charges. Brokerage, STT (securities transaction tax), exchange charges, SEBI fee, stamp duty and GST for that trade.
- Net P&L. Profit or loss after charges. This is the number that reaches your bank account.
- Setup tag. A short name for why you took the trade, such as "opening range breakout" or "pullback to VWAP". (VWAP is the day's average price, weighted by volume.) Tags let you see which setups pay you.
StockBrokers.com, a US site that shares a free journal sheet, makes a similar point. It says the biggest benefits are found in three columns: the profit or loss on each trade, why you did it, and what you learned. Our list adds the Indian details that US templates leave out: option expiry and strike, taxes and exchange charges, and net P&L.
Fields to add once the habit sticks
After a few weeks of steady logging, add one or two of these. Each one answers a question your basic log cannot.
- Entry and exit time. Shows if your results change by time of day.
- Target. The price where you planned to take profit. Compare it with where you actually got out.
- Plan followed: yes or no. The fastest way to separate bad luck from bad discipline.
- Mistake tag. One word for the main error, such as "moved stop" or "late entry".
- Market mood. Trending, range-bound or volatile day.
- Emotion before the trade. Calm, fearful, greedy or bored. Useful for spotting revenge trades.
If you want the full journal layout with every optional column, our guide to keeping a trading journal covers it. This page stays with the log itself.
For filled sample rows and daily, weekly and monthly layouts, see our guide to trading journal format.
Sample trade logs for Indian markets
The three trades below are made-up examples. The prices, quantities and the broker's fee are invented to show the method. The charge rates for taxes and exchange fees are real, taken from NSE circulars and broker pricing pages checked on 10 Nov 2026. We use an example brokerage of ₹20 per executed order, which is the flat F&O rate shown on the Upstox and Dhan pricing pages. For intraday equity some brokers charge less on small orders. Dhan, for example, lists ₹20 or 0.03% of the trade value per executed order, whichever is lower. Your own broker may charge less or more, so use your own contract note for real trades.
Sample 1: an intraday equity trade
Example: you buy 100 shares of a made-up stock at ₹500 and sell the same day at ₹506. Your stop-loss was ₹497. The buy value is ₹50,000 and the sell value is ₹50,600. Gross profit is ₹600. Your planned risk was ₹300, so this trade made 2 times the risk you planned (often written as 2R).
| Charge (intraday equity, NSE) | Rate | Worked on | Amount |
|---|---|---|---|
| Brokerage (example) | ₹20 per order | 2 orders | ₹40.00 |
| STT | 0.025% on the sell side | ₹50,600 | ₹12.65 |
| NSE transaction charge | 0.00307% each side | ₹1,00,600 | ₹3.09 |
| SEBI turnover fee | 0.0001% each side | ₹1,00,600 | ₹0.10 |
| Stamp duty | 0.003% on the buy side | ₹50,000 | ₹1.50 |
| GST | 18% on brokerage, exchange charge and SEBI fee | ₹43.19 | ₹7.77 |
| Total charges | ₹65.11 |
Net P&L for this example is ₹600 minus ₹65.11, which is ₹534.89. That is the number that goes in the log.
Sample 2: a Nifty option buy, one lot
NSE's lot size file lists the Nifty 50 lot as 65 for the November 2026 series and the series after it (checked 10 Nov 2026). Lot sizes change, so check the file before you trade, and always type the quantity you really traded.
Example: you buy one lot (65 units) of a Nifty call at ₹120 and sell it at ₹132. Your stop-loss was ₹100. You pay ₹7,800 of premium and receive ₹8,580. Gross profit is ₹780. Your planned risk was ₹1,300, so the result was 0.6R. A win, but smaller than the risk you took on.
| Charge (NSE index option) | Rate | Worked on | Amount |
|---|---|---|---|
| Brokerage (example) | ₹20 per order | 2 orders | ₹40.00 |
| STT | 0.15% of premium, sell side | ₹8,580 | ₹12.87 |
| NSE transaction charge | 0.03553% of premium, each side | ₹16,380 | ₹5.82 |
| SEBI turnover fee | ₹10 per crore (0.0001%) | ₹16,380 | ₹0.02 |
| Stamp duty | 0.003% on the buy side | ₹7,800 | ₹0.23 |
| GST | 18% on brokerage, exchange charge and SEBI fee | ₹45.84 | ₹8.25 |
| Total charges | ₹67.19 |
Net P&L is ₹780 minus ₹67.19, which is ₹712.81. Notice that the flat brokerage of ₹40 is the biggest line. On small option trades, the fixed per-order fee matters more than the percentage charges.
Sample 3: a losing trade, logged honestly
Example: you buy one Nifty put lot (65 units) at ₹110. It falls and you exit at your stop of ₹95. You paid ₹7,150 and received ₹6,175. Gross loss is ₹975. The same charge rates add ₹62.28, so the net loss is ₹1,037.28. This is a 1R loss: you lost what you planned to risk, plus charges. That is a well-managed loss, and it still goes in the log.
Here are the three examples as rows in one trade log. This is what a simple log looks like after three days.
| Instrument | Side | Qty | Entry | Exit | Stop | Gross P&L | Charges | Net P&L | Setup |
|---|---|---|---|---|---|---|---|---|---|
| Example stock (intraday) | Buy | 100 | ₹500 | ₹506 | ₹497 | ₹600.00 | ₹65.11 | ₹534.89 | Breakout |
| NIFTY call (example strike) | Buy | 65 | ₹120 | ₹132 | ₹100 | ₹780.00 | ₹67.19 | ₹712.81 | Pullback |
| NIFTY put (example strike) | Buy | 65 | ₹110 | ₹95 | ₹95 | −₹975.00 | ₹62.28 | −₹1,037.28 | Breakdown |
Add up the net column: ₹534.89 plus ₹712.81 minus ₹1,037.28 gives ₹210.42 for the three trades. Two wins out of three looks good, but one normal loss took most of it back. A log makes this visible in seconds.
Gross P&L and net P&L: why charges belong in the log
Gross P&L is the price difference times quantity. Net P&L is what is left after every charge. If you log only the gross figure, your bank balance will end up lower than your log says.
Example: you buy one Nifty option lot (65 units) at ₹100 and sell at ₹100.50. Gross profit is ₹32.50. Charges at the same rates come to ₹62.67. Your net result is a loss of ₹30.17. In a gross-only log, this shows as a win. In a net log, it shows as a loss. If you take many quick trades like this, a gross-only log can show a profit while your account shrinks.
SEBI, the market regulator, saw the same pattern across all individual F&O traders in FY26: 82.1% made losses before transaction costs and 87.7% after them. Our page on why traders lose money in India covers the full study.
Where to get the charges for each trade:
- Exact figures: your contract note for that day. If you took several trades that day, split the charges by trade.
- Quick estimate: a calculator such as our F&O trading cost calculator, then check against the contract note at the end of the week.
- Background: our guide to brokerage and charges explains what each line on the contract note means.
Keep charges separate from income tax in your log. Charges are paid on each trade. Income tax is worked out on your yearly income and depends on how your trading income is treated.
How to turn your trade log into statistics
This is where a log pays you back. Below is a made-up log of ten closed trades, showing only net P&L and the running total. Every figure is an example.
| Trade | Net P&L | Running total | Setup |
|---|---|---|---|
| 1 | ₹1,800 | ₹1,800 | Breakout |
| 2 | −₹600 | ₹1,200 | Breakout |
| 3 | −₹450 | ₹750 | Pullback |
| 4 | ₹1,200 | ₹1,950 | Breakout |
| 5 | −₹700 | ₹1,250 | Breakout |
| 6 | −₹500 | ₹750 | Pullback |
| 7 | ₹900 | ₹1,650 | Pullback |
| 8 | −₹650 | ₹1,000 | Pullback |
| 9 | ₹1,500 | ₹2,500 | Breakout |
| 10 | −₹400 | ₹2,100 | Pullback |
From these ten rows you get these numbers. Each line shows the simple maths, so you can copy it into your own sheet.
- Win rate (share of trades that made money): 4 wins out of 10 trades is 40%. The loss rate is 60%.
- Gross profit (all winning trades added): ₹1,800 + ₹1,200 + ₹900 + ₹1,500 = ₹5,400.
- Gross loss (all losing trades added): ₹600 + ₹450 + ₹700 + ₹500 + ₹650 + ₹400 = ₹3,300.
- Average win: ₹5,400 ÷ 4 = ₹1,350.
- Average loss: ₹3,300 ÷ 6 = ₹550.
- Reward to risk (average win divided by average loss): ₹1,350 ÷ ₹550 = 2.45.
- Expectancy (what an average trade made): 40% × ₹1,350 minus 60% × ₹550 = ₹210 per trade. Check: total net ₹2,100 ÷ 10 trades = ₹210.
- Profit factor (gross profit divided by gross loss): ₹5,400 ÷ ₹3,300 = 1.64. Above 1 means the log made money overall.
- Maximum drawdown (the biggest drop from a high point in your running total): ₹1,200. The total peaked at ₹1,950 after trade 4 and fell to ₹750 after trade 6.
Look at what the numbers say together. This example wins only 4 times in 10, yet it makes money. The reason is that the average win is about two and a half times the average loss. With wins and losses of these sizes, the break-even win rate is ₹550 ÷ (₹1,350 + ₹550), about 28.9%. A win rate alone tells you very little. You need it next to the average win and average loss. To try your own numbers, use our break-even win rate calculator.
You can check these numbers with our profit factor calculator and maximum drawdown calculator. For the theory behind expectancy, read how to calculate trading expectancy.
Split your numbers by setup
Totals hide a lot. Sort the same ten example trades by the setup tag and the picture changes.
| Setup | Trades | Wins | Win rate | Net P&L |
|---|---|---|---|---|
| Breakout | 5 | 3 | 60% | ₹3,200 |
| Pullback | 5 | 1 | 20% | −₹1,100 |
| All trades | 10 | 4 | 40% | ₹2,100 |
Breakout trades made ₹1,800 − ₹600 + ₹1,200 − ₹700 + ₹1,500 = ₹3,200. Pullback trades made −₹450 − ₹500 + ₹900 − ₹650 − ₹400, a loss of ₹1,100. In this example, all the profit came from one setup, and the other setup gave some of it back. That is the kind of finding a setup tag gives you. It is also why the tag is one of the ten minimum fields.
What ten trades can and cannot tell you
Ten trades are a start, not proof. In the example, one more losing trade would drop the win rate from 40% to 36.4% (4 wins out of 11). Small logs swing a lot. StockBrokers.com says its metrics "won't even begin to be meaningful" until you have made a few dozen trades. We found no sourced magic number, so treat early stats as a draft and keep logging.
What a small log can show early is behaviour. If three of your first ten trades have no stop-loss written down, you have found a problem, whatever the P&L says.
How often should you update your trade log?
Update it the same day, after the market closes. Prices, your stop and your reason are fresh, and you are not distracted by live prices. StockBrokers.com's advice is the same idea: every trade gets an entry "as quickly as possible after each trade", so a backlog does not build up.
Here is a simple routine. The times are only suggestions.
- Every trading day, after the close: about 2 minutes per trade. Fill every field, including charges and the setup tag.
- Every week: about 10 minutes. Add up net P&L, count wins and losses, and read your mistake tags. Pick one thing to fix next week.
- Every month: about 30 minutes. Work out win rate, average win, average loss, expectancy and drawdown. Compare setups. Check your log total against your broker's P&L report.
For a fuller weekly review method, see how to review your trades.
Mistakes that make a trade log useless
- Logging only the good trades. A log without losses gives you a false win rate. Every closed trade goes in.
- Leaving out charges. Your stats then show a better trader than you are, as Sample 1 to Sample 3 show.
- Editing old rows. If you change a past exit price to make it look better, the log stops being a record. Fix typing errors only, and note the fix.
- Rounding prices. Writing ₹132 when you sold at a slightly different price adds small errors that grow over many trades. Copy prices from your order history.
- No stop-loss field. Without it, you cannot tell if a loss was planned or a disaster.
- Vague instrument names. "Nifty CE" is not enough. Write the expiry and strike.
- Never reviewing it. A log you never read is just typing practice.
- Too many fields. If the log takes so long that you skip days, cut it back to the minimum fields.
The last point catches experienced traders too. Barry Taylor of Emini-Watch, a full-time futures trader, writes that his detailed trade notes became a burden. In his words: "Frankly, this became too onerous and I hardly ever reviewed it." He went back to a simple daily log with a list of his repeated mistakes. Short and complete beats long and abandoned.
Check your log against your broker's records
Your broker already stores your orders. Use those records to check your own log, not to replace it. On Zerodha, for example, the Console reports section on Zerodha Support groups reports under Contract note, Profit and Loss (P&L), Tax and Others. The Others group includes an article on where to see the trades taken in a chosen period. Other brokers have similar reports under their own names.
- Once a week, open your broker's trade history for the week.
- Match each order to a row in your log. Check quantity and price.
- Check that the charges in your log are close to the contract notes for those days.
- Once a month, compare your log's net total with your broker's P&L report for the same dates. If they differ, find the row that is wrong.
- Keep one note of any gap you could not explain, such as charges for a day you did not trade.
Some charges never appear on the contract note. Upstox's help page gives examples: demat maintenance charges, auto square-off charges and net banking fund transfer charges. It says to check the ledger for them. Keep those apart from trade charges, or your per-trade numbers will drift.
Your log and your broker's report answer different questions. To understand each number on the broker side before you compare, read our guide to the P&L report.
Paper trades, real trades and more than one market
Keep paper trades (practice trades with no real money) in a separate log or mark them clearly. Paper trades have no real fills and often no real fear, so mixing them with real trades makes your stats look better than they are.
If you trade equity intraday, index options and commodities, add a market column and look at each market's numbers on its own. A good options month can hide a weak equity month. Different markets also have different charges, so their net results are not alike even when the gross numbers are.
Do you need a trade log for income tax?
We did not find any official Income Tax Department page that tells individual traders to keep a personal trade log in a set format. What records you must keep, and whether you need an audit, depends on how your trading income is treated and on your turnover. These are questions for a chartered accountant (CA).
A clean log still helps at tax time. It lets you match your broker's tax P&L report, explain big losses and spot missing trades before you file. Brokers publish help on this too. On the Zerodha Support page above, the Tax group has an article on how turnover is calculated in its tax P&L. Another explains how to download the tax P&L or capital gains statement. Our page on using your journal for ITR filing goes further. Treat it as background and confirm with a CA.
Spreadsheet formulas that turn your log into stats
If you keep your log in Excel or Google Sheets, you build these formulas once and they update as you add rows. If you want a ready file with the columns already set up, see our trading journal template for India.
If you build your own sheet, put net P&L in one column, say column J from row 2 down. Then use formulas like these in Google Sheets or Excel:
- Win rate: =COUNTIF(J2:J500,">0")/COUNT(J2:J500)
- Average win: =AVERAGEIF(J2:J500,">0")
- Average loss: =AVERAGEIF(J2:J500,"<0")
- Profit factor: =SUMIF(J2:J500,">0")/ABS(SUMIF(J2:J500,"<0"))
- Running total: in K2 write =J2, and in K3 write =K2+J3, then copy it down.
- Drawdown: in L2 write =MAX(0,MAX($K$2:K2))-K2 and copy it down. The 0 stands for your starting point, so a losing first trade is counted too. The largest value in column L is your maximum drawdown.
Where OneTradeJournal fits. OneTradeJournal is a trading journal built for Indian F&O traders. You type each trade by hand, on purpose, because writing it down makes you look at it. It does not pull trades from any broker. For every row you log, it works out an estimate of brokerage, taxes and exchange charges and shows your P&L after them. Treat those as estimates and match them with your contract note. From what you log, it shows win rate, profit factor, drawdown, a P&L calendar and an equity curve. You do not have to maintain the formulas above. You can also note your stop, target, strategy, mistakes and emotions on each trade.
The free plan lets you log one trade per day per market and is free forever, not a trial. AI features such as Ask Your Journal and AI analysis are part of the paid plan. The AI can be wrong, and it only knows what you logged. You can export your trades to CSV or JSON, or download a summary report as a TXT file, at any time.
If you are still choosing where to keep your log, our trade tracker guide compares a spreadsheet, a broker report and a journal app.
Log every trade for five trading days with the ten minimum fields, including charges. At the end of the week, work out your win rate, average win and average loss. Even one week gives you real numbers to look at.
Sources
- NSE, F&O market lot file (fo_mktlots.csv), Nifty 50 lot for the November 2026 series, checked 10 Nov 2026
- NSE circular NSE/FATAX/73524, Changes in rates of STT, 31 Mar 2026, checked 10 Nov 2026
- NSE circular NSE/FA/73061, Revision in Transaction Charges, 27 Feb 2026, checked 10 Nov 2026
- Upstox, brokerage charges page, checked 10 Nov 2026
- Upstox help centre, What is a contract note?, checked 10 Nov 2026
- Groww, pricing page, checked 10 Nov 2026
- Dhan, pricing page, checked 10 Nov 2026
- Zerodha Support, Console reports, checked 10 Nov 2026
- StockBrokers.com, My Free Trading Journal Spreadsheet, 17 Sep 2026, checked 10 Nov 2026
- Emini-Watch, Trading Log, 17 Jul 2026, checked 10 Nov 2026
- TradeLog Software, home page, US trader tax reporting tool, checked 10 Nov 2026
- Interactive Brokers, Trader Workstation guide, Trade Log, checked 10 Nov 2026
- SEBI, Study: Profitability of Individual Traders in the Equity Derivatives Segment (FY25-FY26), Aug 2026, FY26 loss-maker share before and after costs, checked 10 Nov 2026
Related Topics
Related Articles
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.
Trade Book Meaning: What Your Tradebook Shows and How to Use It
A trade book lists only your filled trades. See how it differs from the order book and where Zerodha, Groww, Angel One, Dhan and Upstox keep it.
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