Options Trading

Gain an Edge with These Effective Options Trading  - options strategy analysis and payoff diagram in Excel with MarketXLS

How common option strategies work: bull call and bear put spreads, calendars, covered calls, protective puts, strangles, straddles, risk reversals, guts, and butterflies.

1/16/2023 • Anagh
Boost Your Profits with Put Option Strategies - options strategy analysis and payoff diagram in Excel with MarketXLS

Put option strategies showing long put, put spread, and protective put with payoff diagrams

1/16/2023 • Ankur
Learn About the Different Fixed Income Options - options strategy analysis and payoff diagram in Excel with MarketXLS

The main fixed income options are government bonds and corporate bonds. How they differ in yield and risk, and what duration, credit risk, and the yield curve mean.

1/16/2023 • Anagh
Mastering the Strangle and Straddle Option Strateg - options strategy analysis and payoff diagram in Excel with MarketXLS

A straddle buys a call and put at the same strike; a strangle buys an out-of-the-money call and put at different strikes. Both profit from a large move in either direction.

1/16/2023 • Ankur
The Fundamentals of Option Pricing - options strategy analysis and payoff diagram in Excel with MarketXLS

An option price is intrinsic value plus time value, driven by stock price, strike, time, volatility, rates and dividends. Black-Scholes, binomial models and Greeks.

1/16/2023 • Ankur
Making Money with Trade Spy Options Trading - options strategy analysis and payoff diagram in Excel with MarketXLS

How traders approach SPY options: common strategies, the role of scanning and risk management, and how to analyze SPY option data in Excel with MarketXLS.

1/16/2023 • Anagh
What are Ask vs Bid Options? - options strategy analysis and payoff diagram in Excel with MarketXLS

The bid is the highest price a buyer will pay for an option; the ask is the lowest price a seller will accept. How the bid-ask spread affects your cost.

1/16/2023 • Ankur
how to pull live option chain data in excel sheet - options strategy analysis and payoff diagram in Excel with MarketXLS

Pull a live option chain into Excel with =QM_GetOptionChain("AAPL") and read each column: strike, premium, implied volatility, delta, and expiration.

1/16/2023 • Ankur
live option prices in excel - options strategy analysis and payoff diagram in Excel with MarketXLS

Get live option prices in Excel with MarketXLS: pull a full option chain or a single contract, plus what drives option prices and how to model P/L.

1/16/2023 • Anagh
The Basics of Options Swing Trading - options strategy analysis and payoff diagram in Excel with MarketXLS

Options swing trading holds call or put positions for a few days to a few weeks to capture a price swing. The basics: technical entries, risk limits, and profit targets.

1/16/2023 • Ankur
ITM Options - A Strategic Investing Tool - options strategy analysis and payoff diagram in Excel with MarketXLS

In-the-money options have intrinsic value: calls with strikes below the stock price, puts with strikes above. How ITM options behave, their uses, and risks.

1/16/2023 • Robin
A Comprehensive Look at Option Symbols - options strategy analysis and payoff diagram in Excel with MarketXLS

Understanding option symbols breakdown showing underlying, expiration, type, and strike components

1/16/2023 • Ankur
Gaining Financial Freedom With Commodity Options - options strategy analysis and payoff diagram in Excel with MarketXLS

Commodity options give the right, but not the obligation, to buy or sell a commodity (usually a futures contract) at a set price. How they work, how hedgers use them, and the risks for buyers and sellers.

1/16/2023 • Ankur
Introduction to High IV Options - options strategy analysis and payoff diagram in Excel with MarketXLS

High IV options carry high implied volatility, so their premiums price in bigger expected moves. What that means for buyers, sellers, and spreads.

1/16/2023 • Ankur
Understanding Open Interest in Options Trading - options strategy analysis and payoff diagram in Excel with MarketXLS

Open interest is the number of option contracts still open at the end of the day. How it differs from volume, what changes in it signal, and how to use it.

1/16/2023 • Robin
Leverage Vega to Maximize Your Option Gains - options strategy analysis and payoff diagram in Excel with MarketXLS

Vega is how much an option price changes for a 1 percentage point change in implied volatility. How long and short vega positions work and how to calculate vega in Excel.

1/16/2023 • Robin