← Back to Templates


Long Put Option Strategy
Description

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

Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found