Collar Option Strategy

A collar holds shares, buys a protective put below the market and sells a call above it, with the call premium paying for some or all of the put. Downside is floored at the put strike and upside is capped at the call strike, so the workbook's job is showing where those two lines fall and what the net premium costs.

Put and call legs price from option symbols built out of your strikes and expiration, using on demand bid, ask and previous close next to the stock's last price.