I also should mention that I created a simple spreadsheet to help me track and analyze covered calls. I feed it the stock price, strike price and it calculates the commission for me, the return if called, return if not called, annualized returns, new cost basis of the stock, and downside protection (what percentage drop in the stock will allow me to still be above water).
I'd be glad to share this with anyone that wants it, and would like to know if anyone has any other ideas for additions to such a spreadsheet to make it more useful.
I use Quattro Pro, but I'm sure this can be imported into any other current spreadsheet as well. Just send your email address to me, if you'd like a copy, or alternatively, I can provide the formulas used to derive the above data.
Jeff |
