ExcelFree · no sign-upRisk and strategy edge

Risk Management Dashboard (₹ Drawdown Limits)

A 9-column Excel sheet with one row per day: peak equity, current equity, drawdown in % and rupees, daily P&L against your daily limit, and a status column.

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
DatePeak EquityCurrent EquityDrawdown %Drawdown ₹Daily P&LDaily LimitStatus
03/06/20265,20,0005,17,1000.562,900+1,4005,000OK
04/06/20265,20,0005,12,0001.548,000−5,1005,000STOP
Illustrative days. Status turns to STOP when the daily loss passes the limit.
FormatExcel (.xlsx)
Trade Log sheet9 columns
Best forDaily risk limits
Fill itEnd of every day

What is inside

Two limits protect an account: one for the day and one for the whole drawdown. This sheet tracks both on one row so you see them together at the close.

Peak Equity only goes up. Drawdown is measured from it, which is why a good week followed by a bad day can still show a sizeable drawdown.

Trade Log · 9 columns

One row per trading day.

  • Date
  • Peak Equity
  • Current Equity
  • Drawdown %
  • Drawdown ₹
  • Daily P&L
  • Daily Limit
  • Status
  • Notes

Worked example

Daily cap hit

Peak equity ₹5,20,000. The day closes at ₹5,12,000 after a −₹5,100 day against a ₹5,000 daily limit (illustrative).

Daily P&L
−₹5,100
Drawdown
₹8,000
Drawdown %
1.54%
Status
STOP

STOP means no new trades for the rest of the day, whatever the setup looks like.

The numbers

Drawdown ₹ = Peak − Current5,20,000 − 5,12,000 = ₹8,000
Drawdown % = Drawdown ₹ ÷ Peak8,000 ÷ 5,20,000 = 1.54%

Formulas to paste in

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

Peak Equity (B3)
=MAX(B2,C3)
Drawdown ₹ (E2)
=B2-C2
Drawdown % (D2)
=E2/B2*100
Status (H2)
=IF(-F2>=G2,"STOP","OK")

How to fill it

  1. Set your daily limitWrite it in Daily Limit; 1% of capital is a common rule of thumb.
  2. Fill one row each eveningEnter Current Equity and Daily P&L from your broker.
  3. Respect STOPIf Status shows STOP during the day, close the terminal.
  4. Watch total drawdownDecide in advance what drawdown % pauses live trading.

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

Terms on this sheet

Questions traders ask

What is a good daily loss limit?

Many traders cap the day at about 1% of capital, or two full-size losses. The right number is one you will actually stop at.

What is the difference between daily loss and drawdown?

Daily loss is one day’s P&L. Drawdown is how far equity sits below its highest point, which can build up over many days.

Is the Risk Management Dashboard (₹ Drawdown Limits) 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.