P psxx New Member Jun 1, 2020 #1 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
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 B4X founder Staff member Licensed User Longtime User Jun 1, 2020 #2 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) Upvote 0
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)
P psxx New Member Jun 2, 2020 #3 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 Upvote 0
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
