Re: [公告] 有關明天選擇權的作業!!!
Function simulation(s, m, t, v, n, Num)
dt = t / n
drift = m * dt
vol = v * Sqr(dt)
For i = 1 To Num
st = s
cr = 0
cr2 = 0
For j = 1 To n
s1 = st
st = st * Exp(drift + vol * Application.NormSInv(Rnd()))
r = Log(st / s1)
cr = cr + r
cr2 = cr2 + r ^ 2
Next
std = Sqr(cr2 / (n - 1) - cr ^ 2 / (n * (n - 1))) * Sqr(n)
Sum = Sum + st
Sumr = Sumr + cr
Sumstd = Sumstd + std
Next
simulation = Sumstd / Num'can be shown as "mean of prices(Sum/Num)","mean of returns(Sumr/Num)", or "mean of STD(Sumstd/Num)"
End Function
參考一下~這是我的結果!!
模擬3000個path:
Mean of prices 42.63790603
Mean of returns 0.155677164
Mean of sigma(std) 0.299791742
好像蠻接近的!!!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 220.229.89.24
→
220.229.89.24 04/12, , 1F
220.229.89.24 04/12, 1F
推
218.171.144.6 04/12, , 2F
218.171.144.6 04/12, 2F
推
220.143.214.13 04/12, , 3F
220.143.214.13 04/12, 3F
推
220.229.89.24 04/12, , 4F
220.229.89.24 04/12, 4F
推
140.123.216.195 04/12, , 5F
140.123.216.195 04/12, 5F
→
140.123.216.195 04/12, , 6F
140.123.216.195 04/12, 6F
推
218.171.144.6 04/12, , 7F
218.171.144.6 04/12, 7F
推
218.171.144.6 04/12, , 8F
218.171.144.6 04/12, 8F
推
220.229.89.24 04/12, , 9F
220.229.89.24 04/12, 9F
→
220.229.89.24 04/12, , 10F
220.229.89.24 04/12, 10F
推
218.171.144.6 04/12, , 11F
218.171.144.6 04/12, 11F
→
220.229.89.24 04/12, , 12F
220.229.89.24 04/12, 12F
→
220.229.89.24 04/12, , 13F
220.229.89.24 04/12, 13F
推
140.123.216.195 04/12, , 14F
140.123.216.195 04/12, 14F
討論串 (同標題文章)
完整討論串 (本文為第 4 之 5 篇):