Thread: Formula help
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Formula help

Did you look? The 2 links I posted are user defined functions. Whether they
work or not I've no idea but the VBAExpress link is usually very reliable

Mike

"Confusicous" wrote:

Does it show how to enter the formula in a way excel can read it? haha I just
can't get my parentheses right.

"Mike H" wrote:

Hi,

I have to confess to not knowing what black-Scholes is but Google does!!

http://www.vbaexpress.com/kb/getarticle.php?kb_id=1013

or here

http://www.theresearchkitchen.com/blog/archives/77

and many more

Mike



"Confusicous" wrote:

d1= ln(B6/B7)+[(B8+((B9^2)/2) x b10] / (B9) (SQRT B10)

This is supposed to be Black-Scholes Option Pricing Model. I tried my best
to show the formula on here and I entered the cells for the values. I need to
be able to put this in an excel but I am having trouble with the placing of
parentheses and using the right formulas. If you need more clarification the
formula let me know. I did my best with what I could do. thanks for the help
in advance