← Back to Templates

Ratio Spread

Description

Ratio Spread thumbnail

A ratio spread buys one option and sells more than one at a further strike in the same expiration, commonly one long against two short, which leaves the position net short options. The extra short contract funds the trade and widens the zone where it profits, but it also creates exposure beyond the short strike that the long leg does not cover, and on the call side that exposure has no upper bound.

Every leg prices from an option symbol built out of your inputs, with bid, ask and previous close pulled on demand next to the underlying's last price.

Template Screenshots

Ratio Spread screenshot 1

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?
▶
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found