C
cor
hi all
i'm running a montecarlo simulation on excel 97. my workbook has 10
sheets with different annual strategies of portfolio insurance. in the
first sheet there is the random stock process, which is copied in the
other sheets (simply with the formula =sheet1!cell1 in every cells).
instead of normsinv i'm using a vba code for the inverse cumulative
function. the last sheet is the output sheet, where i collect three
results for every strategies (so for 1000 simulations i should get
30.000 data). this is done via vba code (calculate and copy the data
in every sheets in the output one).
using my celeron 700mhz notebook it takes 5 min. for 2 steps
simulation. for a 100 steps simulation it should take 4 hours, but the
computer crashes. when i save a change in a cell or a formula, it
takes minutes!
any suggestions for modifying the workbook? is there a way to speed up
the calculations? should i use newer excel (2000 or 2002)? or use a
pentium 3-4 computer?
thanks in advance
i'm running a montecarlo simulation on excel 97. my workbook has 10
sheets with different annual strategies of portfolio insurance. in the
first sheet there is the random stock process, which is copied in the
other sheets (simply with the formula =sheet1!cell1 in every cells).
instead of normsinv i'm using a vba code for the inverse cumulative
function. the last sheet is the output sheet, where i collect three
results for every strategies (so for 1000 simulations i should get
30.000 data). this is done via vba code (calculate and copy the data
in every sheets in the output one).
using my celeron 700mhz notebook it takes 5 min. for 2 steps
simulation. for a 100 steps simulation it should take 4 hours, but the
computer crashes. when i save a change in a cell or a formula, it
takes minutes!
any suggestions for modifying the workbook? is there a way to speed up
the calculations? should i use newer excel (2000 or 2002)? or use a
pentium 3-4 computer?
thanks in advance