ExcelFree · no sign-upRisk and strategy edge

Position Sizing Worksheet (Lots + Shares)

A 9-column Excel worksheet that turns capital, risk % and stop distance into lots for F&O or shares for equity, with a Settings tab for lot sizes and a Weekly Summary sheet.

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 →
SettingsTrade LogWeekly Summary
SymbolCapitalRisk %₹ RiskStop DistanceLot SizeLotsShares
NIFTY CE5,00,00015,00023653
STOCK X5,00,00015,0006083
Illustrative sizing for an option and a stock.
FormatExcel (.xlsx)
Trade Log sheet9 columns
Best forSizing every trade
Fill itBefore every trade

What is inside

Position size is where risk is actually decided. Picking "2 lots" out of habit means your risk changes every time the stop distance does. This sheet works backwards from the rupees you are willing to lose.

Always round lots down. If the result is 3.3 lots, the answer is 3. The Notes column is for any personal cap that is lower than the formula.

Settings · 3 columns

Trading capital, max daily loss, max risk per trade %, Nifty and Bank Nifty lot size, broker.

  • Setting
  • Value
  • Notes

Trade Log · 9 columns

One row per sizing calculation.

  • Symbol
  • Capital
  • Risk %
  • ₹ Risk
  • Stop Distance
  • Lot Size
  • Lots
  • Shares
  • Notes

Weekly Summary · 7 columns

One row per week for the Friday review.

  • Week Ending
  • Trades
  • Net P&L ₹
  • Win Rate
  • Best Tag
  • Worst Rule Break
  • One Change

Worked example

1% risk on ₹5,00,000

A Nifty option with a 23-point stop, and a stock at ₹3,000 with a ₹60 stop (illustrative).

₹ Risk
₹5,000
Risk per lot
₹1,495
Lots
3
Shares
83

Three lots risk ₹4,485, under the ₹5,000 limit. Check margin too: the sheet sizes by risk, not by margin.

The numbers

₹ Risk = Capital × Risk %5,00,000 × 1% = ₹5,000
Lots = ₹ Risk ÷ (Stop × Lot size), rounded down5,000 ÷ (23 × 65) = 3.3 → 3 (check the current NSE circular, lot sizes are revised periodically)
Shares = ₹ Risk ÷ stop per share5,000 ÷ 60 = 83

Formulas to paste in

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

₹ Risk (D2)
=B2*C2/100
Lots (G2)
=ROUNDDOWN(D2/(E2*F2),0)
Shares (H2)
=ROUNDDOWN(D2/E2,0)

How to fill it

  1. Update SettingsSet your capital and confirm the lot sizes: Nifty 65, Bank Nifty 30 (check the current NSE circular, lot sizes are revised periodically).
  2. Enter risk % and stopFill Risk % and the stop distance in points or rupees per share.
  3. Read lots or sharesUse the rounded-down result, or a lower personal cap.
  4. Copy the size to your journalLog the planned ₹ risk with the trade.

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

How many lots of Nifty should I trade?

Divide the rupees you are willing to lose on the trade by the stop distance times the lot size, then round down. With ₹5,000 risk and a 23-point stop on a lot of 65, that is 3 lots.

What risk % per trade is normal?

Many traders use 0.5% to 1% of capital per trade as a rule of thumb. Pick a number that keeps a run of ten losses survivable.

Is the Position Sizing Worksheet (Lots + Shares) 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.