ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Options Paper Trading Journal
2
Education only; not investment advice. Example rows are HYPOTHETICAL (a fictional NIFTY bull call spread). Replace them with your own paper-trading records.
3
4
Sheets
5
Journal: one row per option LEG round trip (rows 6–45). Yellow cells are inputs; blue cells calculate. Give both legs of a spread the same Trade ID.
6
Summary: totals, and a roll-up by Trade ID (type your Trade IDs in the yellow cells).
7
Four-Week Plan: a suggested practice cadence with space to tick off evidence.
8
Tests: the cases this draft was checked against.
9
10
Convention used by every formula
11
Prices are per underlying unit in ₹. Units are the number of underlying units in the leg (lots × lot size). Check the current lot size on your platform or the exchange; the examples use 75 units, which is hypothetical.
12
Two fill rules are shown side by side. MIDPOINT: entry and exit at (bid + ask) ÷ 2. QUOTE-AWARE: you buy at the ask and sell at the bid, on entry and on exit.
13
First action Buy (long option): P&L per unit = exit price − entry price. First action Sell (short option): P&L per unit = entry price − exit price.
14
Optimism gap = midpoint P&L − quote-aware gross P&L. It is the amount a midpoint assumption overstates a result, before charges.
15
Charges are an INPUT you must enter (total for the leg, entry plus exit). The example uses an illustrative ₹40 per leg, not a real fee schedule. After-cost P&L = quote-aware gross P&L − charges.
16
Real fills can differ from both rules because of depth, slippage, time, order type and exchange rules. Margin, taxes and expiry settlement are NOT modelled.
17
18
Limits
19
Paper results do not predict live results. A quote-aware rule is still an assumption, not a real fill.
20
Draft not yet opened by a person in Excel or Google Sheets. Check the formulas before relying on them.
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