ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   bsval (https://www.excelbanter.com/excel-worksheet-functions/252321-bsval.html)

Angela

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

Mike H

bsval
 
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" wrote:

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


ryguy7272

bsval
 
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%E2%80%93Scholes

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Mike H" wrote:

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" wrote:

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



All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com