Excel based options models?

This is a discussion on Excel based options models? within the Trading Software forums, part of the Commercial category; Can anybody help me find (simpel) excel based options models for fx and equities? I have real-time feeds ( will ...

Reply
 
LinkBack Thread Tools Search this Thread
Old May 14, 2003, 3:09pm   #1
 
bgold's Avatar
Joined Dec 2002
Excel based options models?

Can anybody help me find (simpel) excel based options models for fx and equities? I have real-time feeds ( will use static int rate and dividend data) which will allow me to make estimates for the greeks (especially delta, gamma and vega).
thanks
JP
bgold is offline   Reply With Quote
Old May 14, 2003, 3:29pm   #2
 
RogerM's Avatar
Joined Mar 2001
In my view, this one is excellent

http://www.hoadley.net/options/LatestVersion.htm
__________________
regards,

Roger(M)

http://www.wehanghere.com
RogerM is offline   Reply With Quote
Old May 14, 2003, 4:01pm   #3
 
bgold's Avatar
Joined Dec 2002
bgold started this thread many thanks Roger. This service/product appears to be exactly what I am looking for. tx JP
bgold is offline   Reply With Quote
Old May 14, 2003, 5:19pm   #4
 
RogerM's Avatar
Joined Mar 2001
You're welcome Toad. I use the free strategy calculator all the time. The online tutorials are first class.
__________________
regards,

Roger(M)

http://www.wehanghere.com
RogerM is offline   Reply With Quote
Old May 29, 2003, 4:15pm   #5
 
RedE's Avatar
Joined May 2003
Beware the Americans

For European options otions calculations are generally quite straigtforward.

I have encoded the Black-Scholes formulae into an Excel AddIn and use it extensively.

However, American options are very different. Trading wise they are somewhat similar, but the devil lies in the detail.

The problem essentially boils down to the question of how to value the additional optionality which American options contain - namely the early execrcise portential.

With an European option, prior to expiry, you can only sell the option. With an American you have the choice of either selling the option or exercising it.

This requires rather cumbersome (but not impossible or, even, beyond Excel) analytics to value them.

However, most index options are European so Black-Scholes applies.

In my experience, the price outputted by any options model is fine ...... in theory, but usually bears little relationship to the actual market prices. Reasons: volatility smiles, liquidity, "normal" distribution and many other assumptions which these models require to be made for them to work mathematically.

My take on them:
Use the options valuation models as a framework within which to gauge likely future values of options - but never as a basis on which to trade them. Always allow a relatively large margin of error.

Anyone else have a view on how well the current slew of options valuation models perform in reallity????
__________________
E
Order from Chaos.

Last edited by RedE; May 29, 2003 at 4:35pm.
RedE is offline   Reply With Quote
Old May 29, 2003, 7:10pm   #6
 
cassiopeia's Avatar
Joined Mar 2002
The problem with most option models is they do not integrate with the underlying instrument for volatility and dividend adjustments, these have to be worked out and typed in.

The other problem with option models is simply that they do not calculate the true value correctly as long term capital management found out.

That is because shares and indices do not follow a gaussian model and any model based on the data with have an inherent tendency to underestimate the incidence of extreme events, thereby underestimating the price. This will not be obvious until you get seriously hit which may be after many years of making consistent profits from naked writing.
cassiopeia is offline   Reply With Quote
Old Jun 20, 2004, 8:33pm   #7
 
euroderivatives's Avatar
Joined Apr 2004
For American options use the Binomial (Tres) Model.

http://mightymueller.de/mathe/finanz.../amoption.html

Of course there are flaws with each option model because they do not fully cover certain variables.

To estimate the probability of the option price going up or going down to a certain level, probability distribution curve can be used...
__________________
There is time to go short, time to go long and time to go fishing. Jesse Livermore
euroderivatives is offline   Reply With Quote
Old Jun 20, 2004, 8:34pm   #8
 
euroderivatives's Avatar
Joined Apr 2004
http://mightymueller.de/mathe/finanz.../amoption.html
__________________
There is time to go short, time to go long and time to go fishing. Jesse Livermore
euroderivatives is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
10 Playboy models trading the stock market handroll Brokerages 15 Jan 25, 2006 10:37am
Neural Network Trading Models gs2004 Educational Resources 7 Sep 24, 2005 12:40am
Options Pricing in Excel TWI Futures & Options 18 Sep 22, 2005 1:04pm
Pricing models: interest rate iwtlib Futures & Options 3 Feb 3, 2005 5:36am
Trading Options based on Volatility BakedWafer Futures & Options 11 Jan 6, 2005 12:07pm

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)