View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Box Box is offline
external usenet poster
 
Posts: 2
Default Exponential Decay of Option Prices

I have an option price and I know that the option expires in 35 days. I also
know that option prices decay exponentially; decay increases as time to
expiration decreases.

How can I estimate the exponential decay in the option price from the 35 day
to the 34 day?

Rather than use an option pricing model I'm simply looking for an Excel
function that gives some sort of basic exponential decay value.

Thanks for your help.