Options Trading
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.
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.
Diagonal Spread options strategy explained — setup, Greeks impact, risk management, variations, and how to model diagonal spreads in Excel with MarketXLS formulas.
Options explained simply: how hedge funds use options to reduce risk, why the VIX matters, common volatility-based strategies, and Excel templates to track them.
Best options to buy research guide showing screening criteria for volume, IV, and spreads in Excel
LEAPS options are long-term options contracts with expiration dates over one year out. Learn what LEAPS are, top strategies like the poor man's covered call, and how to analyze them using MarketXLS Excel formulas.
Implied Volatility Screener helps options traders find contracts with the highest or lowest IV for premium selling and volatility strategies. Learn to build an IV screener in Excel with MarketXLS.
Five option strategies (bull call spread, bear put spread, iron condor, long call butterfly, protective collar) and how to check option liquidity first.
Delta neutral strategy showing portfolio balancing for volatility-focused trading with payoff diagrams
Short call options give sellers premium income in exchange for unlimited upside risk. Learn how to set up, track, manage, and roll short calls using MarketXLS in Excel.
Call Ratio Backspread is a bullish options strategy that offers unlimited upside profit potential with limited downside risk. Learn the complete setup, P&L scenarios, Greeks analysis, and how to build it in Excel.
VWAP Strategy uses the volume weighted average price to identify fair value, time entries, and improve execution in options trading. Learn to calculate VWAP and combine it with options strategies using MarketXLS.
A put ratio backspread sells one higher-strike put and buys two or more lower-strike puts. It profits most on a sharp drop and loses most at the long strike.
Call ratio spread strategy explained with setup, payoff diagrams, Greeks analysis, and risk management. Learn when to use this neutral options strategy and track it in Excel with MarketXLS.
Put ratio spread guide covering strategy setup, payoff diagram, max profit and loss calculations, Greeks analysis, risk management, and Excel implementation using MarketXLS options functions.
Manage options income risk with four rules: size each trade at 1-2% of capital, use defined-risk spreads, diversify underlyings, and set an exit before entering.