Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

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
Collar Option Strategy - MarketXLS

Created by: MarketXLS

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
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