ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Overnight Gap Risk Exercise Worksheet
2
Education only; not investment advice. Example rows are HYPOTHETICAL and use made-up symbols. Replace them with your own records.
3
4
Sheets
5
Journal: one row per overnight exercise (rows 6–45). Yellow cells are inputs; blue cells calculate.
6
Summary: totals across the Journal rows.
7
Gap Sensitivity: one position under a list of gap sizes you choose, plus the gap that equals your stop and a gap-based size.
8
Tests: the cases this draft was checked against.
9
10
Simulation convention used by every formula
11
The exercise looks at ONE moment: the next session's opening price. Previous close is the last price of the session before the gap.
12
A stop is treated as triggered if the open is at or beyond the stop (Long: open ≤ stop; Short: open ≥ stop).
13
A triggered stop-market order is assumed to fill AT THE OPEN. A real market or a simulator may fill elsewhere: check your platform's rule.
14
A triggered stop-limit order is assumed to fill at the open only if the open is at or better than the limit (Long: open ≥ limit; Short: open ≤ limit). Otherwise it does not fill and the position stays open.
15
P&L is measured from your entry price to the open: Long = (open − entry) × quantity; Short = (entry − open) × quantity. Negative = loss.
16
Realised means the stop filled. Floating means the position is still open at the open.
17
Planned risk = quantity × |entry − stop|. Loss ÷ planned risk above 1.00 means the loss exceeded the plan.
18
Fees, taxes, slippage after the open and intraday moves are NOT included.
19
20
Limits
21
Paper or simulated overnight fills are not proof of live execution. Spreads and liquidity at the open can differ from a simulator.
22
Draft not yet opened by a person in Excel or Google Sheets. Check the formulas before relying on them.
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