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 →| Symbol | Capital | Risk % | ₹ Risk | Stop Distance | Lot Size | Lots | Shares |
|---|---|---|---|---|---|---|---|
| NIFTY CE | 5,00,000 | 1 | 5,000 | 23 | 65 | 3 | |
| STOCK X | 5,00,000 | 1 | 5,000 | 60 | 83 |
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).
Three lots risk ₹4,485, under the ₹5,000 limit. Check margin too: the sheet sizes by risk, not by margin.
The numbers
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
- Update SettingsSet your capital and confirm the lot sizes: Nifty 65, Bank Nifty 30 (check the current NSE circular, lot sizes are revised periodically).
- Enter risk % and stopFill Risk % and the stop distance in points or rupees per share.
- Read lots or sharesUse the rounded-down result, or a lower personal cap.
- 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.
Related templates
Read next
Free calculators
Terms on this sheet
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.