Collar Option Strategy
Covered Call and Protective Put strategy is combined to form Collar strategy. This strategy limits both gains and losses. It is created by holding an underlying stock, long OTM put option, and short OTM call option. The protective put protects from the downside and selling calls will be used to pay for the protective put.
The payoff from Collar strategy = Stock Payoff + Put Payoff + Call Payoff

Created by: MarketXLS
Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Call: 1-877-778-8358
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.
Get started today
Get started today