Anthony's Excel VBA Page - Product Examples

Copyright (c)
Anthony Sun
All Rights Reserved.

Chi-Square Distribution Random Number Generator

Please read the terms of use before proceeding

Table of Content for the Package Sets

F Distribution Random Number Generator

Student-T Distribution Random Number Generator

Lognormal Distribution Random Number Generator

Log Pearson III Distribution Random Number Generator

Numerical Searching Method - Newton-Ralphson Approach

Normal Distribution Random Number Generator

Numerical Searching Method - Secant Approach

Implied Volatility on Black/Scholes Call - Newton Approach

Implied Volatility on Black/Scholes Call - Secant Approach

Random Numbers Generators (Package Set 2)

Numerical Search Precedures and Option Pricing (Package Set 3)

Standard Deviation and Mean

Lotto Number Generator

Playing Card Probability

Monte Carlo Integration

Normal Distribution Random Number Generator

Black-Scholes Option Pricing Model - European Call and Put *

Binomial Option Pricing Model

Portfolio Optimization

Multiple Regression

Bootstrap - A Non-Parametric Approach

Multivariate Standard Normal Probability Distribution

Monte Carlo Simulation

Finance, Statistics, and Mathematics (Package Set 1)

open source codes

open source codes

Advanced Excel VBA Examples

This section contains the table of content of the package sets. Complete program (with open source codes) for each of these advanced examples are available for purchase.

Option Greeks Based on Black-Scholes Option Pricing Model *

Black-Scholes Option Pricing Model - European Call and Put *

Option Greeks Based on Black-Scholes Option Pricing Model *

* Files available in both Set 1 and Set 3

* Files available in both Set 1 and Set 3

Multivariate Standard Normal Distribution Random Number Generator

European Option on Asset With Known Cash Dividends

European Option on Asset With Continuous Cash Dividends (Index Option)

European Option on Futures (Forwards)

European Option on Currency

Implied Volatility on Black/Scholes Put - Newton Approach

Implied Volatility on Black/Scholes Put - Secant Approach

Free Samples for Download

open source codes

Monte Carlo Integration

Option Greeks Based on Black-Scholes Option Pricing Model

Lotto Number Generator

Normal Distribution Random Number Generator

Gamma Distribution Random Number Generator

Hypergeometric Distribution Random Number Generator

Triangular Distribution Random Number Generator

Beta Distribution Random Number Generator

Binomial Distribution Random Number Generator

Implied Volatility on Black/Scholes Call - Bisection Approach

Implied Volatility on Black/Scholes Put - Bisection Approach

Excel Consultancy Services