vbnumericalmethods.com | free excel vba finance and math code, downloads, addins and examples.
VB Numerical Methods - Excel VBA Finance and Math Code
HOME FINANCE VBA MATH VBA BOOKS CONTACT
  Search Site :  

PURPOSE

Download well written EXCEL VBA code, for finance and mathematical applications. This site is designed for practitioners, researchers, and students as a tool for programming in EXCEL VBA. Users of this site can search for commonly used finance or math code, post their own code and participate in the VB Numerical Methods discussion Forum.



SUBMITTING CODE AND DEVELOPMENT

If you are looking for a specific finance or math VBA program you can email me and I will help you develop the code. Also, if you have any interesting EXCEL, EXCEL VBA or VB finance or math applications please email them to me and I will post them on the website. I will post the code, your name or alias and your email address (optional) on the site. My email address is greg@vbnum.com.


BOOK

Book on Amazon.com Option Pricing Models and Volatility Using Excel-VBA
A practical guide to implementing advanced option pricing models and stochastic volatility using Excel/VBA

This book offers practitioners the tools and techniques needed to use advanced models for pricing options and obtaining volatility. Divided into three comprehensive parts, Option Pricing Models and Volatility Using Excel/VBA describes cutting-edge option pricing formulas and stochastic volatility models. This book also includes a CD-ROM that contains Excel spreadsheets and VBA functions to implement all of the models presented in the book. Accessible and informative, Option Pricing Models and Volatility Using Excel/VBA is the perfect guide for those who realize the value of more advanced models and want to understand the math behind them.




NEWS - (see all news)

FINE 448 - Derivatives and Risk Management - (posted: 2006-01-23 10:32:32.0)

Updated Course content for the winter 2006 term. Click Here


Random Processes - (posted: 2005-10-11 00:00:50.0)

This is the follow up update to the addition of the various distribution random number generators last month. Code for the simulation of the random processes employing these random number generators has been added. Brownian process, CIR process, Poisson process, Log Normal Stock process, Compound Poisson process, Levy process, Exponential Levy process, NIG process, Gamma process, VG process, Brownian Brdge.


VBNUM.com - (posted: 2005-09-06 23:47:06.0)

I finally registered an easier domain name for people to browse. You can now come to vbnumericalmethods.com by typing www.vbnum.com, I saved us 13 characters!


Many Distribution Codes Added - (posted: 2005-07-20 01:16:10.0)

There has been alot of demand for mathematical distribution functions to be added to the site. Jack a long time vbnumericalmethods.com user has submitted a varietry of such functions. Check out the math section for the many different random number generators that have been added. Guassian, Inverse Guass, Normal Inverse Guass, Beta, Poisson, Gamma, Variance Gamma and Exponential Distribution Random Number Generators


OLS Regression - (posted: 2005-01-07 23:32:47.0)

Many users have been asking for code that does OLS regression. I wrote a function that does multivariate OLS regression and included it in an excel file in the math section. I will be making additions to the function such as calculation of t-stats, returning the error terms, etc. In the mean time any contributions or suggestions will be appreciated. Math Excel VBA codes, addins and examples


Navigate: Home, Finance VBA, Math VBA, Books, Finance and Math VBA Links, Contact
Interesting Links: Add-ins, Excel Best Practices, Anthony VBA, Excel Business Templates, Spinnaker Add-ins