MarketXLS Blog

Market data, investing ideas, and practical Excel guides.

Browse series
Options Trading (Strategies) - options strategy analysis and payoff diagram in Excel with MarketXLS

Eight common options trading strategies explained: covered put, collar, short strangle, bull put spread, bear call spread, calendar spreads, and long butterfly.

Options Trading
Short Strangle Option Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS

A short strangle sells an out-of-the-money call and put with the same expiry to collect premium when a stock stays in a range. Risk is unlimited.

Options Trading

Explore our 94 blog series

Browse articles by topic, arranged in reading order.

Browse the series directoryBrowse all article categories
Show all 94 series

The Professional Investment Platform Inside Excel

Live market data, stock screening, options analytics and portfolio management inside Excel.