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

Download (975 KB) Website Link to this page