How to code this in vba..?

[fata1991]

Under the Binomial Option Pricing method, how would I account for dividend yield within VBA? (not when computing the 'up probability' but when working out the prices for the different nodes.

I can't figure out how I would code it in VBA?

Thanks in advance.

 

[SkipVought]

Sorry, cannot read your mind.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

VBA can handle all sorts of mathematical operations. Check Help. Other than that, we are out in the dark, as Skip implies. We do not even know what application you are talking about.