← 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

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? Watch Demo
Similar Templates
No similar templates found