I've made a workbook which uses previously generated strings of random numbers to produce normal distributedf und performance returns based on a specified std dev and mean - this gives me a stochastic run of performance every month for 120 years. Annual Fees are then calculated from these returns and charts are produced of these fees. In order to show the 'average' fees for a given return/std dev and fee structure, I basically run the sheet 250 times and each time output a value onto a worksheet, then chart from this range. I also produce a fee surface for defined volatilities and returns (there are 600 points on this surface, each an average of 30 stochastic runs). When I time how long the sheets take to calculate, I get the following (for 100 runs)
Front 0.03125
Generated Performance 0.046875
Data 0.375
Complex Fee Data 0.03125
Fee Runs 0.1875
And when I F9, the workbook recalculates quickly. But when I run my macros to produce the monte-carlo outputs, it takes ages!. For example, here is my code for the 'average' performance at a given return/std dev:
Given this code only requires recalculating 250 times why does this take 5 minutes?
And my code ofr the fee surface:
Can I make this faster by changing my code? Or is the issue in my formulae?
Thanks!
Bookmarks