Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Where can I get a Black-Scholes formula in Excel?
Is there a formula to calculate Black-Scholes values?
|
#2
|
|||
|
|||
I have no idea what Black-Scholes is, but a simple Google lookup of the NGS
threw up http://tinyurl.com/aumjf, and on the web, http://tinyurl.com/dj77z -- HTH RP (remove nothere from the email address if mailing direct) "Ricky" wrote in message ... Is there a formula to calculate Black-Scholes values? |
#3
|
|||
|
|||
For European options the call value formula is:
=(s*(NORMDIST(((LN(s/x))+((rr+(sigma*sigma/2))*t))/(sigma*(SQRT(t))),0,1,TRUE)))-(x*(EXP(rr*t*(-1)))*(NORMDIST(((LN(s/x))+((rr+(sigma*sigma/2))*t))/(sigma*(SQRT(t)))-(sigma*SQRT(t)),0,1,TRUE))) rr risk freerate of interest s stock price sigma volatility t time x strike price This is taken Chapter 7 from my book "Excel Best Practices for Business" (ISBN: 076454120X). Rather than calculating a single point estimat, the spreadsheet produces a table over a range of time periods and volatility. "Ricky" wrote: Is there a formula to calculate Black-Scholes values? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions |