Options Tracker

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	Stock Symbol	Open Date	Exp Date	Call or Put	B/S	Stock Price DOC	DTE	Current Stock Price	Break Even Price	Strike Price	Premium	C	(Put) Cash Reserve	(Put) Margin Cash Reserve	(Call) Cost Basis/Share	Fees	Exit Price	Close Date	Profit/Loss	Days Held	Annualized ROR for Options	Margin Annualized ROR	Status	Account

2	JCP	3/7/14	9/4/15	Call	B		0	#N/A	9.58	5	4.58	2	---------	---------		6.14	4.65	9/4/15	7.86	546	0.57%	-----------	Closed	TD Ameritrade
3	AAPL	7/29/15	9/4/15	Call	S		0	198.51	129.9	129	0.9	1	---------	---------	120	10.03	0.14	8/12/15	65.97	14	13.33%	-----------	Closed	Schwab
4	AAPL	8/12/15	9/25/15	Call	S		0	198.51	121.38	119	2.38	1	---------	---------	1	10.04	1.05	9/2/15	122.96	21	17.96%	-----------	Closed	Schwab
5	AAPL	9/2/15	10/16/15	Call	S		0	198.51	118.57	115	3.57	1	---------	---------		10.05	0.59	10/1/15	287.95	29	31.51%	-----------	Closed	Schwab
6	AAPL	9/4/15	9/11/15	Call	S		0	198.51	112.64	111	1.64	1	---------	---------		5.02	0	9/11/15	158.98	7	74.68%	-----------	Exercised	Schwab
7	BA	1/29/16	1/20/17	Put	S	120.13	0	185.96	103.25	115	11.75	1	11500	3665.25		10.04	6.76	3/18/16	488.96	49	31.67%	99.37%	Closed	Schwab
8	GILD	10/3/16	11/11/16	Put	S	78.03	0	97.88	73.35	75	1.65	1	7500	1812.75		5.01			159.99	39	19.96%	82.60%	Open	Schwab
9	KO	10/3/16	11/11/16	Put	S	42.03	0	71.72	39.72	40	0.28	2	8000	1751.5		5.05			50.95	39	5.96%	27.22%	Open	Schwab
10	BA	10/4/16	11/18/16	Put	S	132.25	0	185.96	118.95	120	1.05	1	12000	2186.25		5.01			99.99	45	6.76%	37.10%	Open	Schwab
11	NEM	10/4/16	11/11/16	Put	S	34.265	0	54.61	30.69	31.5	0.81	1	3150	661.125		5.01			75.99	38	23.17%	110.40%	Open	Schwab
12
13
14
15
16
17
18
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

	A	B	C	D	E	F	G
1					Option Portfolio Summary
2
3		Account	Open Profit/Loss	Closed Profit/Loss	Cash Reserve	Margin Cash Reserve	Total Fees
4		Schwab	$386.92	$1,124.82	$30,650.00	$6,411.63	$65.26
5		TD Ameritrade	$0.00	$7.86	$0.00	$0.00	$6.14
6
7		Totals	$386.92	$1,132.68	$30,650.00	$6,411.63	$71.40
8
9
10			Monthly Option Income per Year
11		Month	2015	2016	2017
12	1	January	$0.00	$0.00	$0.00
13	2	February	$0.00	$0.00	$0.00
14	3	March	$0.00	$488.96	$0.00
15	4	April	$0.00	$0.00	$0.00
16	5	May	$0.00	$0.00	$0.00
17	6	June	$0.00	$0.00	$0.00
18	7	July	$0.00	$0.00	$0.00
19	8	August	$65.97	$0.00	$0.00
20	9	September	$289.80	$0.00	$0.00
21	10	October	$287.95	$0.00	$0.00
22	11	November	$0.00	$0.00	$0.00
23	12	December	$0.00	$0.00	$0.00
24		YTD Total	$643.72	$488.96	$0.00
25
26
27		Annual Option Income
28		Year	Option Income
29		2015	$643.72
30		2016	$488.96
31		2017	$0.00
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53

	A	B	C	I
1	Options Tracker speadsheet is provided as-is by twoinvesting.com. I am not a financial advisor but just someone interested in investing. For further information about this spreadsheet please visit http://www.twoinvesting.com/2016/10/options-tracker-spreadsheet/.
2
3	For questions or concerns regarding this spreadsheet please contact me at http://www.twoinvesting.com/contact-us/
4
5	Quotes may be delayed by up to 20 minutes. Information is provided 'as is' and solely for informational and entertainment purposes, not for trading purposes or advice. I am not a licensed investment advisor or investment professional. I make no representations as to accuracy, completeness, recentness, or validity of any information on this spreadsheet and will not be liable for any errors, omissions, or delays in this information or any losses, injuries, or damages arising from its display or use. Please do not rely on this data for tax purposes. Unless your investments are FDIC insured, they may decline in value. Please consult with an investment professional before investing any of your money.
6
7	If important formulas change, what and how to change them will be discussed here.
8
9	Version	Date	Version History	Reference Formulas/Links
10	1.0.1	1/17/2017	Fixed formulas for annualized return (off very slightly in initial version). Also added ability to calculate annualized returns for buying covered calls and puts	Column U should be '=if(isblank(A2),,if(AND(D2="Put",E2="S"),(S2/M2)/T2365,if(AND(D2="Call",E2="S"),(S2/(100L2J2))/T2365, (S2/(K2L2100)/T2365)))) Column V should be '=if(isblank(A2),,if(AND(D2="Put",E2="S"),(S2/N2)/T2365,"-----------"))
11	1.0	10/9/2016	Initial version. For instructions on use please see the website to the right.	http://www.twoinvesting.com/2016/10/options-tracker-spreadsheet/
12