[問題] 急問..binominal model
請問一下有人可以把他用vba程式寫出來嗎..
(binominal model)
A call option & put option on a stock whose current price is 100
with exercise price is 90,
T=0.5,
r=6%,
sigma=35%,
n=50(the total up and down movements).
To show that the Binomial Option-Pricing Model
converges to the Black-Sholes formula for a call by a graph
這些用手寫是寫的出答案 但是就不知該如何換成excel 用vba寫出來了..
如果有人可以幫忙的話..煩請寄回我滴信箱.....
hitomi0387@hotmail.com
大恩大德感激不盡.........m_m.....
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.231.50.122