MarketXLS Blog

Market data, investing ideas, and practical Excel guides.

Browse series
Get an Edge With Spy Options Chain - options strategy analysis and payoff diagram in Excel with MarketXLS

What the SPY options chain shows, how to read calls, puts, premiums and time decay on it, and how to pull it into Excel with MarketXLS.

Options Trading
The Basics of Trading Options on Futures - options strategy analysis and payoff diagram in Excel with MarketXLS

Options on futures explained: how futures contracts work, how calls and puts on futures are priced and traded, margin, expiration, and the main risks.

Options Trading
How to Create a Winning Option Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS

An option strategy needs four parts: the right analysis tools, a defined strategy such as a spread or straddle, diversification, and position-level risk limits.

Options Trading
Investing Wisely With Greek Options - options strategy analysis and payoff diagram in Excel with MarketXLS

Investing Wisely With Greek Options Greeks in option trading are popularly known as parameters that define the behavior of options or derivatives. Knowing about these parameters is essential for making wise decisions regarding investments. In this article, we will discuss the importance of Options Greeks, different risk management techniques to get maximum returns and finally, */ -->

Options Trading
How Iron Condor and Strangle Options Differ

An iron condor is a four-leg, defined-risk credit trade; a strangle is a two-leg trade with undefined risk when sold. How the two differ in structure, volatility view, risk, and payoff.

Options Trading
The Factors Impacting Option Prices - options strategy analysis and payoff diagram in Excel with MarketXLS

Option prices depend on the stock price, strike, time to expiration, implied volatility, interest rates, and dividends. How each one moves call and put premiums.

Options Trading
Benefits of Being Delta Positive - options strategy analysis and payoff diagram in Excel with MarketXLS

Being delta positive means an options position gains when the stock rises. Learn how position delta works and which strategies (long calls, bull spreads, covered calls) are delta positive.

Options Trading
The Basics of Put Call Forward Parity - options strategy analysis and payoff diagram in Excel with MarketXLS

The Basics of Put Call Forward Parity Put-call forward parity states that for European options with the same underlying, strike, and expiration, the call price minus the put price equals the present...

Options Trading
YieldBased Options: What You Need to Know - options strategy analysis and payoff diagram in Excel with MarketXLS

Yield enhancement with options means selling options, such as covered calls and cash-secured puts, to earn premium. How it works, what it costs, and the risks.

Options Trading
excel options risk - options strategy analysis and payoff diagram in Excel with MarketXLS

How to measure the risk and reward of a stock option trade: premium, breakeven, maximum loss, and Greeks, using option calculators in Excel.

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.