#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 85
Default bsval

have anyone used this formula in excel?
BSVAL()
I searched in the help but couldn't find an answer. thanks!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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!

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"