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

8 Years
Discussion Span
Last Post by Jupiter 2

see this site for explanation to using the Newton-Raphson method -
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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.