Pricing Lookback Options

Lookback options let the contract holder trade the underlying asset at the optimum price reached over the life of the contract. They are often purchased by investors who want to avoid the regret of not anticipating the correct market timing.Lookback options are never out of the money and eliminate timing issues with entering and exiting the market.

However, they are more expensive than their vanilla European counterparts and are considered speculative.

With a Lookback call option, the contract isn’t necessarily traded at the market price.  The holder has the benefit of hindsight; they can choose to purchase the asset at its lowest price during the life of the contract.  Conversely, a Fixed Lookback Put allows the holder to sell the asset at the highest price during the life of the contract

The strike price can either be fixed or floating.

  • Fixed Lookbacks have the strike determined at purchase
  • Floating Lookbacks  have the strike fixed at maturity. Holders of calls have the strike fixed at the lowest price during the life of the contract.  Holders of puts have the strike fixed at the highest price during the life of the contract
Lookback Option Excel Calculator

Pricing Lookback Options with Excel

These Excel spreadsheets calculate the price of European style Lookback options. The closed-form analytical equations used to price options with Floating Strikes were derived by Goldman, Sosin & Satto (1979). The corresponding equations used to price Fixed Strikes were taken from Conze & Vizwanathan (1991). The formulas are summarized here.

Download Excel Spreadsheets to Price European Style Floating Lookback Options

5 thoughts on “Pricing Lookback Options

  1. Thank you for the priceless stuff. Is there a way I can get hold of all the excel files and the VBA code used showing instead of being password protected. Would love to use this in my Phd studies


  2. Hi, your work is very good.

    In Floating Lookback Options, MINIMUM STOCK PRICE is the MIN Stock price for the call and the MAX for the PUT, correct?


  3. I priced a look back option , witht the following parameters
    Time to maturity = 0.083 yrs = 1 month
    risk free rate = .25%
    volatility 32%
    stock price 21.65
    Min stock price 19
    yield 0

    I get a call option price as minus 4.24$ i.e a negative number , any explanations please

  4. Hi Samir,
    I am interested in buying the unlock version of the spreadsheet that prices European Style Fixed Lookback Options. I need to price LB option in an historical simulation I am running and would like to incorporate your code in my file. Is it possible?

Leave a Reply to Samir Cancel reply

Your email address will not be published. Required fields are marked *

What is 7 + 11 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)