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.|