SPY -- Adjustment

The SPY position was rolled up and out:

Price	Date	Description	Total	aXIRR	aROI
$102.81	2009-08-21	Buyback 10 SPY Aug 2009 $101 @ $1.74	-$1,759.95	12.6%	12.0%
$102.81	2009-08-21	Sell 10 SPY Sep 2009 $103 @ $2.19	$2,170.05	16.9%	16.0%

 

NFLX -- Adjustment

The NFLX position was rolled down and out:

Price	Date	Description	Total	aXIRR	aROI
$44.81	2009-08-14	Buyback 20 NFLX Aug 2009 $47.50 @ $0.25	-$529.95	6.0%	5.3%
$45.27	2009-08-21	Sell 20 NFLX Sep 2009 $45 @ $2.15	$4,270.05	16.9%	14.4%

 

IWM -- Adjustment

The IWM position was rolled up and out:

Price	Date	Description	Total	aXIRR	aROI
$56.66	2009-08-20	Buyback 20 IWM Aug 2009 $56 @ $0.89	-$1,809.95	37.5%	31.9%
$56.66	2009-08-20	Sell 20 IWM Sep 2009 $57 @ $1.64	$3,250.05	37.6%	32.6%

 

EEM -- Adjustment

The EEM position was rolled up and out:

Price	Date	Description	Total	aXIRR	aROI
$35.65	2009-08-14	Buyback 20 EEM Aug 2009 $33 @ $2.72	-$5,469.95	48.6%	40.6%
$35.66	2009-08-20	Sell 20 EEM Sep 2009 $36 @ $1.155	$2,280.05	48.4%	41.8%

 

MMM -- Adjustment

The MMM position was rolled out:

Price	Date	Description	Total	aXIRR	aROI
$70.98	2009-08-20	Buyback 10 MMM Aug 2009 $70 @ $1.15	-$1,169.95	29.4%	54.9%
$71.06	2009-08-20	Sell 10 MMM Sep 2009 $70 @ $2.60	$2,580.05	29.5%	56.5%

 

SPY -- Adjustment

The SPY position was rolled up:

Price	Date	Description	Total	aXIRR	aROI
$100.43	2009-08-04	Buyback 10 SPY Aug 2009 $91 @ $9.75	-$9,769.95	9.0%	8.6%
$100.43	2009-08-04	Sell 10 SPY Aug 2009 $101 @ $1.74	$1,720.05	11.5%	10.9%

 

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.

---