ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Paper Trading Position Size Calculator (India)
2
Prepared 17 Nov 2026. For education only; not investment advice. All numbers are illustrative.
3
4
What it does: turns virtual capital, a planned risk %, an exposure cap, an entry and a stop into a practice quantity (whole shares, or whole lots you specify).
5
Sheets: Calculator (one trade) · Portfolio (planned risk across open trades) · Tests (18 cases with expected results).
6
7
How to use it:
8
1. Calculator: set virtual capital, risk % and exposure cap % in the yellow cells.
9
2. Choose Equity shares or F&O lots, Long or Short, then type entry and stop. For F&O also type the CURRENT lot size from the exchange's contract file.
10
3. Read 'Input check' first. Results show only when it says OK.
11
4. FINAL QUANTITY is the smaller of the risk-based and exposure-based quantities, rounded down. 'Binding constraint' says which one decided it.
12
13
Limits you should know:
14
• Planned risk is not a guaranteed maximum loss. Gaps, slippage, liquidity and execution rules can change a real or simulated result.
15
• Costs, slippage and taxes are not included.
16
• F&O mode only rounds to whole lots. It does not model margin, SPAN, option Greeks or the loss profile of short options and futures.
17
• Lot sizes are set by the exchange and change. The workbook ships with no lot size; any number in the Tests sheet is hypothetical.
18
• Tested by script only. Not yet opened by a person in Excel or Google Sheets.
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100