Hello everyone,

I just typed a function on VBE but it is not appearing on my functions is it normal?

Here is the code Function getcallprice(spot_, strike_, maturity_, pricing_date_, divyield, rate_, vol_)
If IsEmpty(vol_) Or vol_ = 0 Then vol_ = 0.25
maturity_ = maturity_ - pricing_date_
If maturity_ < 0 Then
getcallprice = 0
Exit Function
End If
maturity_ = Application.Max(maturity_ / 365, 1 / 365)
d1 = 1 / (vol_ * Sqr(maturity_)) * (Log(spot_ / strike_) + (rate_ - divyield_ + 1 / 2 * vol_ ^ 2) * maturity_)
d2 = d1 - vol_ * Sqr(maturity_)
Nd1 = Application.NormSDist(d1)
Nd2 = Application.NormSDist(d2)
getcallprice = Nd1 * spot_ * Exp(-divyield_ * maturity_) - Nd2 * strike_ * Exp(-rate_ * maturity)
End Function

Thanks a lot!

REgards