Skip to ContentSkip to Navigation

Centre of expertise CIBIF

Faculty of Economics and Business
For students

Monte Carlo Simulation in Excel

Using the Data Table function of Excel allows you to do Monte Carlo simulations in a very efficient way. In this youtube video, we show you how to test dynamic asset allocation strategies using using a Monte Carlo simulation experiment in Excel. You can find the Data Table function under "Data", in the main menu. Then select "What-If Analysis", and finally "Data Table".

You can also download the Excel file used in this video.

Last modified:12 November 2018 09.40 a.m.
printView this page in: Nederlands