Excel VBA Models Combo Set (Set 1- 2- and 3) Description:

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