hello,
i am trying to create a binomial asset Pricer and am expecting an output of ~$6.37 from my code.
i am getting the below error:
error.png
please help, thank you
full code:
BAPM_v1.xlsm
hello,
i am trying to create a binomial asset Pricer and am expecting an output of ~$6.37 from my code.
i am getting the below error:
error.png
please help, thank you
full code:
BAPM_v1.xlsm
Well, variable S is passed as a Double. The line of code that's failing is trying to reference S as if it were a two-dimensional array. VBA is expecting an array when you reference array indices but it's not an array; it's a Double.
WBD
Office 365 on Windows 11, looking for ✶ rep!
( removed )
Based on this page:
https://en.wikipedia.org/wiki/Binomi..._pricing_model
And adapting the algorithm on the right into VBA, this is what I came up with:
But it returns 5.251026 as the answer so perhaps it's not right?![]()
Please Login or Register to view this content.
WBD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks