Options Trading
Get Thinkorswim option chain data into Excel three ways: Scan tab export (static), RTD link (live, Windows only), or MarketXLS QM_GetOptionChain without ToS running.
Selling weekly put options for income explained with strike selection, risk management, Greeks analysis, and step-by-step Excel tracking using MarketXLS option chain and pricing formulas.
The wheel strategy sells cash-secured puts until assigned, then sells covered calls on the shares until they are called away, and repeats. Steps, scenarios, and a worked example.
Options trading Excel spreadsheets give traders real-time option chains, Greeks tracking, P&L analysis, and strategy modeling directly in their familiar Excel environment.
Option writing turns stock holdings into income: sell covered calls on shares you own or cash-secured puts on shares you want to buy, and keep the premium.
Five options trading tips for beginners: use a low-commission broker, focus on risk, stick to liquid stocks, avoid complex products, and use limited-risk strategies.
Implied volatility surface analysis reveals how IV varies across strikes and expirations, helping options traders identify mispriced contracts. Learn to build one in Excel.
Option premium is the price paid for an options contract, determined by intrinsic value, time value, volatility, and other factors. Learn how to calculate, analyze, and track option premiums using Excel and MarketXLS formulas.
How the binomial option pricing model values an option with an up/down price tree, how it differs from Black-Scholes, and a worked Excel example.
Learn about the covered put options strategy, how it works, and when to use it for income generation.
Find the most active options on your stock list in Excel with the MarketXLS Options Scanner (sort by contract volume) or =QM_GetOptionChainActive.
Historical option prices data enables traders to backtest strategies, analyze implied volatility patterns, and make informed trading decisions using Excel-based tools and real market data.
Use the MarketXLS Option Scanner to pull option chains for up to 50 stocks, filter by volume, spread, IV, delta and expiry, and send the results to Excel.
Compare cash-secured puts by annualized return: (bid - fees) / strike x 365 / days to expiration. A worked Walmart example using a MarketXLS option chain in Excel.
How to price stock options in Excel: Black-Scholes and binomial models, plus MarketXLS formulas for option chains, Greeks and streaming prices, and which plan is real-time.