The update fixes a precision error that affects some users when using the beta distribution in Latin Hypercube Sampling (LHS). This update only affects users of the Professional Edition. We encourage all users to download the update.

Stability and performance improvements resolve a potential crash error when opening files created with Excel 2000 in Excel 2007, and increase simulation speed when running large spreadsheet models.

Quick View and Correlation

There’s a unified context menu to clean up the interface:

RiskAMP Tools context menu

To install the Tools package, download the installer:

RiskAMPTools.exe (550k)

If you’ve installed an earlier release of the RiskAMP Tools package, please remove that first. You can remove it from Add/Remove program in the Control Panel.

Please let us know what you think! Send any comments or questions to info@riskamp.com.

Better Productivity:

RiskAMP CS frees up your desktop to keep working while the cluster handles intensive calculations.

Faster Decision-making:

The faster you get results, the better informed you’ll be in making time-sensitive decisions.

Greater Certainty:

With RiskAMP CS you can run larger and more complex simulations in less time.

RiskAMP CS: All the features of RiskAMP with the power of High Performance Computing.

For more information, visit our RiskAMP CS page.

Before that release, we’d like to invite you to try out an early version of some of the new tools. This pre-release will work with recent versions of the RiskAMP Professional Edition.

This release of the RiskAMP Tools adds a context menu to Excel. When you right-click on a cell, you’ll have the new option to insert a random distribution function. Click on this menu item, and you’ll see the new distribution selection box:

From here, you’ll be able to easily select from a few distributions, and see exactly what you’re going to get. You can compare the Beta-PERT and triangular distributions, for example, or see the effect of limiting a normal distribution.

We’re excited about these new tools and we’re happy to share them with you. But please understand, this is a pre-release, and there may still be a few bugs. If you do try the RiskAMP Tools package, send us a note at info@riskamp.com and tell us what you think.

Download the RiskAMP Tools Pre-release (exe file, 600k)

If you’d like to try it out, you should have a recent version of the Professional Version installed. The tools package works with Excel 2003 and Excel 2007. To remove the tools add-in, use Add/Remove programs from the Control Panel.

It is possible to do this using some VBA code, but it’s not as easy to use as Goalseek. To make it easier to run this kind of analysis, we’ve put together a simple point-and-click linear optimizer for running simulations. The package and a more complete description are available from our library page:

Optimizing Simulation Variables

This is an early release and may contain some bugs. Please save your work before installing or running the optimizer! If you have any comments or questions about the optimizer, please let us know.

The most recent updates to the add-in include a number of performance improvements, which should speed up slow simulations, particularly on Excel 2007 and Vista. We recommend upgrading if you’re using Excel 2000/2003 or Windows XP as well.

The latest version of the RiskAMP Add-in has been updated so it’s now possible to use Goalseek within a simulation. To try it out, you should make sure you have the most recent version of the Add-in installed (version 2.80); you can download updates from our download page.

Using Goalseek within a simulation requires VBA, so you will need to know something about VBA programming. For the most part, this is fairly simple, and actually scripting Goalseek to run is fairly simple if you record a macro.

We’ve posted a very simple example of using Goalseek and a Monte Carlo simulation on our library page:

Excel 2000/2003 Version (.xls)
Excel 2007 Version (.xlsm)

You should download the file that matches your version of Excel.

This spreadsheet runs a Monte Carlo simulation from VBA, and at each iteration it runs Goalseek to solve a simple problem on the spreadsheet. To run the simulation, we use the RiskAMP VBA library (described here). At each iteration, the code runs Goalseek using this code:

Range(”D16″).GoalSeek Goal:=0, ChangingCell:=Range(”C16″)

To figure out that line, we simply recorded a macro and ran Goalseek manually. Using this technique it’s possible to run Goalseek on a spreadsheet and capture the results from a simulation like any other spreadsheet value.

Having a good random number generator can be useful outside of running simulations, however, so we’re happy to provide a simple plug-in that adds this function to Excel. The MTRand add-in adds a single function, MTRand(), which generates a random value.

MTRand Add-in Page

We’re providing the MTRand add-in free of charge, and the source code is available for use or modification. You’re welcome to use the add-in and source code for any purpose, subject to the license terms noted on the page.

Our Professional Edition has added performance and features for power users and large enterprises, including integrated Latin Hypercube Sampling (LHS) and the PERT distribution for modeling expert data.

