← Back to Templates


Ratio Spread
Description

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

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