The Factors Impacting Option Prices

In this article

The Factors Impacting Option Prices

Six factors set an option's price: the underlying stock price, the strike price, the time to expiration, implied volatility, interest rates, and expected dividends. A higher stock price raises call premiums and lowers put premiums; more time and higher implied volatility raise both; higher interest rates slightly raise calls and lower puts; and expected dividends lower calls and raise puts. Pricing models such as Black-Scholes combine these inputs into a theoretical value. This article explains each factor and is educational, not investment advice.

See it in actionMarketXLS video

Try it in your own spreadsheet

Get the free MarketXLS sample workbook (.xlsx).

No account needed. MarketXLS live data requires a paid plan. Preview workbook

Explore more videos
The Factors Impacting Option Prices - options strategy analysis and payoff diagram in Excel with MarketXLS

Options are a type of derivative security that gives the holder the right, but not the obligation, to buy or sell an underlying at a predetermined price on or before the expiration date.

Stock Prices

The most important aspect that affects the price of an option is the price of the underlying stock. Stock prices play the biggest role in determining option values because the option premium is derived from the current market price of the stock. The stock price affects the option premium in two ways-for a call option, a higher stock price increases the option premium and for a put option a higher stock price decreases the option premium.

Volatility

The volatility is another important factor that affects option prices. Volatility is an indication of the possible price range of a security over an expected period and it is usually expressed as a percentage. Generally, a higher volatility results in a higher option premium and a lower volatility leads to a lower option premium.

Time Value

The time value of an option is another factor that determines the option premium. Every option has an expiration date and with the passage of time, the option gradually loses its value. This is known as the time value of an option and it is the difference between the option premium and the intrinsic value of the option.

Interest Rates

The interest rate is also another factor that affects the option premium of an option. Generally, higher interest rates have an upward pressure on call option premiums, while lower interest rates have a downward pressure on call option premiums. Similarly, higher interest rates have a downward pressure on put option premiums, while lower interest rates have an upward pressure on put option premiums.

Strike Price

The strike price is the price at which the underlying asset must be bought or sold if the option is exercised. The option premiums also depend on the strike prices, as it affects the intrinsic value of the option. For call options, a higher strike price results in a lower premium; for put options, a higher strike price results in a higher premium.

Expiration Date

The expiration date of an option is the date when the option expires and becomes invalid. The option premium and the time value of the option are inversely related, which means that as the expiration date nears the time value of the option gradually decreases and so does the option premium.

Implied Volatility

Implied volatility is the expected level of volatility of the underlying stock in the future. It is calculated using the current market price of the option, strike price, time to the expiration date, risk-free rate and the current stock price. Generally, a higher implied volatility results in a higher option premium and a lower implied volatility leads to a lower option premium.

Option Premium

Option premiums are the prices at which two parties agree to buy or sell an option. It is important to remember that the option premium is not the same as the intrinsic value of an option; the option premium is the price at which the two parties agree to buy or sell an option and the intrinsic value is the amount of money that an option holder will realize if he exercises the option.

Dividends

Dividends are periodic payments made by a company to its shareholders out of its profits. The impact of dividends on option premiums depends on the type of option; for a call option dividends have a downward pressure on the option premium, while for a put option dividends have an upward pressure on the option premium.

Checking these factors in Excel with MarketXLS

MarketXLS is an Excel add-in that returns the inputs above as formulas: =Last("AAPL") for the stock price, =QM_GetOptionQuotesAndGreeks("AAPL") for option prices, implied volatility, and Greeks across the chain, and =BlackScholesOptionValueWithUserInputs(195,200,30,0.04,0.25,"Call") to see how a theoretical value changes when you vary one input. Options data is end-of-day on the Standard plan and real-time on the Advanced and Business plans.

About the authors
Anagh

About Anagh

CTO, MarketXLS

Anagh is the CTO of MarketXLS. He works with Ankur and Robin on the MarketXLS blog, creating articles together about market data and spreadsheet workflows.

Written collaboratively by Anagh, Ankur and Robin.

Important Disclaimer

The information provided in this article is for educational and informational purposes only and should not be construed as investment advice, a recommendation, or an offer to buy or sell any securities. MarketXLS is a financial data platform and is not a registered investment advisor, broker-dealer, or financial planner. Always conduct your own research and consult with a qualified financial professional before making any investment decisions. Past performance is not indicative of future results. Trading and investing involve substantial risk of loss.

The Professional Investment Platform Inside Excel

Market data and options research tools in Excel

  • Option prices and Greeks in Excel
  • Historical options data in Excel
  • US stock and index options data
  • Prices and data on underlying stocks and indices
  • Use MarketXLS formulas in your Excel worksheets
  • Explore options research workflows in Excel
  • Excel formulas and sample worksheets

See MarketXLS in action

Bring this workflow into Excel.

Book a demo with our team to see how MarketXLS supports your market research.

Ankur
AnkurFounder & CEO, MarketXLS
Book a demo