The Excel VBA Models Combo Set contains 37 programs in finance, statistics, option pricing models, numerical methods, all with open source code.
This Combo Set provides several learning packages with Excel VBA programs that are ready to run. The source code of these Excel files is unprotected for learning purposes. Best of all, the price is very affordable! (Each individual package set is $14.95)
This Combo Set includes the following packages:
Finance and Statistics Models Set (Set 1): 13 different topics in finance and statistics from a simple model such as computing standard deviation and mean to more advanced models such as Monte Carlo simulation, multivariate standard normal distribution, multiple regression, and option pricing models.
Random Number Generator and Statistics Set (Set 2): provides 12 random number generators that allow you to generate histograms from probability distributions given the parameters you have specified. You also have the option to output random numbers from the distribution on the spreadsheet.
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 futures, currencies (foreign exchange), stock indexes, and stocks that pay a known dividend.
Features of Excel VBA Models:
The Excel VBA models are ready to run. Just click the start button and see the simulation runs before your eyes.
An introduction on the model plus explanation on the key points on how VBA code is applied.
Formulas, when applied, are provided to help the users gain a better understanding of the models.
Unprotected open source code. Learn from the code - the best way to learn.
Many customized (user-defined) functions available.