Options Trading
High option volume usually means tighter bid/ask spreads and easier fills, and unusual volume can flag news or positioning. How to read and track it.
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.
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.
Out-of-the-money calls have strikes above the stock price and no intrinsic value. How they are priced, why many expire worthless, and how to manage risk.
Option delta formula explained with the Black-Scholes calculation, call and put delta ranges, ITM ATM OTM behavior, and real-time Greeks tracking in Excel using MarketXLS.
Option volume counts contracts traded today; open interest counts contracts still open at the end of the day. What each tells you and how to use them together.
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...
Get a live option chain in Excel with =QM_GetOptionChain("AAPL") from MarketXLS, then read strikes, premiums, implied volatility, Greeks, and open interest.
QQQQ was the old ticker of the Nasdaq-100 ETF, now QQQ. How QQQ options work: calls, puts, pricing, Greeks, implied volatility and risk.
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.
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.
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.
Active options trading strategy showing custom strategy building workflow in Excel with options chain and Greeks
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.
Option time value explained in depth — covering intrinsic vs extrinsic value, theta decay curves, factors affecting time premium, and practical strategies for profiting from time decay using MarketXLS.
Intrinsic value is how far an option is in the money: stock price minus strike for calls, strike minus stock price for puts, and never below zero.