A angela Jan 4, 2010 #1 have anyone used this formula in excel? BSVAL() I searched in the help but couldn't find an answer. thanks!
have anyone used this formula in excel? BSVAL() I searched in the help but couldn't find an answer. thanks!
M Mike H Jan 4, 2010 #2 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
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
R ryguy7272 Jan 4, 2010 #3 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
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
