Skip to content

    Trading Analytics: The Numbers That Show Where Your Money Goes

    Quick answer

    Trading analytics for Indian traders: P&L after charges, win rate, profit factor, drawdown and setup breakdowns, with a worked example and sheet formulas.

    10 November 2026
    23 min read
    4,592 words

    Trading analytics means turning the trades you have already taken into numbers that tell you what works and what costs you money. The key numbers are your P&L (profit and loss) after charges, win rate, average win and average loss, profit factor, expectancy and drawdown. You then split them by setup, time of day and habit.

    A trading dashboard is one screen that shows those numbers together. This guide explains each number in plain words. It works through ten example trades in rupees and gives spreadsheet formulas you can copy. It also shows what to look for in a journal app.

    One note before you start. Some people search this phrase for data on goods that India buys from and sells to other countries, which government portals publish. That is a different subject. This page is about your own trades in shares, futures and options.

    Key Takeaways

    • 1.Trading analytics is the study of your own trade results. Market analytics (charts, option chain, screeners) is a separate thing.
    • 2.Always measure P&L after charges. In the worked example below, charges take 75% of the gross profit.
    • 3.Win rate alone can fool you. Read it with average win, average loss, profit factor and expectancy.
    • 4.Drawdown (the fall from your highest balance) tells you how much pain your method brings, even when it ends in profit.
    • 5.Splitting results by setup, time of day and rule-following shows where the money really comes from and goes.
    • 6.A small number of trades can mislead. In the example, removing one winning trade turns a small profit into a loss.

    What trading analytics means for a trader

    Two meanings: your own results and market data

    The phrase is used in two ways. Market analytics looks outward. It covers price charts, indicators, the option chain, screeners and news calendars. Your broker and the exchanges give you most of this. Performance analytics looks inward. It takes your own logged trades and asks simple questions. Do I make money after costs? Which setup pays? At what time of day do I lose? Do I lose more after a loss? Banks and software firms also use the phrase for their own systems, such as tools that estimate the cost of a large order. That use is about running a trading firm. This page is about your own trades.

    Most of this page is about the second meaning: reading your own results. A short section on market analytics comes later, so both meanings are covered.

    Why your own numbers matter more than another chart

    Studies of real traders in several countries point the same way. Most active traders lose money, many keep trading after losing, and costs eat a large share of their results. In India, SEBI's study of August 2026 found that 87.7% of individual F&O (futures and options) traders made a net loss in FY26 (April 2025 to March 2026). Our page on why most traders lose money in India covers that study in full. The table below adds studies from other countries whose original papers or releases we opened on the check date. Read them only as warning signs, since they are not Indian figures.

    Studies of trader results outside India, checked 10 Nov 2026. Sources: RePEc (FEA-USP working paper 2019_47), Terrance Odean's paper pages at UC Berkeley Haas, and ESMA. Each row covers only the market and period shown.
    StudyMarket and periodWhat it found
    Chague, De-Losso and Giovannetti, "Day trading for a living?" (working paper, 2019)Brazil equity futures. People who started day trading between 2013 and 2015 and kept going for at least 300 days97% lost money. Only 0.4% earned more than a bank teller (US$54 a day). The authors found no evidence of learning by day trading.
    Barber, Lee, Liu, Odean and Zhang, "Do Day Traders Rationally Learn About Their Ability?" (working paper, October 2017)Taiwan stock market, 1992 to 2006, all day tradersFrom 1995 to 2006, profitable day traders (10 or more days of day trading and a lifetime profit) were consistently about 5% of day traders. Unprofitable traders made 72% of day trading volume. Losing traders with 50 or more days of experience had a 95.3% chance of day trading again in the next 12 months. For profitable ones it was 96.4%, almost the same.
    Barber and Odean, "Trading Is Hazardous to Your Wealth" (Journal of Finance, April 2000)US, 66,465 households at a discount broker, 1991 to 1996Households that traded most earned 11.4% a year, while the market returned 17.9%. Before costs, frequent and rare traders did about the same. After costs, frequent traders earned 11.4% and rare traders 18.5%.
    ESMA press release on CFDs (27 March 2018)European Union, contracts for difference (CFDs), national regulators' data74% to 89% of retail accounts typically lost money, with average losses per client from €1,600 to €29,000.

    Two lessons stand out for analytics. First, the Taiwan study shows that losing traders kept trading at almost the same rate as winning ones. Losses alone did not make them stop or change. Second, the US study found that the gap between frequent and rare traders came from costs. Their gross results were close, and the net gap was 7.1 percentage points a year. Both lessons are about seeing your real numbers, after costs, and acting on them.

    The numbers every trading dashboard should show

    A dashboard is only as honest as the P&L it starts from. Indian F&O trades carry brokerage, STT (securities transaction tax), exchange transaction charges, the SEBI turnover fee, stamp duty and GST. Rates change from time to time, so take them from a dated source such as our log of Indian trading charge changes. Build every tile on net P&L (profit or loss after all charges). On gross P&L, a setup that only covers its costs looks like a winner.

    To see where gross and net figures appear in your broker's own report, read our guide to the P&L report.

    The table below is a quick map of the core numbers: what each one tells you and where it sits on the screen. It keeps the meanings short. The linked pages explain each number in depth.

    Core dashboard numbers, written 10 Nov 2026. Meanings kept short; the linked pages give full definitions and formulas.
    NumberWhat it tells youWhere it sits on the dashboardRead more
    Net P&L after chargesWhether you made money once every cost is paidTop row, first tileCharge rates log, linked above
    Win rateThe share of trades that ended in profit. It means little on its ownTop rowWin rate and breakeven calculator
    Average win, average loss and payoff ratioHow big a typical win is next to a typical lossTop row, beside win rateSame calculator
    Profit factorWinning trades in total against losing trades in total. Above one means a profit for the periodTop rowProfit factor calculator
    ExpectancyWhat you made or lost on an average tradeTop rowHow to calculate trading expectancy
    Equity curve and maximum drawdownThe path of your balance, and the deepest fall from a high point to a later lowMiddle row, as a line chartMaximum drawdown calculator
    Trade count and charges as a share of gross P&LEarly signs of overtrading (taking trades outside your plan)Side noteThe behaviour section below

    For the full formula behind each of these numbers, with a worked example, see our guide to trading statistics.

    Worked example: ten made-up trades, every number computed

    Here is a made-up month of ten option trades. The starting balance is an example of ₹1,00,000. The charges are an example flat amount of ₹60 per trade to keep the arithmetic simple. Your real charges will differ by broker, instrument, premium and number of orders. Setup names and entry times are also part of the example.

    Example only: ten made-up trades, example starting balance of ₹1,00,000 and example charges of ₹60 per trade. Built for this page on 10 Nov 2026. Not real results.
    TradeSetupEntry timeGross P&L (₹)Charges (₹)Net P&L (₹)Balance (₹)Followed rules?
    1BreakoutFirst hour+2,40060+2,3401,02,340Yes
    2BreakoutMidday-1,20060-1,2601,01,080Yes
    3ReversalFirst hour-1,10060-1,16099,920No
    4BreakoutMidday+3,00060+2,9401,02,860Yes
    5ReversalFirst hour-1,30060-1,3601,01,500Yes
    6ReversalMidday-90060-9601,00,540No
    7ReversalLast part+1,80060+1,7401,02,280Yes
    8BreakoutLast part-1,50060-1,5601,00,720Yes
    9ReversalFirst hour-2,60060-2,66098,060No
    10BreakoutMidday+2,20060+2,1401,00,200Yes

    Before charges, these trades made ₹800. Charges came to ₹600 (ten trades at ₹60). So the net profit is only ₹200, and charges took 75% of the gross profit. Now the full set of numbers, before and after charges:

    Results of the example trades above, worked out on 10 Nov 2026. Averages are rounded to the nearest rupee and ratios to two decimals.
    NumberHow it is worked outBefore chargesAfter charges
    Total P&LSum of all trades₹800₹200
    Win rateWinning trades divided by all trades40%40%
    Gross profitSum of winning trades₹9,400₹9,160
    Gross lossSum of losing trades, as a positive number₹8,600₹8,960
    Average winGross profit divided by four wins₹2,350₹2,290
    Average lossGross loss divided by six losses₹1,433₹1,493
    Payoff ratioAverage win divided by average loss1.641.53
    Profit factorGross profit divided by gross loss1.091.02
    ExpectancyTotal P&L divided by ten trades₹80 per trade₹20 per trade

    Now the equity curve. The balance peaked at ₹1,02,860 after trade 4. It then fell to ₹98,060 after trade 9. That is a maximum drawdown of ₹4,800, or 4.67% of the peak. The month still ended in profit, at ₹1,00,200. Without the drawdown figure, you would never see that a ₹200 month included a ₹4,800 fall along the way.

    Notice what the dashboard says when you read the numbers together. Win rate is 40%, which sounds weak. At that win rate you need a payoff ratio of 1.5 just to break even (60 divided by 40), and this one is only 1.53. The breakeven calculator in the table above shows the same check for any win rate. Profit factor of 1.02 says the method barely beats its costs. And expectancy of ₹20 per trade is small next to the ₹60 charge per trade. This trader's edge (a real advantage that pays over many trades), if any, is thin.

    To find the break-even line for your own risk reward ratio, see our guide on what a good win rate in trading is.

    Breakdowns that show where your money comes from and goes

    Totals hide the story. Splitting the same ten trades into groups shows which part of your trading pays and which part drains the account. Use your own tags. Common tags for Indian F&O traders are setup, entry time and expiry day or not. Others are option buying or selling, long or short, instrument (for example Nifty 50 or Bank Nifty options) and size.

    Example only: the ten made-up trades above, grouped by setup and by entry time. Built on 10 Nov 2026.
    GroupTradesWinsWin rateNet P&L (₹)
    Setup: Breakout1, 2, 4, 8, 10360%+4,600
    Setup: Reversal3, 5, 6, 7, 9120%-4,400
    Time: First hour1, 3, 5, 9125%-2,840
    Time: Midday2, 4, 6, 10250%+2,860
    Time: Last part7, 8150%+180

    By setup or strategy

    In the example, breakout trades made ₹4,600 and reversal trades lost ₹4,400. The month looked flat only because one setup paid for the other. The lesson from this example is to test whether reversals belong in the plan at all. Keep your setup names short and fixed, or the groups will not add up.

    By time of day

    The first-hour trades lost ₹2,840, while midday trades made ₹2,860. Prices often move fast in the opening period. Some traders do worse then and some do better. Your own data will tell you which group you are in. Log the entry time of every trade. Then group trades by the hour, or by simple buckets such as first hour, midday and last part of the session.

    By expiry day and by day of week

    Option premiums can move fast on expiry day, and some traders take more trades then. Tag each trade as expiry day or not, and compare the two groups. Expiry weekdays on NSE and BSE have changed in recent years, so tag the trade itself rather than assuming a fixed weekday. A day-of-week breakdown can also show if, say, Monday trades after a weekend gap behave differently for you.

    By option buying or selling, long or short, and by size

    Option buying and option selling can give very different result shapes. For example, a seller who collects small premiums may have many small wins and a few large losses. Mixing both styles in one win rate hides this. For futures and stocks, split long trades (buy first) from short trades (sell first) in the same way. You may find you do better on one side. Also group by size. If your largest trades lose the most, the problem may be your size rather than the setup. Fix your size before you enter, using the same rule every time.

    Behaviour analytics: what your data says about your habits

    Some of the most useful patterns are about behaviour, not setups. To see them, log a few extra fields. Note whether you followed your plan, your mood, and the reason for any impulse trade.

    • Revenge trading (trading to win back a loss quickly) shows up as a new trade soon after a loss. It is often in a setup you do not normally use. In the example, trade 9 was the next trade after the trade 8 loss. It broke the rules and was the biggest loss of the month. Your notes on that trade would tell you whether it was revenge. See how to avoid revenge trading.
    • Size spikes show up as a trade much larger than your usual size, often after a win or a loss.
    • Overtrading shows up as days with far more trades than your plan allows, and charges rising faster than profit. See how to avoid overtrading.
    • Plan deviation (breaking your own rules) shows up when you compare trades marked "followed rules" with the rest.

    Rule-following: the comparison that changes behaviour

    Mark each trade Yes or No for "followed my rules". Then compare the two groups. In the example, three trades broke the rules (trades 3, 6 and 9).

    Example only: the ten made-up trades grouped by the "Followed rules?" column. Win rate rounded to the nearest whole number. Built on 10 Nov 2026.
    GroupTradesWin rateNet P&L (₹)
    Followed rules757%+4,980
    Broke rules30%-4,780
    All trades1040%+200

    This is often the most useful table on a dashboard. In this example, the rule-following trades made ₹4,980. The three rule-breaking trades gave away ₹4,780 of it. That kind of number tends to stick in your mind far better than a general promise to be more disciplined.

    How many trades before the numbers mean something

    Small samples swing a lot. Take the same example and remove just one trade, the biggest winner (trade 4, net ₹2,940).

    Example only: effect of removing one winning trade from the ten made-up trades. Worked out on 10 Nov 2026, rounded to the nearest rupee.
    NumberAll ten tradesWithout trade 4
    Win rate40%33.3%
    Profit from winning trades (after charges)₹9,160₹6,220
    Profit factor1.020.69
    Net P&LProfit of ₹200Loss of ₹2,740
    Expectancy₹20 per tradeLoss of ₹304 per trade

    One trade turned a small profit into a clear loss. That is why a handful of trades cannot prove a method works or fails. We have not found a regulator or exchange source that sets a minimum number of trades, so we will not invent one. A practical approach: keep logging, and check whether the numbers stay steady as the count grows. If one or two trades decide the whole result, you do not yet know your edge. The same goes for streaks. A short run of wins or losses can happen by chance, so it does not prove skill or the lack of it.

    Build a trading dashboard in a spreadsheet

    You can build a basic dashboard in Excel or Google Sheets. Both support the COUNTIF, SUMIF and AVERAGEIF functions used below. Keep one row per trade, and never mix gross and net figures in the same column.

    The columns to log

    • A: Date
    • B: Instrument (for example a Nifty 50 option or a stock future)
    • C: Setup name
    • D: Entry time
    • E: Gross P&L
    • F: Charges (from your contract note, the broker's bill for the day, or an estimate)
    • G: Net P&L, with the formula =E2-F2
    • H: Balance. In H2 type your starting balance plus G2, then in H3 use =H2+G3 and copy it down
    • I: Peak balance so far, with =MAX($H$2:H2) copied down
    • J: Drawdown, with =I2-H2 copied down
    • K: Followed rules? (Y or N)
    • L: Notes, mood and mistakes

    For sample rows and the minimum fields every trade record needs, see our guide to keeping a trade log.

    Formulas for each metric

    Spreadsheet formulas, checked 10 Nov 2026 against Microsoft's Excel help and Google's Sheets help for COUNTIF, SUMIF and AVERAGEIF. Answers use the made-up example trades.
    MetricSpreadsheet formula (ten trades in rows 2 to 11)Answer for the example
    Win rate=COUNTIF(G2:G11,">0")/COUNT(G2:G11)40%
    Gross profit=SUMIF(G2:G11,">0")₹9,160
    Gross loss=-SUMIF(G2:G11,"<0")₹8,960
    Profit factor=SUMIF(G2:G11,">0")/-SUMIF(G2:G11,"<0")1.02
    Average win=AVERAGEIF(G2:G11,">0")₹2,290
    Average loss=-AVERAGEIF(G2:G11,"<0")₹1,493
    Expectancy=AVERAGE(G2:G11)₹20
    Maximum drawdown=MAX(J2:J11)₹4,800
    Net P&L of one setup=SUMIF(C2:C11,"Breakout",G2:G11)₹4,600
    Net P&L when rules were broken=SUMIF(K2:K11,"N",G2:G11)Loss of ₹4,780

    Format win rate as a percentage. In the peak column, the formula has a fixed start ($H$2) and a moving end. So each row looks back over every balance so far. The peak starts from the balance after trade 1. If your first trade is a loss, compare it with your starting balance by hand. For drawdown as a percentage of the peak, divide the maximum drawdown by the peak in that row.

    A one-screen layout

    1. Top row: net P&L for the period, win rate, profit factor, expectancy and maximum drawdown.
    2. Middle row: the equity curve as a line chart of column H, and a P&L calendar that colours each day green or red.
    3. Bottom row: small tables by setup, by entry time and by rule-following, like the example tables above.
    4. Side note: total charges for the period and charges as a share of gross P&L.

    Where a spreadsheet starts to break

    A sheet works well for the first few weeks. As rows grow, problems appear. Setup names get typed in different ways, so SUMIF misses rows. Charges have to be worked out by hand for each trade. Time-of-day and behaviour groups need extra helper columns. And any copied formula with a broken range quietly gives wrong totals. If you hit these limits, our comparison of a trading journal in Excel versus an app may help you decide.

    If you are still choosing a tool, our trade tracker guide compares a spreadsheet, a broker report and a journal app.

    Using a journal app instead

    What to look for

    Checklist for choosing a trading analytics tool, written 10 Nov 2026. Criteria only. It does not rank any product.
    CheckWhy it mattersHow to test it
    Net P&L after chargesGross P&L overstates results, as the example showsLog one trade and compare its charges with your contract note
    Indian instrumentsF&O lots, expiries and segments differ from US toolsTry logging an index option and a stock future
    Setup and time breakdownsTotals hide which part of your trading paysTag three trades with two setups and check the split
    Behaviour fieldsRule-breaking and revenge trades often cost the mostLook for fields for mood, plan deviation and mistakes
    Drawdown and equity curveShows the pain inside a profitable periodCheck that drawdown is measured from the running peak
    ExportYou should own your data and be able to leaveFind the export button before you log many trades
    Free plan limitsYou should test it on real trades before payingRead the plan page and note what is limited
    How entries get inSome tools use broker links, others use manual entryDecide which you prefer for privacy and review habits

    How OneTradeJournal fits

    OneTradeJournal is a manual trading journal built for Indian F&O traders, with separate US, crypto and forex workspaces. You log each trade by hand, on purpose, because typing it in makes you look at it once more. There is no broker link and no file import. It estimates brokerage and statutory charges per trade, so your P&L shows after charges. These are estimates, so check them against your contract notes.

    Its reports cover the numbers on this page: a P&L calendar, an equity curve, win rate, profit factor, drawdown, and strategy and time-of-day analysis. Each trade can hold your stop, target, strategy, emotions, plan deviation, mistakes and notes. It flags possible revenge trading, size spikes and overtrading. These flags are simple pattern checks, not a diagnosis. It also gives a discipline score. The free plan allows one trade per day per market and is free forever. AI review features, such as chatting with your own logged trades, are part of the paid plan. OneTradeJournal is not a broker, places no orders and gives no trading signals.

    Market analytics for traders (the other meaning)

    Market analytics helps you decide what to trade. It includes price charts and indicators, and the option chain (a list of an option's strike prices, with the price and number of open contracts at each). It also includes stock screeners that filter shares by rules, and calendars of company results and economic data. Your broker's platform and the exchange websites provide most of these. Our guide to stock screeners covers one of them in detail.

    The two kinds work together. Market analytics produces your trade ideas. Performance analytics tells you which of those ideas actually made money for you, after costs. A trader who only studies the market never learns whether their reading of it pays.

    Before, during and after the trade

    Some guides split trade analysis into phases. Before the trade is research: the chart, the setup and the risk. During the trade is execution: entering, placing the stop and following the plan. After the trade is review, which is where performance analytics lives. Large firms do the same on a bigger scale. They run pre-trade analytics to estimate the cost and price impact of a big order. Afterwards they run transaction cost analysis (a check of what the order really cost).

    For a retail trader, the before step can be simple. Check the setup, fix the stop and size, and look at the likely charges with your broker's brokerage calculator. The after step is the review this page describes. When you log the plan before entry, your review can compare what you planned with what you did.

    Journal, market statistics or backtesting: which tool does what

    • A trading journal stores your own real trades and shows your own numbers. It answers "how do I trade this setup?"
    • Market statistics tools study how a pattern behaved across the market in the past, such as how often a price gap was filled. They answer "how did this setup behave in the market?"
    • Backtesting software runs fixed rules on past prices to simulate results. The results are simulated, so real fills, charges and your own behaviour can make live results differ.
    • Charts and screeners show the market now and help you find trade ideas.

    These tools answer different questions. A setup can look strong in market data or a backtest and still lose money in your hands. Only your own logged trades show that.

    Mistakes that make analytics useless

    • Counting P&L before charges. In the example, this would show four times the real profit.
    • Judging on a few trades. One trade flipped the example from profit to loss.
    • Changing rules while measuring. If the setup keeps changing, its numbers mix two different methods.
    • Logging only wins, or skipping bad days. Missing losses make every number look better than it is.
    • Treating past numbers as a forecast. Your stats describe what happened. They do not promise future results.
    • Tracking too many numbers. Start with the five numbers in the dashboard's top row. Add more only when they answer a real question.

    A simple weekly review routine

    1. Make sure every trade of the week is logged, including losses and charges.
    2. Look at the top row: net P&L, win rate, profit factor, expectancy and drawdown.
    3. Open the setup and time breakdowns. Note the group that lost the most.
    4. Compare rule-following and rule-breaking trades. Read the notes on the worst rule-breaking trade.
    5. Write one change for next week, such as "no reversal trades in the first hour". Keep it to one change so you can measure it.
    6. Next week, check whether that change helped before you add another.
    Keep the same tags

    Write your setup names and mistake labels on a fixed list, and pick from it every time. Breakdowns only work when the same thing always has the same name.

    For a fuller method, see how to review your trades and how to track trading performance.

    Sources

    Related Topics

    trading analyticstrading dashboardtrading performance analyticstrade analytics for traderstrading dashboard templatetrading dashboard freetrading analytics tools

    Related Articles