Covered Call Calculator
Description: This is a dynamic covered call option calculator that allows you to enter basic information and see which options might be best to sell against a long (owned) stock or ETF position.
After entering the following info:
Then click “enter” on your keyboard and the many calculations show up:
You can see:
Note, all calculations are net of $1 per option commissions and $.01 per share in stock commissions
Disclaimer - the Spreadsheetshoppe.com does not take any responsibility for trades made using the information on this site. The information found here is being provided for educational / informational purposes only, any actions taken as a result of this information is strictly the responsibility of the user. Trading financial instruments of any kind, including but not limited to, options, futures, and stocks carry significant potential risk. No representation is made that by using the information on this site will or are likely to achieve profits or losses indicated.
This website, its owners, its associates and/or its representatives are not registered as securities broker-dealers or investment advisors with any state securities regulatory authority. We recommend consulting with a registered investment advisor, broker-dealer, and/or financial advisor. If you choose to invest with or without seeking advice from such an advisor or entity, then any consequences resulting from your investments are your sole responsibility.
Basically, use common sense and understand that the accuracy or validity of the information / calculations found on this site should not be construed as a recommendation to purchase or sell any type of security, or to provide investment advice.
Other Useful Tools & Excel Templates
Question or comments? Reach us Here
* Note, utilizing the features of this excel template requires Microsoft Excel® 2007 or later - this template/tool will work in 2003; however, the colors may be different than shown in the picture(s).