Trading Journal & Trade P&L Analyzer (Stocks, F&O, Crypto)

About the Trading Journal & Trade P&L Analyzer (Stocks, F&O, Crypto)

A trading journal turns the trades you have already made into answers: which setups pay, which days and hours cost you, how much the charges take, and how deep the losing runs go. Import the tradebook or trade history your broker or exchange lets you download, as CSV or Excel — the date and time, symbol, buy or sell, quantity and price of every executed trade — or add trades by hand. Columns are recognised by their headings; when a file names them differently, choose them once and the journal remembers that layout.

Fills are grouped into round-trip trades, first in, first out, from the moment a position opens until it is flat again. Each trade gets its gross and net P&L — after the charges in the file, a percentage, an amount per order, or India’s STT, exchange charges, stamp duty and GST with your broker’s brokerage — and its R-multiple from the stop-loss you record, with a strategy, tags, notes and chart screenshots. The reports show the win rate, average win and loss, expectancy, profit factor, maximum drawdown and streaks, results by strategy, symbol, weekday and time of day, an equity curve and a calendar heat map. The journal is kept in your browser: nothing you import leaves your device.

Common uses

• Find which strategies and setups make money after charges, and which do not.
• See the weekdays and hours in which you lose money.
• Measure your expectancy in R before trading larger.
• Keep the reason, the notes and a chart screenshot with every trade for your weekly review.

From fills to trades

A tradebook lists fills: each executed buy or sell. The journal groups them symbol by symbol into round trips. A trade opens when the position leaves zero and closes when it is back at zero, however many times you add or take some off in between. Sells are matched against the oldest buys first (first in, first out), and the other way round for shorts. A fill that takes the position through zero — selling 15 when you hold 10 — closes the trade and opens the next one with the rest, and its charges are split in proportion.

A position that is not flat at the end of the file is an open trade: it is listed, but the statistics count closed trades only. Notes stay with a trade when you import more files, because a trade is known by its symbol, when it opened and its first fill.

What the figures mean

• Win rate: closed trades with a net profit ÷ all closed trades.
• Average win and average loss: the mean net P&L of the winners and of the losers.
• Expectancy: the average net P&L of a trade — the win rate × the average win plus the loss rate × the average loss. In R, it is the average R-multiple of the trades with a stop-loss or an amount at risk.
• R-multiple: a trade’s net P&L ÷ what it risked, |entry − stop-loss| × quantity. A trade stopped out as planned is about −1R.
• Profit factor: the net profit of all winners ÷ the net loss of all losers. Above 1, the winners made more than the losers lost.
• Maximum drawdown: the deepest fall of the equity curve below an earlier high, in money, and in % of your starting capital plus that high.
• Streaks: the longest runs of winners and of losers in a row, in the order the trades closed.
• Weekday and time of day are those of the entry, as the file writes them.

Charges

Net P&L is gross P&L less charges. Choose how they are counted under Charges and settings: only those in the file’s charges or commission column; a % of turnover (entries and exits); an amount per order; or India’s charges — STT, exchange transaction charges, SEBI fees, stamp duty and GST at the rates of the brokerage calculator, with your broker’s brokerage on each order and a DP charge on delivery sales. With From each trade, a symbol with a strike and CE or PE is an option, one with FUT a future, and other trades are intraday when they open and close on the same day and delivery otherwise. Each trade counts as one buy and one sell order; your contract notes have the exact figures.

Most individual F&O traders lose money

SEBI’s study of individual traders in the equity derivatives segment found that nearly nine out of ten lost money: 87.7% made a net loss in the latest year it covers. Before transaction costs, 82.1% did — the charges pushed traders with small gross profits into losses. Individual traders paid about ₹25,000 crore of transaction costs in each of the last two years it covers.

A journal does not change those odds, but it shows whether your own trades beat them after charges, and where the money goes. Size each trade with the position size calculator and check the margin with the F&O margin calculator.

Your journal stays on your device

Files are read in your browser and nothing is uploaded. With Keep the journal in this browser ticked, the fills, notes and screenshots are saved in this browser’s storage; screenshots are made smaller first (at most 1,280 pixels on the longest side, as JPEG), and together they can take about 2.4 MB. Clearing the site’s data in the browser deletes the journal, so download a backup — a file you can restore here, in this or another browser — from time to time. Delete the journal removes everything at once.

Limitations

• One currency: the P&L of all trades is added up as the files write it, so keep trades in different currencies in separate journals or convert them first.
• Fills are matched first in, first out in each symbol. A broker’s own P&L may use average prices or include open positions and differ for trades that scale in and out.
• India’s charges are an estimate at the brokerage calculator’s rates, counting one buy and one sell order a trade.
• Expiries, assignments and corporate actions that are not in the tradebook as trades are not included.
• The journal lives in this browser: clearing the site’s data deletes it. Download backups.
• Not investment advice: past results do not predict future ones.

Privacy

Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot.