Multiple iterations (Loops)

Wa_Wa

Board Regular
Joined
Jan 19, 2007
Messages
61
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?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,899
Try posting a sample of your data, and what you would like to do with it
 

Wa_Wa

Board Regular
Joined
Jan 19, 2007
Messages
61
Pls see below

What I am trying to do is populate cells B5; B6; B7 and B8 with a number between the max and min (column c and D), recalc and then copy B5:B:12 to F3:M3 (moving the last row down.)
Then repeat - is vba capable of this?


Excel Workbook
ABCDEFGHIJKLM
1
2StyleCallMaxMinStock PriceInterest RateVolaltilyDividendTheo ValueDeltaGammaTheta
3Strike1001000.80%50%0.16%100.50.860.21
4Expiry15/12/2011
5Stock Price1001500
6Interest Rate0.80%1.750
7Volaltily50%25%75%
8Dividend0.16%1%0%
9Theo Value10
10Delta0.5
11Gamma0.86
12Theta0.21
13
Sheet1
 

tommu

New Member
Joined
Jul 30, 2010
Messages
4
this is actually somthing I have been trying to do (no vba experience so finding it v.tough) - so would really love to know if anyone is able to work a solution out.
 

tommu

New Member
Joined
Jul 30, 2010
Messages
4
bumping back up as hoping someone out thee has some idea on where to start
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,043
Messages
5,835,097
Members
430,341
Latest member
kelstnmate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top