Hi,
So I have a model for a stock price, and it has many inputs. What I want to do is test all the different scenarios (ie a monte carlo simulation)
The inputs are in Cells A1:A5 - each one I have limits to stress to (ie A1 between 5 and 10 etc) - then I would like to copy and paste the results (results A10:15) - I would like 100 different iterations where we randomly select a input for each variable within the stated parameters
I have little VB experience so may be a daft question, but is this something VB can handle or need a more powerful tool?
So I have a model for a stock price, and it has many inputs. What I want to do is test all the different scenarios (ie a monte carlo simulation)
The inputs are in Cells A1:A5 - each one I have limits to stress to (ie A1 between 5 and 10 etc) - then I would like to copy and paste the results (results A10:15) - I would like 100 different iterations where we randomly select a input for each variable within the stated parameters
I have little VB experience so may be a daft question, but is this something VB can handle or need a more powerful tool?