ExcelFree · no sign-upIntraday and cash equity

Broker CSV → Metrics Analyzer

A two-sheet Excel workbook: an Import sheet with nine columns to paste a broker export into, and a Metrics sheet with win rate, profit factor, max drawdown, expectancy and total trades.

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 →
MetricsImport
MetricValue
Win rate55%
Profit factor1.33
Max drawdown ₹−8,900
Expectancy ₹330
Total trades20
Metrics sheet filled from 20 illustrative imported trades.
FormatExcel (.xlsx)
Metrics sheet2 columns
Best forTraders with broker exports
Fill itMonthly

What is inside

Most broker exports list trades but not the numbers you review with. This workbook gives the export a fixed shape so the same five formulas work every month.

The download ships with headers only, so map your broker’s columns to Date, Symbol, Side, Qty, Entry, Exit and Net P&L, then paste the formulas listed here into the Metrics sheet once.

Metrics · 2 columns

Five headline numbers. Paste the formulas below into the Value column.

  • Metric
  • Value

Import · 9 columns

Paste or map your broker’s trade export from row 2.

  • Date
  • Symbol
  • Side
  • Qty
  • Entry
  • Exit
  • Net P&L
  • Brokerage
  • Notes

Worked example

A month of 20 trades

11 winners totalling ₹26,400 and 9 losers totalling ₹19,800 after charges (illustrative).

Win rate
55%
Profit factor
1.33
Expectancy
₹330

A profit factor of 1.33 on 20 trades is a start, not proof. Keep importing until you have 50 or more.

The numbers

Win rate = winners ÷ trades11 ÷ 20 = 55%
Profit factor = gross wins ÷ gross losses26,400 ÷ 19,800 = 1.33
Expectancy = net P&L ÷ trades6,600 ÷ 20 = ₹330

Formulas to paste in

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

Win rate
=COUNTIF(Import!G:G,">0")/COUNT(Import!G:G)
Profit factor
=SUMIF(Import!G:G,">0")/-SUMIF(Import!G:G,"<0")
Expectancy ₹
=AVERAGE(Import!G:G)
Total trades
=COUNT(Import!G:G)

How to fill it

  1. Export your tradesDownload the month’s trade or P&L report from your broker’s back office as CSV.
  2. Map the columnsPaste into Import from row 2, matching the nine headers. Use net P&L after charges.
  3. Paste the formulas onceAdd the formulas on this page to the Metrics Value column.
  4. Save a copy per monthKeep one file per month so you can compare.

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

Does the analyzer calculate metrics automatically?

Not out of the box. The workbook ships with headers; paste the formulas listed on this page into the Metrics sheet once and they update whenever you paste a new export.

How do I calculate max drawdown in Excel?

Add a running total of Net P&L, a running maximum of that total, and take the lowest value of running total minus running maximum. That lowest value is your max drawdown in rupees.

Is the Broker CSV → Metrics Analyzer 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.