← Back to Templates


Long Call Option Strategy
Description

The simplest bullish option position gets its own sheet: buy one call, risk the premium, gain above the breakeven at strike plus premium. Entering ticker, expiration and strike builds the option symbol and pulls bid, ask and previous close on demand next to the underlying's last price.
Loss is limited to what was paid. What the layout is good for is comparing several strikes and expirations at once, since the same block can be copied down and each row will price its own contract from the current chain.
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