Options Trading
How to get an option chain, option prices and Greeks into Excel: MarketXLS formulas compared with Thinkorswim, IBKR, Power Query, CBOE and Python.
Master covered call position management with our comprehensive Excel tracking system. Learn when to roll, close early, and optimize your covered call portfolio using MarketXLS.
Best covered calls are found through systematic screening of stock quality, premium yield, strike selection, and liquidity. Learn how to build a covered call screener in Excel with MarketXLS and find optimal income-generating opportunities.
Covered call strategy is the most reliable way to generate recurring income from stocks you already own. Learn step-by-step how to set up, analyze, and manage covered calls using MarketXLS in Excel.
0DTE Theta Decay accelerates dramatically on expiration day. Learn how same-day options lose time value hour by hour, trading strategies to profit from rapid decay, and how to track theta in real time with MarketXLS.
0DTE options strategy explained: how same-day expiration options work, common setups like iron condors and credit spreads, the main risks, and how to analyze them in Excel.
SPX options historical data enables traders to backtest strategies, analyze volatility trends, and study pricing patterns on the S&P 500 Index. Learn how to retrieve and analyze historical SPX options data using MarketXLS Excel functions.
How to get real-time option data in Excel: stream contracts with =QM_Stream_Last, pull chains and Greeks with QM_GetOptionChain and QM_GetOptionQuotesAndGreeks, and which plan you need.
2026 option expiration dates: monthly options expire the third Friday (Jan 16 to Dec 18), quarterly witching in Mar, Jun, Sep, Dec, and SPX/SPY expire every trading day.
Extrinsic value is the portion of an option's price above its intrinsic value — driven by time and volatility. Learn how to calculate, track, and profit from extrinsic value in Excel.
Rolling an option means closing it and opening a new contract with a later expiration, a different strike, or both. How to roll up, down, and out, with Excel examples.
Standard monthly SPX options expire on the third Friday and settle on that morning's opening prices; SPXW weeklies expire every trading day and settle at the close.
Short-dated options lose time value fastest near expiration. How time decay, implied volatility, and pin risk affect them, and how to track them in Excel.
Option formula in excel allows traders and analysts to price options, calculate Greeks, and retrieve live option chains directly in their spreadsheets using proven mathematical models and MarketXLS functions.
SPXW options are weekly and daily S&P 500 index options that give traders flexible, short-term exposure to the broad market. Learn how SPXW settlement works, how they differ from standard SPX options, key trading strategies, and how to analyze them in Excel with MarketXLS.
Theta Decay Calculator guide — learn how to measure, track, and profit from options time decay using MarketXLS in Excel.