MarketXLS Blog

Market data, investing ideas, and practical Excel guides.

Browse series
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.

Options Trading
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.

Options Trading
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.

Options Trading
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.

Options Trading
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.

Options Trading
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.

Options Trading
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.

Options Trading
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.

Options Trading

Explore our 94 blog series

Browse articles by topic, arranged in reading order.

Browse the series directoryBrowse all article categories
Show all 94 series

The Professional Investment Platform Inside Excel

Live market data, stock screening, options analytics and portfolio management inside Excel.