bsval

[angela]

have anyone used this formula in excel?
BSVAL()
I searched in the help but couldn't find an answer. thanks!

 

[Mike H]

Angela,

It's not part of Excel, what does it do? what do you want it to do? perhaps
we can come up with something.

Mike

 

[ryguy7272]

Maybe you have a user-defined function in your workbook. Are you prompted to
enable macros when you open the workbook? If you hit alt+F11 do you see some
code in the window that opens?
=bsval(iv,k,s0,tau,rfr,coc)

Seems like it could be Black-Scholes Valuation.
http://www.quickmba.com/finance/black-scholes/
http://en.wikipedia.org/wiki/Black–Scholes