SI
SI
discoversearch

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!

 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Herman J. Matos who wrote (215)2/24/1997 8:42:00 PM
From: Herman J. Matos   of 14162
 
.........HOW TO WRITE COVERED CALLS - A REAL CASE STUDY!
==================================================================
............................Date: Monday, Feb. 24, 1997

EXCEL TEMPLATE UPDATE: A special thanks to Russell Lowrey for pointing out a minor error in my Excel template. I originally had the template in MS Works for Windows-95 and I had to transfer over to my new MS Office-97.

Anyway here is the correction. Please check cell D26. It should read
"C26/C24" instead of "C26/C23" . This cell provides the rate of return if you are called out from your position. The correction will actually give you a higher rate of return since it is pegged to the stock net cost basis (not to the value of the total strike price)

Otherwise, the template is very handy to do your calculations without raking your brains. Also, I sometimes plug in the daily price changes to see how my positions are doing.

I have another template that I developed and use for determing the best value when buying calls with a variety of strike prices and months. I will have to take the time to transfer it over to the Excel format.
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext