MarketXLS Blog

Market data, investing ideas, and practical Excel guides.

Browse series
Understand What a Strangle in Options Is - options strategy analysis and payoff diagram in Excel with MarketXLS

A long strangle buys an out-of-the-money call and put with the same expiry. It profits from a large move either way; the maximum loss is the premium paid.

Options Trading
Maximizing Returns with Covered Put Options - options strategy analysis and payoff diagram in Excel with MarketXLS

A covered put combines a short stock position with a short put. Maximum profit, the unlimited upside risk, when traders use it, and how it differs from a collar.

Options Trading
Maximizing Returns With a Call Debit Spread - options strategy analysis and payoff diagram in Excel with MarketXLS

A call debit spread buys a lower-strike call and sells a higher-strike call. Max loss is the debit, max profit is the strike width minus the debit, breakeven is lower strike plus debit.

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

An options profit calculator shows the profit or loss of an options trade across stock prices and dates. What to look for and how the MarketXLS calculator works.

Options Trading
How Are Options Priced? - options strategy analysis and payoff diagram in Excel with MarketXLS

An option premium equals intrinsic value plus extrinsic (time) value. Models like Black-Scholes price the extrinsic part from volatility, time, and rates.

Options Trading
Use of Options to Hedge Market Risk - options strategy analysis and payoff diagram in Excel with MarketXLS

Five ways to hedge a stock portfolio with options: long puts, collars, put spreads, fences and covered calls, with the cost and protection trade-off of each.

Options Trading
Option Strategies For Professional Traders - options strategy analysis and payoff diagram in Excel with MarketXLS

Five defined-risk option strategies traders use by market view: bull call spread, call ratio back spread, bear put spread, put ratio back spread, and iron condor.

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.