Maintaining multiple versions means we can continue to provide leading analytics software at a low price, while supporting the needs of power users. Check out the features in each version to figure out which version is right for you.

Trial versions of both the Personal and Professional Edition are available on our downloads page, and our sample spreadsheets work with both versions of the add-in.

• The SimulationTime() function, which can be used to measure simulation running time
• A fix for an error in which Excel 2007 was not detected correctly
• Fixes for two bugs which could cause excel to crash in extreme situations

In addition, this update includes performance improvements for both Excel 2003 and Excel 2007. We recommend that users update at their convenience. The latest version can be downloaded from our website at

http://www.riskamp.com/download.php

For users of Excel 2000, 2002, XP and 2003, the new version includes bug fixes and updates, as well as changes that make the add-in faster and more efficient. We recommend that users upgrade at their convenience.

Download the latest version from our downloads page. If you’d like to find out more about Excel 2007 support, visit our Excel 2007 page.

The chart at right was generated from our retirement portfolio example; it shows the outcomes of 100 simulation trials, overlaid with the mean (green) and 5th and 95th percentile results (yellow). The key to this chart is the SimulationValue function. This function can display the results of any cell at any step of the simulation. In constructing the results table, we use this function to find the value of the portfolio in each year at each of 100 trials.

There are some limitations to these charts. For one thing, Excel is restricted to 255 data sets (rows) per chart; this means you can only display that many trials in a single graph. Creating the tables and manipulating the charts can be time-consuming; in this case, the table contains 100 rows, and we’ve made each line black and smooth. We did this with Excel macros, and we wouldn’t recommend doing it by hand (send us an email if you need help constructing the appropriate macros).

Download the spreadsheet and run it with 100 trials. It can be especially instructive to watch the chart generate (make sure “allow screen updates” is checked when you run the simulation).

Example Spreadsheet

Using this ribbon plug-in with the RiskAMP Add-in, it’s easy to run Monte Carlo simulations in Excel 2007.

Please note that this is for test purposes and early adopters only. In the future, we’ll be releasing a combined add-in that includes the RiskAMP functions and the Office 2007 UI. For now, we’re releasing the ribbon interface as a separate add-in component.

You should only install this add-in if you already have Excel 2007 and the RiskAMP add-in installed. To uninstall the ribbon interface, use Add/Remove programs from the control panel.

RiskAMP Ribbon Menu Installer (exe)
RiskAMP Ribbon Menu Installer (zip)

[Update January 18, 2006] If you’re using Excel 2007, we have a test version of the combined installer ready. Send us a note at info@riskamp.com if you’d like to try it out.

In addition to performance improvements, version 2.10 includes updated examples, minor bugfixes, and a rollup of changes since the 2.00 release. All users are encouraged to upgrade to the latest version at their convenience. To upgrade, simply download the new installer from the download page.

The same problem exists with all add-ins, and it’s just a function of how Excel works. There’s a way to solve it, but it’s sometimes a bit hard to figure out (it doesn’t help that it doesn’t make much sense).

Here’s an example of VB code that opens Excel and then activates all the add-ins. Add a project reference to the Microsoft Excel library, then use this function:

Private Sub Start_Excel()

   Dim xlAddIn As Excel.AddIn
   Dim xlApp As New Excel.Application

   xlApp.Application.Visible = True

   ' for this method to work, a workbook must be
   ' loaded with Open or Add

   xlApp.Workbooks.Add()

   ' loop over all the Add-ins that are set to
   ' "installed", and toggle the flag from True
   ' to False and back again.

   For Each xlAddIn In xlApp.AddIns
      If xlAddIn.Installed Then
         xlAddIn.Installed = False
         xlAddIn.Installed = True
      End If
   Next xlAddIn

End Sub

For this method to work, the RiskAMP Add-in must be already installed, and “checked” in the Excel add-ins menu. But basically, if the Add-in is loaded when you start Excel normally, this code should work to start it via automation.

We’re posting a cleaned-up version of that example here. Basically, it’s a model of an investment portfolio that includes correlation among various asset classes to determine periodic returns.

This example is oversimplified. Among other things, inflation and costs are omitted. Also note that the portfolio is rebalanced in each period (weights in each period always reflect the portfolio targets). Nevertheless, this may be useful in understanding how to apply the correlated return functions.

File: Correlated Asset Portfolio Example

If you have any questions about the model or would like help undestanding the example, please send us an email.