MarketXLS Blog

Market data, investing ideas, and practical Excel guides.

Browse series
Gain a Trading Edge with an Option Scanner - options strategy analysis and payoff diagram in Excel with MarketXLS

An option scanner filters option contracts across many stocks by expiry, volume, open interest, IV, and premium. What it screens for and how the MarketXLS Option Scanner works.

Options Trading
How to Determine Option Moneyness? - options strategy analysis and payoff diagram in Excel with MarketXLS

Option moneyness compares the stock price with the strike: a call is in the money above the strike, a put below it, and at the money when they are equal.

Options Trading
Uncover the Secrets of Professional Options Trader - options strategy analysis and payoff diagram in Excel with MarketXLS

Uncover the Secrets of Professional Options Traders Professional options traders rely mostly on a few defined structures rather than single option bets: vertical spreads (bull call and bear put...

Options Trading
live option chain in excel - options strategy analysis and payoff diagram in Excel with MarketXLS

Get a live option chain in Excel with =QM_GetOptionChain("AAPL") from MarketXLS, then read strikes, premiums, implied volatility, Greeks, and open interest.

Options Trading
Get to Know the qqqq Options - options strategy analysis and payoff diagram in Excel with MarketXLS

QQQQ was the old ticker of the Nasdaq-100 ETF, now QQQ. How QQQ options work: calls, puts, pricing, Greeks, implied volatility and risk.

Options Trading
Understand Option Greeks with a Calculator - options strategy analysis and payoff diagram in Excel with MarketXLS

Option Greeks measure how an option price reacts to the stock price (delta, gamma), time (theta), volatility (vega), and rates (rho). How to read them with a calculator.

Options Trading
The Power of Rolling Your Options - options strategy analysis and payoff diagram in Excel with MarketXLS

Rolling an option means closing an existing position and opening a similar one with a later expiration, a different strike, or both. When and why traders roll.

Options Trading
Trading Strategies for Vix Options - options strategy analysis and payoff diagram in Excel with MarketXLS

VIX options are cash-settled, European-style options on the Cboe Volatility Index, priced off VIX futures. How they differ from stock options and common strategies.

Options Trading
Mastering the Art of Shorting Call Options - options strategy analysis and payoff diagram in Excel with MarketXLS

Shorting (selling) a call collects premium up front and profits if the stock stays below the strike. How it works, maximum profit and loss, margin, and risk controls.

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.