Excel VBA Models Combo Set

Excel VBA Models Combo Set has been in the Internet community since 1997. During the past several years, we have developed many Excel VBA models in the academic fields and have helped many students and professionals in learning Excel VBA modeling in finance and statistic through our open source code tutorials.

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.

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.

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.