ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Expiry-Day Paper Trading Practice Worksheet
2
Education only; not investment advice. Every example number is FICTIONAL (synthetic scenario, no market feed). It is not a live quote, a market record or a real lot size.
3
4
Sheets
5
Straddle Calc: enter a strike and the call and put asks you paid. It returns the debit, breakevens and net expiry P&L at final index levels you choose, for a long straddle and the opposite short straddle (gross).
6
Journal: one row per timestamp. Enter the index and each leg's bid and ask. It shows the midpoint value, the executable bid value, the 'optimism gap' between them and mark-to-market P&L at the bid.
7
Summary: entry debit, quantity, assumed charges, planned and completed observations, worst mark-to-market P&L, settlement result and cost sensitivity.
8
Tests: the checks this draft was tested against.
9
10
Conventions
11
Prices are in ₹ (index points) per underlying unit. Quantity is in units (lots × lot size). The example uses 60 hypothetical units, NOT a real lot size. Check the current lot size from the exchange's contract details or your platform and write down the date you checked.
12
Long straddle entry: you buy at the ASK, so entry debit = call ask + put ask. Marks use the BID, the price you could actually sell at. Midpoint value is shown only to measure how optimistic a midpoint mark is.
13
Net expiry P&L per unit (long straddle) = max(S − K, 0) + max(K − S, 0) − debit = |S − K| − debit, where S is the final settlement and K the strike. Charges, taxes and slippage are NOT in the per-unit figure; Summary subtracts the assumed charges you enter.
14
Short straddle gross P&L per unit = debit − |S − K| (the opposite of the long result). It has large risk as the move grows and needs margin; it is shown for study, never as a starting point.
15
Mark-to-market uses the bid of both legs. The 'worst mark' reads only the rows you logged, so a worse path between observations is not captured; the settlement result can also be worse than any logged mark.
16
17
Limits
18
This is a practice journal. It cannot reproduce margin, real fills, partial fills or the stress of real money. Check expiry dates, lot sizes, margin, charges and settlement rules from current official and broker sources.
19
Draft not yet opened by a person in Excel or Google Sheets. Check the formulas before relying on them.
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