← Back to Templates

Long Put Option Strategy

Description

Long Put Option Strategy thumbnail

A single long put is priced here, the contract that carries the right to sell the underlying at the strike until expiration. Gains build as the shares fall below the breakeven at strike less premium, and risk is capped at the premium paid.

Enter ticker, expiration and strike and the workbook constructs the option symbol, then pulls bid, ask and previous close on demand together with the stock's last price. The payoff table and breakeven follow the current quotes, which makes it usable both for outright bearish trades and for pricing downside insurance on a holding you already own.

Template Screenshots

Long Put Option Strategy screenshot 1

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
How does MarketXLS work?
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found