| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | Original Total Cost of Hedge (cost of LONG PUTs) | $0.00 | ||||||
2 | Sum of ALL credits received (value of credits from selling short puts to date) | $0.00 | ||||||
3 | Unpaid cost of legacy Hedge (amount you still need to fully pay for the hedge) | $0.00 | ||||||
4 | ||||||||
5 | ||||||||
6 | ||||||||
7 | today | 9/17/2025 | ||||||
8 | Value of Portfolio (TODAY) without options | $400,000.00 | ||||||
9 | Current SPY Price | $324.00 | OUTPUT | |||||
10 | Strike Price of Long Put (new LONG PUT) | 324 | $12.98 | <--Enter MID Price Here | ENTER DATA | |||
11 | Expiration Date of Long Put | 7/17/2020 | ||||||
12 | Weeks Left | -269 | ||||||
13 | Hedge Needed (# of SPY LONG PUTs) | 12 | 12.3 | <--Unrounded | ||||
14 | New Hedge Cost (excluding extra PUTs) | $15,576.00 | ||||||
15 | ||||||||
16 | Cost of 1 Extra PUT | $1,298.00 | ||||||
17 | ||||||||
18 | Commissions Cost Per 1 Contract | $0.75 | <-- If you use something other than IB, you may need multiple iterations | |||||
19 | Target Weekly Extrinsic | $0.75 | ||||||
20 | ||||||||
21 | Exact | Rounded | ||||||
22 | Number of Extra PUTs | -0.74 | #NUM! | |||||
23 | ||||||||
24 | ||||||||
25 | ||||||||
26 | Made by | |||||||
27 | Max Todorov | |||||||
28 | www.linkedin.com/in/maxtodorov/ | |||||||
29 | maxtodorov@yahoo.com |