Demo2

	A	B	C	D	E	F	G	H	I	J	K	L	N	O	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	Date	Spread	Side	QTY	Symbol	Option Code	Expiry	Mos Out	Strike	Type	Price	Value	Stock Value	Asset Balance	Stock						Strike							Purchase Cost	Current Value	Profit/Loss
2	4/22/2016	Covered	Buy	100	AAPL		N.A.		N.A.	Stock	105.27	10527		-$10,527	Name	Buy	Sell	Closing	CMP	Value	Name	Buy	Sell	Closing	CMP	Value	AAPL	10527	14290	3763
3	4/22/2016	Covered	Buy	1	AAPL	AAPL180119P105	19 Jan 2018	-63	105	Put	15.78	1578	$10,500	-$1,578	AAPL	100	0	100	142.9	14290	105	1	1	0	0	0	145	1815	2000	185
4	8/16/2016	Single	Sell	1	AAPL	AAPL180119P105	19 Jan 2018	-63	105	Put	10.9	1090		$1,090							110	1	1	0	0	0				3948
5	8/16/2016	Single	Buy	1	AAPL	AAPL180119P110	19 Jan 2018	-63	110	Put	13.25	1325	$11,000	-$1,325							115	1	1	0	0	0
6	9/15/2016	Single	Sell	1	AAPL	AAPL180119P115	19 Jan 2018	-63	110	Put	11.6	1160		$1,160							120	1	1	0	0	0
7	9/15/2016	Single	Buy	1	AAPL	AAPL180119P115	19 Jan 2018	-63	115	Put	13.95	1395	$11,500	-$1,395							125	1	1	0	0	0
8	1/17/2017	Single	Sell	1	AAPL	AAPL180119P115	19 Jan 2018	-63	115	Put	9.4	940		$940							130	1	1	0	0	0
9	1/17/2017	Single	Buy	1	AAPL	AAPL190118P120	18 Jan 2019	-51	120	Put	17.4	1740	$12,000	-$1,740							135	1	1	0	0	0		How do they come up with P/L Open and P/L Diff?
10	2/1/2017	Single	Sell	1	AAPL	AAPL190118P120	18 Jan 2019	-51	120	Put	13.6	1360		$1,360							140	1	1	0	0	0		I'm also not sure how they came up with the Cash & Sweep value
11	2/1/2017	Single	Buy	1	AAPL	AAPL190118P125	18 Jan 2019	-51	125	Put	15.55	1555	$12,500	-$1,555							145	1	0	1	20	2000
12	2/1/2017	Single	Sell	1	AAPL	AAPL190118P125	18 Jan 2019	-51	125	Put	14.75	1475		$1,475														pl/open 3,894	What have you titled this value?
13	2/1/2017	Single	Buy	1	AAPL	AAPL190118P130	18 Jan 2019	-51	130	Put	17.25	1725	$13,000	-$1,725														p/l diff 1,450	What have you titled this value?
14	2/14/2017	Single	Sell	1	AAPL	AAPL190118P130	18 Jan 2019	-51	130	Put	15.45	1545		$1,545
15	2/14/2017	Single	Buy	1	AAPL	AAPL190118P135	18 Jan 2019	-51	135	Put	17.7	1770	$13,500	-$1,770														From Raj: Stock Purchase cost - Stock sales cost at current price + Put Purchase cost - Put sales cost at current price.
16	3/1/2017	Single	Sell	1	AAPL	AAPL190118P135	18 Jan 2019	-51	135	Put	16	1600		$1,600
17	3/1/2017	Single	Buy	1	AAPL	AAPL190118P140	18 Jan 2019	-51	140	Put	18.7	1870	$14,000	-$1,870
18	4/5/2017	Single	Sell	1	AAPL	AAPL190118P140	18 Jan 2019	-51	140	Put	15.8	1580		$1,580														Last adjustment date of AAPL covered stock position		4/5/2017 @ 9:29:20
19	4/5/2017	Single	Buy	1	AAPL	AAPL190118P145	18 Jan 2019	-51	145	Put	18.15	1815	$14,500	-$1,815
20																												Stock price at the open of 4/5/2017		105.27 per share
21													$14,500	-$14,550														Option price at the open of 4/5/2017		20.00 per share
22																												Option price at the open of 4/11/2017		142.90 per share
23
24																												Look up historical stock data for date range
25																												https://finance.yahoo.com/quote/AAPL/history?p=AAPL
26
27																												Look up applicable option codes and option data
28																												https://finance.yahoo.com/quote/AAPL/options?p=AAPL
29																												Ex. Option codes and Breakdown
30																												AAPL190118P00145000	Expires Jan 18, 2019 As shown by Yahoo Finance
31																												AAPL190118P145	Expires Jan 18, 2019 As shown in trading platform
32																												Underlying: AAPL Expiration year: 2019 Expiration day: Jan 18 Put or Call: Put Strike Price: 145	< Breakdown
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