Anthony's VBA Forum

[karina]

Hi,
I'm trying to back out the implied volatility from the option prices using a Newton - Raphson method. The problem is that the computer blockes calculating some cells of the matrix. I mean, once the code has been executed, each cells of the matrix has to be calculated but at one moment (at one cells), the calculation stoppes. It's maybey mormall, and it's possible to extrapolate... but how can i write a macro to let the calculation continue ? Right now , when the computer is blocked on one of the cells of the matrix, i can wait the hours and it doesn't go further. I'm sure that the macro function is correct. Can anybody help me? Maybey it's possible to write macro containing a limit time of calculations for each cells to let it moove further if its blocked???

[Data]

Do not know what you mean. Are you using VBA to do this?
_________________
Data
Knowledge is Power