well, with Black sholes. implied versus historical volatility becomes an issue.
you can build what you're talking about in excel, but you will still nead to furnish volatility, which is the most elusive of variables.
However, Black Scholes is really bullshit (yeah yeah, so they go t a...