Program Description

Excel VBA Models Open Source Code Learning Tool - Excel VBA Models Combo Set (Set 1, 2, and 3) The Excel VBA Models Combo Set contains 37 programs in finance, statistics, option pricing models, and numerical methods in open source code. Finance and Statistics Models Set 1. Standard Deviation and Mean 2. Lotto Number Generator 3. Playing Card Probability 4. Normal Distribution Random Number Generator 5. Monte Carlo Integration 6. Black-Scholes Option Pricing Model - European Call and Put 7. Binomial Option Pricing Model 8. Portfolio Optimization 9. Multiple Regression 10. Bootstrap - A Non-Parametric Approach 11. Multivariate Standard Normal Probability Distribution 12. Monte Carlo Simulation 13. Option Greeks Based on Black-Scholes Option Pricing Model Random Numbers Generator and Statistics Set 14. Log Normal Distribution 15. Log Pearson Type III Distribution 16. Normal Distribution 17. Chi-Square Distribution 18. F-Distribution 19. Student-T Distribution 20. Multivariate Standard Normal Distribution 21. Gamma Distribution 22. Beta Distribution 23. Hypergeometric Distribution 24. Triangular Distribution 25. Binomial Distribution Numerical Searching Methods and Option Pricing Set 26. Numerical Searching Method - Newton-Ralphson 27. Numerical Searching Method - Secant Method 28. Implied Standard Deviation For Black/Scholes Call - Newton Approach 29. Implied Standard Deviation For Black/Scholes Call - Secant Approach 30. Implied Standard Deviation For Black/Scholes Call - Bisection Approach 31. Implied Standard Deviation For Black/Scholes Put - Newton Approach 32. Implied Standard Deviation For Black/Scholes Put - Secant Approach 33. Implied Standard Deviation For Black/Scholes Put - Bisection Approach 34. European Option Model on Asset with Known Cash Payouts 35. Index Option 36. Option on Currency 37. Option on Futures