ExcelFree · no sign-upReview and discipline

Monthly Performance Report (₹)

An 8-column Excel report with one row per month: net P&L, trades, win rate, profit factor, best and worst setup, and a line of reflection.

The .xlsx opens in Excel, LibreOffice or Google Sheets (upload it to Drive, then open with Sheets). Delete the sample row before you log real trades.

See a worked example →
Trade Log
MonthNet P&LTradesWin RateProfit FactorBest SetupWorst SetupReflection
Apr 2026−6,2005847%0.91orbexpiry-thetaToo many expiry trades
May 2026+17,0006452%1.21orbexpiry-thetaHalve expiry size
Illustrative months.
FormatExcel (.xlsx)
Trade Log sheet8 columns
Best forMonthly review
Fill itFirst weekend of the month

What is inside

The weekly review fixes behaviour. The monthly report is where you decide what to keep trading. Twelve rows a year is short enough to read in one look.

Best Setup and Worst Setup are the two columns to compare across months. A setup that is worst three months running is a candidate to pause.

Trade Log · 8 columns

One row per month.

  • Month
  • Net P&L
  • Trades
  • Win Rate
  • Profit Factor
  • Best Setup
  • Worst Setup
  • Reflection

Worked example

A green month with one weak setup

May: ORB made ₹28,000 and expiry-theta lost ₹11,000, for a net of ₹17,000 (illustrative).

Net P&L
+₹17,000
orb
+₹28,000
expiry-theta
−₹11,000

Two red months in a row for expiry-theta: halve its size or pause it. Leave ORB alone.

The numbers

Net = best + worst + others28,000 − 11,000 + 0 = ₹17,000

Formulas to paste in

The download has headers and a sample row, not formulas. These match its column letters.

Year-to-date net
=SUM(B:B)
Months with the same worst setup
=COUNTIF(G:G,"expiry-theta")

How to fill it

  1. Total last monthFrom your journal, total net P&L, trades, win rate and profit factor.
  2. Name best and worst setupsUse your journal’s setup tags.
  3. Write one line of reflectionOne decision for the month ahead.
  4. Compare with earlier monthsLook down the Worst Setup column for repeats.

Same review, without the typing

TradeLyser imports trades from supported Indian brokers by sync or CSV, with charges, and shows win rate, profit factor and drawdown for each strategy.

Try TradeLyser free

Read next

Questions traders ask

What should a monthly trading report include?

Net P&L after charges, trade count, win rate, profit factor, your best and worst setups, and one written decision.

Is this an Excel or Google Sheets file?

It downloads as an .xlsx file that opens in Excel, or in Google Sheets after you upload it to Drive.

Is the Monthly Performance Report (₹) free?

Yes. The download link on this page needs no sign-up or email. The workbook ships with column headers and one sample row; add your own formulas or use the ones listed on this page.