PFE – 12/31/2015 – Sell CSP. Feb 3 Ex Div; Adequate return(35% ARoI) with 37 days to exp. Exceeds PT (3%) if expires.
Does the chart below make any sense to you ? (hint it is showing profit picture of all my open positions-in age across the chart–older positions to the left; newer to the right). You KNOW I like to play with excel charts, cramming lots onto a single chart. It helps my OR brain to tease out obscure relationships.:
Trade Date |
Trade Time |
Und. Ticker |
Buy/ Sell |
Con tracts |
Expiry Date |
Put or Call |
Price |
Status/Notes |
STK Price |
Position |
Strike |
Gross Cash Flow |
Comm |
Net Cash Flow |
12/1/2015 |
7:26:14 AM |
MRK |
SELL |
1 |
12/11/2015 |
CALL |
$0.30 |
CC Open After Early Close |
53.73 |
1 CALL MRK 151211C00054500 |
54.50 |
$30.00 |
$0.79 |
$29.21 |
12/2/2015 |
8:14:03 AM |
KO |
BUY |
1 |
12/18/2015 |
CALL |
$0.08 |
CC Close Early BB .08 |
42.74 |
1 CALL KO 151218C00044000 |
44.00 |
($8.00) |
$0.79 |
($8.79) |
12/2/2015 |
9:35:46 AM |
LVS |
SELL |
1 |
2/19/2016 |
CALL |
$2.83 |
CC Open Roll 2 Delayed OUT and UP |
45.56 |
1 CALL LVS 160219C00045000 |
45.00 |
$283.00 |
$0.80 |
$282.20 |
12/2/2015 |
9:56:39 AM |
NUS |
SELL |
1 |
12/4/2015 |
CALL |
$0.30 |
CC Open Roll 2 Delayed Right before big move up |
35.55 |
1 CALL NUS 151204C00037000 |
37.00 |
$30.00 |
$1.09 |
$28.91 |
12/2/2015 |
12:42:09 PM |
WMT |
SELL |
1 |
3/18/2016 |
PUT |
$2.08 |
CSP Open Buy Day Expire Meets TP 100 days |
58.45 |
1 PUT WMT 160318P00057500 |
57.50 |
$208.00 |
$0.80 |
$207.20 |
12/3/2015 |
9:13:26 AM |
XOM |
SELL |
1 |
12/18/2015 |
PUT |
$1.35 |
CSP Open Buy Day Recover Unfav Assign |
78.65 |
1 PUT XOM 151218P00077500 |
77.50 |
$135.00 |
$1.10 |
$133.90 |
12/3/2015 |
10:57:27 AM |
EMR |
SELL |
1 |
1/15/2016 |
PUT |
$0.95 |
CSP Open Buy Day Recover Unfav Assign |
48.34 |
1 PUT EMR 160115P00047000 |
47.00 |
$95.00 |
$1.10 |
$93.90 |
12/4/2015 |
8:32:52 AM |
COP |
BUY |
1 |
12/24/2015 |
CALL |
$0.20 |
CC Close BB Early .20 |
50.75 |
1 CALL COP 151224C00056000 |
56.00 |
($20.00) |
$1.09 |
($21.09) |
12/4/2015 |
12:20:45 PM |
MS |
BUY |
1 |
1/15/2016 |
PUT |
$0.63 |
CSP Close BB Early 60% in 34% of time |
35.34 |
1 PUT MS 160115P00034000 |
34.00 |
($63.00) |
$1.09 |
($64.09) |
12/4/2015 |
10:54:28 PM |
NUS |
SELL |
1 |
12/4/2015 |
CALL |
$0.00 |
CC Close Expired |
33.99 |
1 CALL NUS 151204C00037000 |
37.00 |
$0.00 |
|
$0.00 |
12/4/2015 |
10:54:28 PM |
STX |
SELL |
1 |
12/4/2015 |
CALL |
$0.00 |
CC Close Expired |
34.19 |
1 CALL STX 151204C00035500 |
35.50 |
$0.00 |
|
$0.00 |
12/7/2015 |
7:34:30 AM |
WMB |
BUY |
109 |
|
STK |
$27.55 |
STK Open Div Capture Dec 9 15 |
27.55 |
109 STK WMB |
|
($3,002.95) |
$1.00 |
($3,003.95) |
12/7/2015 |
10:45:54 AM |
STX |
SELL |
1 |
1/22/2016 |
CALL |
$1.22 |
CC Open Interim |
34.95 |
1 CALL STX 160122C00036500 |
36.50 |
$122.00 |
$0.80 |
$121.20 |
12/7/2015 |
10:52:03 AM |
MRK |
BUY |
1 |
12/11/2015 |
CALL |
$0.06 |
CC Close Early .06 |
53.36 |
1 CALL MRK 151211C00054500 |
54.50 |
($6.00) |
$1.09 |
($7.09) |
12/7/2015 |
11:32:09 AM |
ETN |
BUY |
1 |
12/24/2015 |
CALL |
$1.62 |
CC Close Early 1.62 |
54.87 |
1 CALL ETN 151224C00054000 |
54.00 |
($162.00) |
$1.09 |
($163.09) |
12/7/2015 |
12:19:54 PM |
ADM |
SELL |
1 |
3/18/2016 |
PUT |
$1.80 |
CSP Open Buy Day |
35.38 |
1 PUT ADM 160318P00035000 |
35.00 |
$180.00 |
$0.73 |
$179.27 |
12/7/2015 |
12:48:11 PM |
WMT |
BUY |
1 |
3/18/2016 |
PUT |
$1.37 |
CSP Close Early big ratio 34% AROI 6%time |
60.51 |
1 PUT WMT 160318P00057500 |
57.50 |
($137.00) |
$1.09 |
($138.09) |
12/8/2015 |
8:00:49 AM |
RCI |
BUY |
1 |
12/18/2015 |
CALL |
$1.70 |
CC Close Early Avoid Assignment |
36.65 |
1 CALL RCI 151218C00035000 |
35.00 |
($170.00) |
$0.34 |
($170.34) |
12/8/2015 |
9:24:49 AM |
NUS |
SELL |
1 |
12/18/2015 |
CALL |
$0.50 |
CC Open Interim |
36.35 |
1 CALL NUS 151218C00038000 |
38.00 |
$50.00 |
$0.34 |
$49.66 |
12/9/2015 |
12:43:37 PM |
WMB |
SELL |
109 |
|
STK |
$29.14 |
STK Close Div Captured and PT Met |
20.14 |
109 STK WMB |
|
$3,176.26 |
$1.06 |
$3,175.20 |
12/10/2015 |
9:48:27 AM |
COP |
SELL |
1 |
12/24/2015 |
CALL |
$0.66 |
CC Open Interim |
49.55 |
1 CALL COP 151224C00051500 |
51.50 |
$66.00 |
$1.09 |
$64.91 |
12/11/2015 |
8:31:36 AM |
MET |
SELL |
1 |
1/29/2016 |
PUT |
$1.62 |
CSP Open Buy Day Not quite PT |
47.62 |
1 PUT MET 160129P00047000 |
47.00 |
$162.00 |
$0.80 |
$161.20 |
12/11/2015 |
8:56:13 AM |
LVS |
BUY |
1 |
2/19/2016 |
CALL |
$1.52 |
CC Close BB Early 1.52 3.6 Ratio |
41.80 |
1 CALL LVS 160219C00045000 |
45.00 |
($152.00) |
$0.79 |
($152.79) |
12/11/2015 |
10:06:53 AM |
IP |
BUY |
1 |
1/15/2016 |
CALL |
$0.68 |
CC Close BB Early .68 1.4 Ratio |
38.30 |
1 CALL IP 160115C00040000 |
40.00 |
($68.00) |
$1.09 |
($69.09) |
12/14/2015 |
9:42:32 AM |
SE |
SELL |
1 |
1/15/2016 |
CALL |
$0.70 |
CC Open Interim |
22.99 |
1 CALL SE 160115C00024000 |
24.00 |
$70.00 |
$0.34 |
$69.66 |
12/14/2015 |
10:37:32 AM |
GPS |
BUY |
1 |
12/18/2015 |
CALL |
$0.11 |
CC Close BB Early .11 .87 Ratio 80% Recov |
25.77 |
1 CALL GPS 151218C00027000 |
27.00 |
($11.00) |
$0.79 |
($11.79) |
12/15/2015 |
7:01:23 AM |
ESV |
SELL |
1 |
12/18/2015 |
CALL |
$0.15 |
CC Open |
16.15 |
1 CALL ESV 151218C00017000 |
17.00 |
$15.00 |
$0.24 |
$14.76 |
12/15/2015 |
7:17:39 AM |
KO |
SELL |
1 |
12/18/2015 |
CALL |
$0.17 |
CC Open |
43.06 |
1 CALL KO 151218C00043500 |
43.50 |
$17.00 |
$1.09 |
$15.91 |
12/15/2015 |
7:50:56 AM |
HPQ |
SELL |
1 |
12/18/2015 |
CALL |
$0.16 |
CC Open |
12.40 |
1 CALL HPQ 151218C00012500 |
12.50 |
$16.00 |
$1.59 |
$14.41 |
12/14/2015 |
11:00:46 AM |
BBY |
SELL |
1 |
3/18/2016 |
PUT |
$1.74 |
CSP Open |
14.71 |
1 PUT BBY 160318P00028000 |
28.00 |
$174.00 |
$0.80 |
$173.20 |
12/16/2015 |
7:20:10 AM |
GPS |
SELL |
1 |
1/8/2016 |
CALL |
$0.52 |
CC Open |
26.17 |
1 CALL GPS 160108C00027000 |
27.00 |
$52.00 |
$0.79 |
$51.21 |
12/16/2015 |
7:04:47 AM |
ETN |
SELL |
1 |
1/22/2016 |
CALL |
$1.80 |
CC Open |
51.71 |
1 CALL ETN 160122C00051500 |
51.50 |
$180.00 |
$1.10 |
$178.90 |
12/15/2015 |
11:27:58 AM |
MRK |
SELL |
1 |
12/18/2015 |
CALL |
$0.23 |
CC Open |
53.11 |
1 CALL MRK 151218C00054000 |
54.00 |
$23.00 |
$0.79 |
$22.21 |
12/17/2015 |
11:13:35 AM |
GPS |
BUY |
1 |
1/8/2016 |
CALL |
$0.25 |
CC Close BB Early .25 |
25.38 |
1 CALL GPS 160108C00027000 |
27.00 |
($25.00) |
$0.79 |
($25.79) |
12/17/2015 |
11:18:07 AM |
VZ |
BUY |
1 |
12/18/2015 |
CALL |
$1.47 |
CC Close Roll 1 |
46.42 |
1 CALL VZ 151218C00045000 |
45.00 |
($147.00) |
$0.79 |
($147.79) |
12/17/2015 |
11:19:10 AM |
MAT |
BUY |
1 |
12/18/2015 |
CALL |
$5.10 |
CC Close Roll 1 |
27.07 |
1 CALL MAT 151218C00022000 |
22.00 |
($510.00) |
$0.34 |
($510.34) |
12/17/2015 |
11:21:24 AM |
VZ |
SELL |
1 |
12/31/2015 |
CALL |
$1.60 |
CC Open Roll 2 |
46.48 |
1 CALL VZ 151231C00045000 |
45.00 |
$160.00 |
$0.80 |
$159.20 |
12/17/2015 |
12:54:26 PM |
HPQ |
BUY |
1 |
12/18/2015 |
CALL |
$0.01 |
CC Close BB Early .01 |
11.95 |
1 CALL HPQ 151218C00012500 |
12.50 |
($1.00) |
|
($1.00) |
12/18/2015 |
7:31:45 AM |
GME |
SELL |
1 |
1/15/2016 |
PUT |
$1.85 |
CSP Open Buy Day |
28.30 |
1 PUT GME 160115P00028000 |
28.00 |
$185.00 |
$1.10 |
$183.90 |
12/18/2015 |
7:02:55 AM |
COP |
BUY |
1 |
12/24/2015 |
CALL |
$0.23 |
CC Close Early BB .23 |
47.00 |
1 CALL COP 151224C00051500 |
51.50 |
($23.00) |
$0.79 |
($23.79) |
12/18/2015 |
11:03:43 AM |
ETN |
BUY |
1 |
1/22/2016 |
CALL |
$0.95 |
CC Close Early BB .95 |
49.92 |
1 CALL ETN 160122C00051500 |
51.50 |
($95.00) |
$0.34 |
($95.34) |
12/18/2015 |
11:19:46 AM |
NUS |
BUY |
1 |
12/18/2015 |
CALL |
$0.05 |
CC Close Roll 1 .05 |
37.62 |
1 CALL NUS 151218C00038000 |
38.00 |
($5.00) |
$1.09 |
($6.09) |
12/18/2015 |
12:36:28 PM |
XOM |
SELL |
1 |
1/8/2016 |
PUT |
$1.55 |
CSP Close Roll 1 |
37.43 |
1 PUT XOM 160108P00077000 |
77.00 |
$155.00 |
$1.10 |
$153.90 |
12/18/2015 |
12:36:27 PM |
XOM |
BUY |
1 |
12/18/2015 |
PUT |
$0.05 |
CSP Open Roll 2 Vis Roll Tool |
37.43 |
1 PUT XOM 151218P00077500 |
77.50 |
($5.00) |
$1.09 |
($6.09) |
12/18/2015 |
12:58:50 PM |
SE |
BUY |
1 |
1/15/2016 |
CALL |
$0.30 |
CC Close BB Early 4.7 Ratio |
21.97 |
1 CALL SE 160115C00024000 |
24.00 |
($30.00) |
$0.34 |
($30.34) |
12/20/2015 |
12:58:50 PM |
ESV |
BUY |
1 |
12/18/2015 |
CALL |
$0.00 |
CC Close Expired |
14.31 |
1 CALL ESV 151218C00017000 |
17.00 |
$0.00 |
|
$0.00 |
12/20/2015 |
12:58:50 PM |
KO |
BUY |
1 |
12/18/2015 |
CALL |
$0.00 |
CC Close Expired |
42.58 |
1 CALL KO 151218C00043500 |
43.50 |
$0.00 |
|
$0.00 |
12/20/2015 |
12:58:50 PM |
MRK |
BUY |
1 |
12/18/2015 |
CALL |
$0.00 |
CC Close Expired |
51.56 |
1 CALL MRK 151218C00054000 |
54.00 |
$0.00 |
|
$0.00 |
12/21/2015 |
8:07:09 AM |
IP |
SELL |
1 |
1/22/2016 |
CALL |
$1.00 |
CC Open Roll 2 from early BB |
37.58 |
1 CALL IP 160122C00038000 |
38.00 |
$100.00 |
$0.80 |
$99.20 |
12/21/2015 |
8:05:30 AM |
NUS |
SELL |
1 |
1/15/2016 |
CALL |
$0.95 |
CC Open Roll 2 |
38.30 |
1 CALL NUS 160115C00041000 |
41.00 |
$95.00 |
$1.10 |
$93.90 |
12/21/2015 |
7:59:35 AM |
ETN |
SELL |
1 |
1/8/2016 |
CALL |
$1.05 |
CC Open Roll 2 from early BB |
50.84 |
1 CALL ETN 160108C00051000 |
51.00 |
$105.00 |
$1.10 |
$103.90 |
12/21/2015 |
10:20:52 AM |
LVS |
SELL |
1 |
1/29/2016 |
CALL |
$1.65 |
CC Open Roll 2 Ffrom Early BB |
42.42 |
1 CALL LVS 160129C00043500 |
43.50 |
$165.00 |
$0.80 |
$164.20 |
12/21/2015 |
10:56:39 AM |
SE |
SELL |
1 |
1/15/2016 |
CALL |
$0.60 |
CC Open Roll 2 from early BB |
22.30 |
1 CALL SE 160115C00023000 |
23.00 |
$60.00 |
$0.64 |
$59.36 |
12/21/2015 |
12:07:06 PM |
VZ |
BUY |
1 |
12/31/2015 |
CALL |
$0.98 |
CC Close Early .98 |
45.71 |
1 CALL VZ 151231C00045000 |
45.00 |
($98.00) |
$0.79 |
($98.79) |
12/22/2015 |
7:28:10 AM |
ESV |
SELL |
1 |
1/15/2016 |
CALL |
$0.80 |
CC Open |
14.85 |
1 CALL ESV 160115C00015000 |
15.00 |
$80.00 |
$1.10 |
$78.90 |
12/22/2015 |
9:58:55 AM |
GPS |
SELL |
1 |
1/8/2016 |
CALL |
$0.38 |
CC Open |
25.32 |
1 CALL GPS 160108C00026000 |
26.00 |
$38.00 |
$1.09 |
$36.91 |
12/23/2015 |
8:25:41 AM |
MRK |
SELL |
1 |
1/8/2016 |
CALL |
$0.48 |
CC Open |
52.92 |
1 CALL MRK 160108C00053500 |
53.50 |
$48.00 |
$0.79 |
$47.21 |
12/23/2015 |
7:59:14 AM |
ADM |
BUY |
1 |
3/18/2016 |
PUT |
$1.14 |
CSP Close Early BB 2.3 M 38% Rec 16% elapsed |
37.11 |
1 PUT ADM 160318P00035000 |
35.00 |
($114.00) |
$0.79 |
($114.79) |
12/23/2015 |
9:02:54 AM |
COP |
SELL |
1 |
1/29/2016 |
CALL |
$1.25 |
CC Open Roll 2 on early BB |
48.60 |
1 CALL COP 160129C00051000 |
51.00 |
$125.00 |
$1.10 |
$123.90 |
12/23/2015 |
9:37:28 AM |
MAT |
SELL |
1 |
2/19/2016 |
CALL |
$5.80 |
CC Open Roll 2 |
27.55 |
1 CALL MAT 160219C00022000 |
22.00 |
$580.00 |
$0.35 |
$579.65 |
12/23/2015 |
9:10:22 AM |
RCI |
SELL |
1 |
2/19/2016 |
CALL |
$1.40 |
CC Open |
35.39 |
1 CALL RCI 160219C00035000 |
35.00 |
$140.00 |
$1.10 |
$138.90 |
12/23/2015 |
9:37:28 AM |
MAT |
SELL |
1 |
2/19/2016 |
CALL |
$5.80 |
CC Open |
27.67 |
1 CALL MAT 160219C00022000 |
22.00 |
$580.00 |
$0.35 |
$579.65 |
12/23/2015 |
12:54:31 PM |
MET |
BUY |
1 |
1/29/2016 |
PUT |
$0.82 |
CSP Close Early |
48.22 |
1 PUT MET 160129P00047000 |
47.00 |
($82.00) |
$1.09 |
($83.09) |
12/23/2015 |
12:58:46 PM |
XOM |
BUY |
1 |
1/8/2016 |
PUT |
$0.45 |
CSP Close Early |
80.21 |
1 PUT XOM 160108P00077000 |
77.00 |
($45.00) |
$0.79 |
($45.79) |
12/28/2015 |
9:36:51 AM |
DE |
SELL |
1 |
3/18/2016 |
PUT |
$3.10 |
CSP Open |
77.41 |
1 PUT DE 160318P00075000 |
75.00 |
$310.00 |
$0.80 |
$309.20 |
12/29/2015 |
7:36:48 AM |
XOM |
SELL |
1 |
3/18/2016 |
PUT |
$3.01 |
CSP Open Recover from Assign |
79.21 |
1 PUT XOM 160318P00077500 |
77.50 |
$301.00 |
$1.10 |
$299.90 |
12/29/2015 |
12:08:21 PM |
VZ |
SELL |
1 |
1/8/2016 |
CALL |
$1.20 |
CC Open |
47.16 |
1 CALL VZ 160108C00046000 |
46.00 |
$120.00 |
$0.80 |
$119.20 |
12/29/2015 |
12:55:04 PM |
KO |
SELL |
1 |
1/15/2016 |
CALL |
$0.35 |
CC Open (Let it be assigned) |
43.68 |
1 CALL KO 160115C00044000 |
44.00 |
$35.00 |
$1.09 |
$33.91 |
12/30/2015 |
10:43:32 AM |
KO |
BUY |
1 |
1/15/2016 |
CALL |
$0.35 |
CC Close (Getting close to PT) |
43.72 |
1 CALL KO 160115C00044000 |
44.00 |
($35.00) |
$1.09 |
($36.09) |
12/30/2015 |
11:14:07 AM |
COP |
BUY |
1 |
1/29/2016 |
CALL |
$0.65 |
CC Close Early .65 |
46.85 |
1 CALL COP 160129C00051000 |
51.00 |
($65.00) |
$0.79 |
($65.79) |
12/31/2015 |
9:02:45 AM |
PFE |
SELL |
1 |
2/5/2016 |
PUT |
$1.20 |
CSP Open |
32.42 |
1 PUT PFE 160205P00033000 |
33.00 |
$120.00 |
$0.80 |
$119.20 |
12/31/2015 |
9:50:35 AM |
COP |
SELL |
1 |
1/15/2016 |
CALL |
$0.79 |
CC Open |
43.22 |
1 CALL COP 160115C00048500 |
48.50 |
$79.00 |
$1.10 |
$77.90 |
12/31/2015 |
12:11:33 PM |
VZ |
BUY |
1 |
1/8/2016 |
CALL |
$0.40 |
CC Close Early .40 60% & protect div |
46.20 |
1 CALL VZ 160108C00046000 |
46.00 |
($40.00) |
$1.09 |
($41.09) |