Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : How To Write Covered Calls - An Ongoing Real Case Study! -- Ignore unavailable to you. Want to Upgrade?

To: jaytee who wrote (12970)	6/27/2000 8:23:00 PM
From: Dan Duchardt	Read Replies (1) \| Respond to of 14162

jaytee, Someone on another tread posted a link to quote.com You can get time and sales history and lots of other data there. Check out the pull down menus "Chart" and "Go" from the top of the chart. You have to put up with the ads, but the data is worth it. My little spreadsheet is in Excel, but it's very crude. I'm not savvy enough to build an interface to import the data, so it's all entered by hand. If somebody knows how to build something that will go out and grab the data and create the appropriate sheet, I'd like to have it turned into such a tool. For Excel: With the long term strikes in columnB and premiums in C starting at row4, short term strikes in row 2 and premiums in 3 starting at columnD, near term expiry price in cell E1, and long term expiry price in A5, the following formula can be entered in cell D4 then filled right and down: =IF($E$1<=D$2,(IF($A$5>$B4,$A$5-$B4,0)-$C4+D$3),D$2+D$3-$B4-$C4)/($C4-D$3) You can adjust the expiry prices anyway you want to do what ifs. There is nothing to account for the potential extra premium if you get to write a second round of calls after the first expiration date. It's a simple create and hold till called out, or until the long call reaches expiration type calculation. Dan