Need help with a formula for Theta

• 23 December 2011

• #1

V

village idiot

Joined

18 June 2010

Posts

277

Reactions

0

can any options guru or mathematics guru help with this please;

in the formula for Theta, what does the N' as in N'(d1) mean, and is there an excel function for it?

To be clear, I am asking what N' with an apostrophe stands for as opposed to N , which is NORMDIST in excel

thanks

 

• 23 December 2011

• #2

R

robusta

Joined

25 October 2009

Posts

1,557

Reactions

2

Think I knew a greek girl called Theta, the N stood for no.

 

• 23 December 2011

• #3

mazzatelli

Joined

22 July 2009

Posts

602

Reactions

0

N' = the std pdf, while N = the std cdf for a normal dist

NORMDIST(x,0,1,FALSE)

 

• 23 December 2011

• #4

V

village idiot

Joined

18 June 2010

Posts

277

Reactions

0

thanks mazza, thought you might be able to help.

got it all working good now

cheers