B4J Question Equivalent to the Excel-Function NORMSDIST

[psxx]

Good morning from sunny germany,

i am an Excel-Developer vor many years and recently came to B4X.
My goal for today is to write an option-price-calculator.
This tool already exists in an Excel workbook. During the calculation in Excel i need values for the distribution function of the standardized normal distribution.
Excel provides the function NORMSDIST.
Do you have any idea for an equivalent function or implementation in B4X?

Thanks very much for your help and your time
Peter

 

[Erel]

Do you want to calculate the cumulative value?

Should be quite simple to port this code: https://stackoverflow.com/a/31901186/971547 (not that I tested it and can say for sure that it is correct)

 

[psxx]

Hi Erel,
thanks for your quick answer.
I implemented it with the use of tabulated data in an array ... but your link leads to a much better solution.
So i will change it to this ...
Thanks for your help and your wonderful tool
Peter