LLY -- Position rolled out

The old call was bought back last week, but the new limit order didn't trigger until today:

Date	Description	Amount	ROI	aROI	Profit
2017-08-07	Buy LLY @ $81.85	-$81.85
2017-08-07	Sell LLY 8/11 2017 $82.00 Call @ $0.37	$0.37
2017-08-11	Div LLY @ $0.52	$0.52
2017-08-11	Buy LLY 8/11 2017 $82.00 Call @ $0.01	-$0.01
2017-08-14	Sell LLY 8/25 2017 $82.00 Call @ $0.59	$0.59
2017-08-25	If assigned at expiration	$82.00	1.98%	40.13%	$1.62
2017-08-14	Current value	$81.52	1.39%	72.62%	$1.14
2017-08-14	Buy and Hold	$81.52	0.23%	--	$0.19

 

WMT -- Call rolled out

The existing call was rolled out to next week:

Date	Description	Amount	ROI	aROI	Profit
2017-06-19	Buy WMT @ $75.35	-$75.35
2017-06-19	Sell WMT 6/23 2017 $75.50 Call @ $0.58	$0.58
2017-06-23	Buy WMT 6/23 2017 $75.50 Call @ $0.01	-$0.01
2017-06-23	Sell WMT 6/30 2017 $75.50 Call @ $0.35	$0.35
2017-06-30	If assigned at expiration	$75.50	1.42%	47.12%	$1.07
2017-06-23	Current value	$74.80	0.49%	44.81%	$0.37
2017-06-23	Buy and Hold	$74.80	-0.73%	--	-$0.55

 

Transaction and Analysis Ledger -- Update

---

To the left is what my current ledger page looks like for a given ETF or stock. The yellow-shaded cells are input cells. Everything else uses my SMF add-in to grab the necessary data from the Internet:

SMF Add-in Yahoo Group

C1:D1 allow me to display a chart (see below).

Q1 allows me to toggle update of all data, just by changing the drop-down box values (1 thru 8).

E16 allows me to enter an outstanding buyback price I have on the call, so that it will show up in my summary sheet.

Rows 17 thru 20 allow me to see the ledger entry changes in aXIRR and aROI if I roll the current position to the call ticker symbol entered in cell Q20. I also use these rows to paste my new transactions into the "real" portion of the ledger.

Q24:Q54 allow me to enter the a series of call ticker symbols to see what the premiums are for each and the relative effect of rolling to that call. A variation of rows 22 thru 54 can be found in the files area of the JustCoveredCalls group, although the "Alert" and "aRIU" calculations are different. In this case, the gray-shaded cells highlight my current call and the green-shaded cells highlight the call of highest aROI, Payback, and Premium (typically the same call).

---

To the left is what I would see if I were to use the drop-down boxes in cells C1 and D1 to request a Yahoo chart. I can only ask for the particular stock that the ledger page is for, but the timeframe can be easily varied.

---

Transaction and Analysis Ledger

Here is a picture of what my current ledger looks like for an individual equity.

The top section is a list of actual transactions, plus a theoretical closing transaction that is calculated as the minimum of the current price and the strike price of the current outstanding call.

The second section is a little analysis section to tell me how aXIRR an aROI will change if I roll the existing call. I just need to enter the new option ticker symbol and it does the calculations.