Excel VBA Models Combo Set (Set 1, 2, and 3)

Are you having difficulty understanding how to do option pricing modesl and numerical procedures within Excel? Do you want to see practical examples? The The Excel VBA Models Combo Set solves these problems. It contains practical and well explained examples of:



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. European Option Model on Asset with Continuous Cash Payouts (Index Option)

36. European Option Model on Currency

37. European Option Model on Futures