Why does this give a syntax error? Coding a function

Function OTW_25PutStrike(UnderlyingPrice, Time, Interest, Dividend, Volatility, Price)


OTW_25PutStrike = UnderlyingPrice/(EXP(Volatility*Sqr(Time)*Application.WorksheetFunction.Norm_S_Inv(((-0.25)/EXP^(-Dividend*Time))+1) -Time*(Dividend - Interest + Volatility^2/2))

End Function

Rule #X bla bla put CODE tags around your code etc.

Having said that: You're missing a closing parenthesis.

Please Login or Register  to view this content.

Now it highlights EXP and says "argument not optional"

What does this mean?

Ah, didn't see the 2nd Exp there.

You'll need to specify a parameter (i.e. Exp(a number))

Judging by what you're trying to do there... you can either...

1) get rid of the caret (^) sign or...

Please Login or Register  to view this content.

2) do a Exp(1) then raise it to the power

Please Login or Register  to view this content.

whichever you prefer.

solved this! thanks for your help. this is good stuff!

No problem at all. Please do remember to mark this thread as Solved if you can.