Options Trading
Calculate option Greeks in Excel with MarketXLS opt_ functions: opt_Delta, opt_Gamma, opt_Theta, opt_Vega, opt_Rho and opt_ImpliedVolatility. Syntax and example.
How to pull a live option chain into Excel with MarketXLS: strikes, bid/ask, volume, open interest, and Greeks for US stocks and NSE options.
Get NSE option chain data for Nifty, Bank Nifty, and stock options into Excel with MarketXLS India and a connected Zerodha or Angel One account, then analyze open interest and PCR.
Discover the top 10 options trading strategies for beginners, including covered calls, spreads, straddles, and more, with clear payoff diagrams and expert insights.
Option Greeks in Excel can be calculated instantly using MarketXLS functions like QM_GetOptionQuotesAndGreeks and QM_GetOptionChain. Learn how to get Delta, Gamma, Theta, Vega, and Rho for any option directly in your spreadsheet.
The put call ratio (PCR) divides put volume or open interest by call volume or open interest. How to read PCR for Nifty and US markets and track it in Excel.
Option traders in the US cluster in cities with strong financial ecosystems, educated workforces, and active trading communities. Discover the top 10 cities and the tools professional option traders rely on.
Ten YouTube channels for learning options trading (as of July 2023): Option Alpha, TheChartGuys, Sky View Trading, projectfinance, tastylive, and more.
Ten common options strategies: long call, long put, covered call, protective put, bull call and bear put spreads, strangle, iron condor, straddle and butterfly.
Binomial option pricing model explained with step-by-step Excel implementation. Learn CRR model theory, build pricing trees, compare with Black-Scholes, and use MarketXLS for real-time inputs.
Why employees with stock options should check how their other holdings correlate with their employer's stock, and how to measure it in Excel.
A double diagonal sells near-term OTM calls and puts and buys longer-dated, further OTM calls and puts. How it works, when to use it, Greeks, and exits.
Double Diagonal option strategy combines calendar and vertical spreads for range-bound profit. Learn setup, risk/reward, Greeks management, adjustments, and how MarketXLS helps analyze this advanced strategy.
2 leg option strategies explained with all vertical spreads, straddles, strangles, and calendar spreads including setup, payoff calculations, Greeks, and Excel tracking with MarketXLS.
Vega of an option measures how much the option's price changes when implied volatility moves by 1%. Learn the vega formula, how vega behaves across strikes and expirations, long vs short vega strategies, and how to track vega in Excel with MarketXLS.
Options analytics measures an option position: value, Greeks, implied volatility, breakevens, and P&L across prices. What each tells you and how to use it for risk.