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 →| Metric | Value |
|---|---|
| Win rate | 55% |
| Profit factor | 1.33 |
| Max drawdown ₹ | −8,900 |
| Expectancy ₹ | 330 |
| Total trades | 20 |
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).
A profit factor of 1.33 on 20 trades is a start, not proof. Keep importing until you have 50 or more.
The numbers
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
- Export your tradesDownload the month’s trade or P&L report from your broker’s back office as CSV.
- Map the columnsPaste into Import from row 2, matching the nine headers. Use net P&L after charges.
- Paste the formulas onceAdd the formulas on this page to the Metrics Value column.
- 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.
Related templates
Read next
Free calculators
Terms on this sheet
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.