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