ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Options Strategy Margin Comparison Worksheet
2
Education only; not investment advice and NOT a margin calculator. All example rows are HYPOTHETICAL. The 'funds blocked' figures in the example are INVENTED to show structure; they were not produced by an exchange, clearing corporation or broker.
3
4
Sheets
5
Payoff Calc: up to four legs → net premium cash flow and expiry payoff at index levels you choose, plus the best and worst payoff at test points. This is payoff arithmetic only.
6
Margin Comparison: up to six strategies side by side: premium cash flow, maximum theoretical loss, margin shown at order entry, final funds blocked and simple ratios. YOU type the margin figures from your broker's calculator or order window.
7
Verification Checklist: eight steps for checking margin on a dated, complete basket, with space to note the evidence you kept.
8
Tests: the cases this draft was checked against.
9
10
Convention used by every formula
11
Prices are per underlying unit in ₹. Quantity is in units (lots × lot size). Check the current lot size on the exchange or your platform; the example uses 60 units, which is hypothetical.
12
Payoff at expiry per unit: Buy call = max(index − strike, 0); Sell call = −that; Buy put = max(strike − index, 0); Sell put = −that. Total payoff = sum over legs × units + net premium cash flow (credit +, debit −). Costs, taxes and slippage are NOT included.
13
Test points are the index at 0, each leg's strike and twice the highest strike. Payoff is piecewise linear, so extremes occur at those points unless the position has an open-ended slope. If the slope above the highest strike is not zero, the sheet flags the loss or profit as open-ended and the worst/best figure is NOT a limit.
14
Margin is NOT maximum loss. Funds blocked ÷ maximum loss and funds blocked ÷ premium are arithmetic ratios of the numbers you type. They do not measure return, probability or quality of a strategy.
15
16
Limits
17
A payoff spreadsheet cannot reproduce risk-based margin (for example SPAN). Always take the margin figure from a dated broker quote that includes every leg, and record the source type on the Margin Comparison sheet.
18
Draft not yet opened by a person in Excel or Google Sheets. Check the formulas before relying on them.
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