Implied Volatility Program on lot of data

Expand Post »

Hi,
I have 15000 excel lines of option data, with dividend rate, risk free rate, option price, strike, maturity, underlying...and I would like to compute the ilpied volatility of my options using the Newton-Raphson method, which is faster than the bisection method.

But the problem is that I have a lot of data (15000 lines, for 15000 options), and I would like to make the macro running for all the excel file.

Can you help please ?

thank you

peltant

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2009

Permalink

May 28th, 2009

Re: Implied Volatility Program on lot of data

see this site for explanation to using the Newton-Raphson method -
http://people.revoledu.com/kardi/tut...onRaphson.html
It seems it has to recalulate for each line of data. 15,000 rows of data may take an awful long time and may even cause an error before it is finished.

Perhaps an easier solution is to calculate each given before it moves on to the next given then each given could then be calulated so you don't end up with on long calculation.
Could you send me one row of data and expected caluclations?
See my stuff at - http://www,geocities.com/excelmarksway

Jupiter 2

Reputation Points: 33

Solved Threads: 27

Posting Whiz

Offline

372 posts
since May 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Legacy and Other Languages Forum Timeline: Regexp to finite state machines

Next Thread in Legacy and Other Languages Forum Timeline: Excel forms

DaniWeb Message

Cancel Changes

User Name
Password