 |
Excel VBA Models Set 1 XL-VBA1.0
Excel VBA Models with Open Source Code:
1. Standard Deviation and Mean
2. Lotto Number Generator
3. Playing Card Probability
4. Normal Random Number
5. Monte Carlo Integration
6. Black-Scholes Option Pricing Model
7. Binomial Option Pricing Model
8. Portfolio Optimization
9. Multiple Regression
10. Bootstrap
11. Multivariate Standard Normal Distribution
12. Monte Carlo Simulation
13.Option Greeks Based on Black-Schol
excel vba, open source code, finance, statistics, model, lotto number, probability, normal distribution, option pricing, portfolio optimization, |
 |
Excel VBA Models Combo Set XL-VBA4 1.0
The Excel VBA Models Open Source Code Combo Set contains 37 programs in finance, statistics, option pricing models, and numerical methods in open source code. Programs include Distribution 12 Random Number Generator, 6 Option Pricing Models, 3 Numerical Searching Methods, Implied Standard Deviation, Portfolio Optimization, Multiple Regression, Bootstrap, Monte Carlo Simulation, option greeks and more....
excel vba, open source code, finance, numerical searching, option pricing, portfolio optimization, regression, multivariate distribution, monte carlo simulation, option greeks, |
 |
Excel VBA Models Set 2 XL-VBA2.0
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.
1.Log Normal
2. Log Pearson Type III
3. Normal
4. Chi-Square
5. F
6. Student-T
7. Multivariate Standard Normal
8. Gamma
9. Beta
9. Beta
10. Hypergeometric
11. Triangular
12. Binomial
excel vba, open source code, statistics, random number, log normal, log pearson type iii, normal, chi-square, f-distribution, student-t distribution, |
 |
Excel VBA Models Set 3 XL-VBA3.0
Excel VBA Models Open Source Code Learning Tool - Numerical Methods and Option Pricing Set 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.
excel vba, open source code, finance, math, numerical searching method, newton-raphson, secant method, implied standard deviation, bisection approach, black-scholes option pricing model, |
|
