implied volatiliy and excel

[Maurice Zandbelt <maza95@xxxxxxxxx>]

I hope somebody can help me.

I use metastock 6.0, I use option scope to calculate the options implied
volatility. I am also using excel with a DDE (dynamic data exchange).

I want to make a excel worksheet which calculates during trading hours,
the delta of the option which I sold short. Can somebody help me with
the formula to calculate the implied volatility or delta when I already
have the price of the option ?

Best regards,

Maurice Zandbelt