Excel VBA Models Open Source Code Learning Tool -
Finance and Statistics Models Set

Are you having difficulty understanding how to do
finance and statistics within Excel? Do you want to
see practical examples? The Financial and Statistics
Model 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

Download (433 KB) Website Link to this page