\114\74\64\64\64\64\64\64\64\64\64\64\64\64\64\64\64\64\64\64\64\64\64\64\64\64\
2\INPUTS\\\\\\\\\\\\\\\\\\\\\\\\\\
13\Price\1000\\\\\\\\\\\\\\\\\\\\\\\\\
\Strike\1000\\\\\\\\\\\\\\\\\\\\\\\\\
\Time to Expiry (Days)\25\\\\\\\\\\\\\\\\\\\\\\\\\
\Interest Rate (%)\1\\\\\\\\\\\\\\\\\\\\\\\\\
\Volatility (%)\25\\\\\\\\\\\\\\\\\\\\\\\\\
\\\\\\\\\\\\\\\\\\\\\\\\\\\
\\\\\\\\\\\\\\\\\\\\\\\\\\\
\OUTPUT\\\\\\\\\\\\\\\\\\\\\\\\\\
\d1\=(ln(cell(2;2)/cell(2;3))+(cell(2;5)/100+(cell(2;6)/100)^2/2)*cell(2;4)/252)/(cell(2;6)/100*sqrt(cell(2;4)/252))\\\\\\\\\\\\\\\\\\\\\\\\\
\d2\=cell(2;10)-cell(2;6)/100*sqrt(cell(2;4)/252)\\\\\\\\\\\\\\\\\\\\\\\\\
\Call Price\=cell(2;2)*normdist(cell(2;10);0;1;1)-cell(2;3)*exp(-cell(2;5)/100*cell(2;4)/252)*normdist(cell(2;11);0;1;1)\\\\\\\\\\\\\\\\\\\\\\\\\
\Put Price\=-cell(2;2)*normdist(-cell(2;10);0;1;1)+cell(2;3)*exp(-cell(2;5)/100*cell(2;4)/252)*normdist(-cell(2;11);0;1;1)\\\\\\\\\\\\\\\\\\\\\\\\\
