bij deze code krijg ik hele tijd type mismatch.. iemand die weet hoe dit komt?
Code:
Sub simulateGBM()
t = 5
steps = 10
S0 = 100
sigma = 0.25
mu = 0.15
Number = 3
dt = 1 / steps
For i = 1 To Number
For j = 1 To steps * t
Cells(1, i) = S0
rand = Rnd()
Cells(j + 1, i).Value = (Cells(j, i)) * Exp((mu - (sigma ^ 2) / 2) * dt + sigma * Sqr(dt) * Application.NormSInv(rand))
Next
Next
End Sub