RiskAMP Mersenne Twister Add-in for Excel (MTRand)
Our Monte Carlo add-in uses an internal psuedorandom number generator based on the Mersenne Twister algorithm (see http://www.math.sci.hiroshima-u.ac.jp/~m-mat/MT/emt.html).
Many people have expressed an interest in using this generator as a separate add-in, for a variety of purposes. We're happy to offer this add-in as a free, open-source software download.
The MTRand add-in adds a single new function to Excel: MTRAND. This function can be used as a replacement for the existing Excel RAND function. The MTRAND function uses the Mersenne Twister pseudorandom number generator algorithm, which is superior to the built-in Excel RAND function for most purposes.
Download and use of this add-in is subject to license, as described below. To use the add-in, just download the first package below. If you want to modify or rebuild the add-in, you can download source and build files.
Download the Add-in: MTRand-distrib-1.0.zip
Download source and build files (VS.NET): MTRand-src-1.0.zip
Installation
To install the add-in, download the distribution folder (above) to your computer. Unzip the directory and record the location of the unzipped "MTRand.xll" file. Then activate the add-in in Excel, as described below.
Excel 2003: Start Excel and open the menu Tools -> Add-ins. Click "Browse" and select the MTRand.xll file.
Excel 2007: Click the "Office" button (the round button at the top-left corner). Click the "Excel Options" button at the bottom of the dialog. In the next dialog, select "Add-ins" from the list at the left. Select "Manage Excel Add-ins" at the bottom and click "Go". In the next dialog box, click "Browse" and select the MTRand.xll file.
Source & License Terms
The Add-in code is copyright (c) 2007 Structured Data, LLC. Source code is provided under the BSD license, and is subject to all terms and conditions of that license. See the file LICENSE.txt in the source download folder for details.
The underlying code for the Mersenne Twister algorithm is copyright (c) 2006, 2007 Mutsuo Saito, Makoto Matsumoto and Hiroshima University, and is provided subject to terms of license. See the file MT-LICENSE.txt in the source download folder for details and license restrictions.
Help & Support
Because this is a free download we can't provide support for the MTRand add-in. However you're welcome to use our support forum, and we will answer any questions that we can.