MarketXLS Blog

Market data, investing ideas, and practical Excel guides.

Browse series
Short Call Put- Managing And Tracking - options strategy analysis and payoff diagram in Excel with MarketXLS

A short call or short put means selling an option to collect premium. How each works, and a worked MSFT bear call spread with max profit, max loss, and breakeven.

Options Trading
Long Put Option Strategy-Managing And Tracking - options strategy analysis and payoff diagram in Excel with MarketXLS

What is a long put option strategy? A long put is a bearish trade where you buy one put option and profit if the stock falls below the strike price minus the premium you paid.

Options Trading
Delta Neutral - options strategy analysis and payoff diagram in Excel with MarketXLS

Delta neutral strategy showing portfolio balancing for volatility-focused trading with payoff diagrams

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.