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