Click to enlarge pictures below:

Download!

Get the Full Version Now!

Excel VBA Models Combo Set 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 (Set 1) contains different topics in finance and statistics from simple model such as computing standard deviation and mean to more advanced models such as Monte Carlo simulation, multivariate standard normail distribution, multiple regression, and option pricing models.

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 (Set 2) provides 12 random numbers generators that allow you to generate histogram from the probability distribution given the parameters you have specified. You also have the option to output random numbers from the distribution on the spreadsheet.

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 (Set 3) contains topics in applying different numerical searching methods to solve mathematical equations and implied volatility from option pricing models. It also includes vanilla option pricing models on future, currency (foreign exchange), stock index, and stock that pays a known dividend.

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!

Get the Full Version Now!