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?
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
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
2
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
2
bumping back up as hoping someone out thee has some idea on where to start
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,803
Messages
5,513,506
Members
408,954
Latest member
Tiaame

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top