Copyright OptionsTaxGuy LLC

  • Facebook Social Icon
  • YouTube Social  Icon
  • Twitter Social Icon

Downloads

Option Pricing Model

As I mentioned on the Home page of this website, I trade options seriously.  I have developed several option pricing models based on the Black-Scholes pricing methodology and use them to determine:

  • Potential profit or loss

  • Exit points

  • The probability of a successful trade


The spreadsheet calculates the option value given the following inputs:

  • Price of the underlying asset, ie, stock or ETF

  • Strike price

  • Implied volatility - calculated* on broker’s option chain

  • Dividend yield expressed as a percentage

  • Risk-free interest rate

  • Days to expiration


Below is a video of how the model works.
___________________________________


*  Implied volatility is commonly derived from the price/value of a particular option, which is determined based on supply and demand;  therefore, implied volatility is a “plug” amount that evaluates to the current theoretical option price.  Since the market is efficient but seemingly moves in an “emotional” way, Black-Scholes provides a theoretical value given ones market forecast for:

  • Price of the underlying

  • Volatility, and

  • Term of the trade

Single Option Pricing Model

Free Download - Opens as a Google drive link; then simply click on the download icon in the top right-hand corner

This template contains both:

  • An Option Pricing Model, and

  • An Option Forecast Model

You can price an option at the inception of the trade and forecast its price as the trade progresses.