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
Keywords:
Excel VBA
Open Source Code
Finance
Numerical Searching
Option Pricing
Portfolio Optimization
Regression
Multivariate Distribution
Monte Carlo Simulation
Option Greeks
Random Numbers Generator
Implied Volatility
Gamma
Beta
Log Normal
|
