MarketXLS Blog

A married put is a name given to an options trading strategy where an investor, holding a long position in a stock, purchases an at-the-money put option on the same stock to protect against...

A guts strategy involves buying or selling an in-the-money call option along with an in-the-money put option at the same time. There are two types of guts strategy: short guts and long guts. !

Collar option strategy combines a protective put with a covered call to hedge your stock position — often at zero net cost. Learn setup, P&L analysis, and Excel tracking.

Vertical options spread strategies let you define your risk and reward before entering any trade. Learn bull call, bear put, and credit spreads with real Excel examples using MarketXLS.

What is Arbitrage? Profit from Arbitrage means purchasing an asset in one market at a lower price and simultaneously selling the same in another market at a high price.

Neophyte and even experienced investors are often wary of options trading. Many people view options as risky, exotic, and only for investors with large bankrolls.

The options trader uses the bull put spread options strategy when having moderately bullish expectations on the market or stock.

The options trader uses the bear call spread options strategy when having moderately bearish expectations on the market or stock.

Collar option strategy showing stock plus put plus call equals zero-cost hedging with payoff diagram

Christmas tree spread is a multi-strike options strategy using a 1-3-2 structure for limited-risk directional bets. Learn the setup with calls and puts, P&L analysis, Greeks impact, and how to model it in Excel with MarketXLS.

Protective puts As the name itself suggests, the Protective Put strategy is used by investors to protect their capital gains from a decline in the stock price.

Long butterfly with calls The long butterfly call spread is created by buying one in-the-money call option with a low strike price, writing two at-the-money call options, and buying one...

A Short Strangle Option Strategy involves selling both OTM call and OTM put options in the same underlying asset with the same expiry date but with different strike prices.

Options trading income requires careful tracking of premiums collected, assignment events, and net P&L. Learn how to build a complete income tracker in Excel with real formulas.

Trade Options on Robinhood with this complete beginner's guide covering approval levels, order types, strategies, Greeks, and how MarketXLS enhances your options analysis in Excel.

Options theta measures the daily time decay of an option's price. Learn how theta works by moneyness, expiration, and volatility — plus MarketXLS formulas for real-time Greeks analysis.