MarketXLS Blog

Market data, investing ideas, and practical Excel guides.

Browse series
Options Trading for Passive Income - options strategy analysis and payoff diagram in Excel with MarketXLS

Covered calls and cash-secured puts collect option premium as income. How each works, where the risk sits, and why option income is not risk-free or fully passive.

Options Trading
Options Profit Calculator - options strategy analysis and payoff diagram in Excel with MarketXLS

An options profit calculator shows the profit or loss of a call, put, or multi-leg strategy at expiry and before it. How the math works and the MarketXLS Excel template.

Options Trading
Stock Repair Option Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS

The stock repair strategy buys one at-the-money call and sells two higher-strike calls against a losing stock position to lower the breakeven at little or no extra cost.

Options Trading
Stock Replacement Options Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS

The stock replacement options strategy means buying a deep in-the-money call (delta close to 1) instead of buying 100 shares.

Options Trading
Put Ratio Spread - options strategy analysis and payoff diagram in Excel with MarketXLS

A put ratio spread buys one higher-strike put and sells two lower-strike puts. Max profit at the lower strike; large downside risk below the breakeven.

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

A short guts sells an in-the-money call and an in-the-money put with the same expiry. Setup, maximum profit, unlimited risk, breakevens, and when it is used.

Options Trading
Long Guts Options Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS

The long guts options strategy buys an in-the-money call and an in-the-money put on the same stock and expiration to profit from a large move either way.

Options Trading
Bull Put Options Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS

Bull put spread strategy showing credit spread for bullish market with payoff diagram

Options Trading
Bull Call Spread Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS

Bull call spread strategy showing buy lower strike call, sell higher strike call with payoff diagram

Options Trading
Married Put Options Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS

A married put buys a put on a stock you own. Max loss is capped at stock price minus strike plus the premium; upside stays open, less the put cost.

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

Short guts sells an in-the-money call and put for a credit and profits if the stock stays in range; long guts buys both and profits from a large move. Break-evens and risks.

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.