Are you subtracting commission costs from your 'Total' column numbers?
At first glance, it looks like your 'Sell at end of period' dollars are if the stock price is unchanged (as opposed to if exercised). Is that correct?
Excellent portfolio diversification with you ETFs, although if you prefer you could probably go with either SPY or DIA as your sole U.S. large-cap exposure.
Jeff -- Commissions are included in all actual transactions, but not the "Sell at end of period" since it is a theoretical amount. However, my first 100 stock trades each year are free at Wells Fargo (but not option trades).
The "Sell at end of period" price is the minimum of the current price and the strike price the call is written at. So, it will change in my workbook if the current price rises but is still under the strike price of the covered call.
My current worksheet for each equity now contains an analysis portion for rolling as well, but I do have to enter an option ticker symbol. But I can then see how the rolling will affect aROI and aXIRR.
I already had SPY, but added DIA and EEM this morning. I'm thinking I will stay more with ETFs in the start -- the liquidity and call volumes are better. I don't need more things working against me at this point. :)
Randy,
ReplyDeleteAre you subtracting commission costs from your 'Total' column numbers?
At first glance, it looks like your 'Sell at end of period' dollars are if the stock price is unchanged (as opposed to if exercised). Is that correct?
Excellent portfolio diversification with you ETFs, although if you prefer you could probably go with either SPY or DIA as your sole U.S. large-cap exposure.
Jeff
Jeff -- Commissions are included in all actual transactions, but not the "Sell at end of period" since it is a theoretical amount. However, my first 100 stock trades each year are free at Wells Fargo (but not option trades).
ReplyDeleteThe "Sell at end of period" price is the minimum of the current price and the strike price the call is written at. So, it will change in my workbook if the current price rises but is still under the strike price of the covered call.
My current worksheet for each equity now contains an analysis portion for rolling as well, but I do have to enter an option ticker symbol. But I can then see how the rolling will affect aROI and aXIRR.
I already had SPY, but added DIA and EEM this morning. I'm thinking I will stay more with ETFs in the start -- the liquidity and call volumes are better. I don't need more things working against me at this point. :)