A ready-made trade log that works out net P&L after charges, R-multiple, win rate by strategy, monthly results and what your mistakes cost. Excel, Google Sheets or LibreOffice.
Enter your email and the download starts straight away. We'll also email you the link.
If the download didn't start, click here to download.
Free, no account needed. Unsubscribe from the emails in one click.
One row per closed trade. You type the white columns; the grey ones calculate themselves.
| You type | The sheet calculates |
|---|---|
| Date, broker, segment, instrument, strategy tag | Gross P&L: (exit − entry) × qty, reversed for shorts |
| Side (Long/Short), qty, entry, exit | Net P&L: gross P&L − charges |
| Planned stop | Risk ₹: |entry − stop| × qty |
| Charges from the contract note | R-multiple: net P&L ÷ risk |
| Mistake tag, why I entered, what I'd do differently | Result (Win/Loss) and month, which feed the summary sheets |
STT, brokerage, exchange charges, GST, stamp duty and the SEBI fee come off every trade. For active intraday and options traders they can turn a profitable-looking month into a loss. That's why the template asks for the total from your broker's contract note instead of guessing: F&O STT rates have changed more than once, and a sheet with old rates overstates your profit.
Open Google Sheets, choose File → Import → Upload, pick the file and select Replace spreadsheet. Every formula carries over. Delete the three grey example rows once you've seen how they work.
A spreadsheet is great for the first few months. It gets painful when you trade several times a week, use two brokers, or need FIFO-matched records for ITR-3. Read our honest spreadsheet vs trading journal comparison, or see how to set up a trading journal template step by step.
Tired of typing trades? TradeDiary imports your Zerodha, Upstox, Kotak, Dhan and other broker files, matches trades FIFO, itemises every Indian charge and builds these reports for you.
Start Free — No Credit Card →Yes. Enter your email and the .xlsx downloads straight away. There's no trial and nothing to cancel. We'll send a few short emails on using it well, and you can unsubscribe in one click.
Yes. In Google Sheets choose File, then Import, and upload the file. Every formula uses functions that work the same in Excel, Google Sheets and LibreOffice.
Because STT and exchange charges on F&O have changed more than once, and a template with old rates quietly overstates your profit. Your broker's contract note shows the exact total for every trade, so the sheet uses that.
Yes. Pick Futures or Options as the segment, enter quantity in units (lots × lot size), and mark option selling as Short. Net P&L, R-multiple and win rate work the same way for every segment.
It gives you a clean trade-wise record with charges, which is what your CA asks for. It doesn't do FIFO matching or compute F&O turnover; TradeDiary does both automatically from your broker files.