Options Trading

Collar option strategy payoff diagram showing protective put and covered call in Excel with MarketXLS

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.

4/28/2021 • Shubham Shah
Vertical options spread payoff diagram showing bull call and bear put strategies analyzed in Excel with MarketXLS

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.

4/28/2021 • Anagh
How To Profit From Arbitrage Stocks And Options? - options strategy analysis and payoff diagram in Excel with MarketXLS

Arbitrage profits from a price gap for the same asset or equivalent positions. Stock arbitrage across exchanges, put-call parity for options, and the risks.

4/23/2021 • Shubham Shah
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.

4/17/2021 • Shubham Shah
Trading In Bull Put Spread Options Strategy (Using - options strategy analysis and payoff diagram in Excel with MarketXLS

Bull put spread explained with a worked TSLA-style example: max profit, max loss, breakeven, and how to model the strategy in an Excel template.

3/22/2021 • Shubham Shah
Trading In Bear Call Spread Options Strategy (Usin - options strategy analysis and payoff diagram in Excel with MarketXLS

A bear call spread sells a lower-strike call and buys a higher-strike call for a net credit. Max profit, max loss, breakeven with a worked example and an Excel template.

3/15/2021 • Shubham Shah
Collar Option Strategy - A Synopsis - options strategy analysis and payoff diagram in Excel with MarketXLS

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

3/10/2021 • Shubham Shah
Christmas tree spread options strategy payoff diagram showing 1-3-2 structure with puts and calls in Excel

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.

3/6/2021 • Ankur
Option Trading With Ms Excel-Protective Puts Strat - options strategy analysis and payoff diagram in Excel with MarketXLS

A protective put is buying a put on stock you own to cap your downside. Maximum loss is the stock price minus the strike plus the premium; upside stays open.

3/5/2021 • Shubham Shah
Option Trading With Ms Excel-Long Butterfly Strate - options strategy analysis and payoff diagram in Excel with MarketXLS

A long call butterfly buys one low-strike call, sells two middle-strike calls, and buys one high-strike call. Max loss is the debit; max profit comes at the middle strike.

3/5/2021 • Shubham Shah
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.

3/3/2021 • Shubham Shah
Options trading income tracker in Excel showing premium collection and P&L analysis with MarketXLS

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.

2/26/2021 • Shubham Shah
Trade Options on Robinhood - step-by-step options strategy analysis and payoff diagram in Excel with MarketXLS

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.

2/19/2021 • Shubham Shah
Options theta decay curve showing time value erosion approaching expiration in Excel

Options theta measures the daily time decay of an option's price. How theta works by moneyness, expiration, and volatility, plus MarketXLS formulas for Greeks analysis in Excel.

2/18/2021 • Shubham Shah
Long Call Options Trade/Strategy-How To Manage And - options strategy analysis and payoff diagram in Excel with MarketXLS

What are Long Call Options?A long call is buying a call option because you expect the underlying stock to rise above the strike price plus the premium before expiration.

2/16/2021 • Shubham Shah
Spy-Spdr S&P 500 Trust Etf(Most Actively Traded Op - options strategy analysis and payoff diagram in Excel with MarketXLS

SPY, the SPDR S&P 500 ETF Trust, launched in 1993 as the first US-listed ETF and tracks the S&P 500. How it works and why SPY options are so heavily traded (data as of Feb 2021).

2/13/2021 • Shubham Shah