MarketXLS Blog

Market data, investing ideas, and practical Excel guides.

Browse series
option greek formula excel - options strategy analysis and payoff diagram in Excel with MarketXLS

Calculate option Greeks in Excel with MarketXLS opt_ functions: opt_Delta, opt_Gamma, opt_Theta, opt_Vega, opt_Rho and opt_ImpliedVolatility. Syntax and example.

Options Trading
Option Strategy for Beginners - Top 10 - options strategy analysis and payoff diagram in Excel with MarketXLS

Discover the top 10 options trading strategies for beginners, including covered calls, spreads, straddles, and more, with clear payoff diagrams and expert insights.

Options Trading
Double Diagonal Option Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS

A double diagonal sells near-term OTM calls and puts and buys longer-dated, further OTM calls and puts. How it works, when to use it, Greeks, and exits.

Options Trading
Exploring the Benefits of Options Analytics - options strategy analysis and payoff diagram in Excel with MarketXLS

Options analytics measures an option position: value, Greeks, implied volatility, breakevens, and P&L across prices. What each tells you and how to use it for risk.

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.