compile error: expected array ; binomial asset pricer

[fruitloop44]

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

[WideBoyDixon]

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

[Marc L]

( removed )

[fruitloop44]

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

Gotcha!
What Can I change it to? I don?t believe it needs to be an array. That line should output just 1 # per line

[WideBoyDixon]

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:

Please Login or Register  to view this content.

But it returns 5.251026 as the answer so perhaps it's not right?

WBD