+ Reply to Thread
Results 1 to 3 of 3

VBA Code for Montecarlo Simulation

  1. #1
    Rafaga
    Guest

    VBA Code for Montecarlo Simulation

    I would like to set up a spreadsheet intended for Montecarlo simulations to
    iterate a number of times (say 1000), while saving the frequency of each
    outcome on a separate table or graph. I know that pressing F9 recalculates
    the spreadsheet, generating a new outcome each time. What would the VBA code
    look like for this routine?



  2. #2
    David J. Braden
    Guest

    Re: VBA Code for Montecarlo Simulation

    Rafage-
    Save a lot of hassle by using the free add-in PopTools, which
    incidentally includes a superb rng (current state of the art for MS sims).

    Dave Braden

    Rafaga wrote:
    > I would like to set up a spreadsheet intended for Montecarlo simulations to
    > iterate a number of times (say 1000), while saving the frequency of each
    > outcome on a separate table or graph. I know that pressing F9 recalculates
    > the spreadsheet, generating a new outcome each time. What would the VBA code
    > look like for this routine?
    >
    >


    --
    Please keep response(s) solely within this thread.

  3. #3
    Rafaga
    Guest

    Re: VBA Code for Montecarlo Simulation

    Thank you, David!. I will try it.

    Best regards,

    Rafaga.

    =====================================
    "David J. Braden" <dbraden@nomail.invalid> wrote in message
    news:ODoQ3E2eGHA.1456@TK2MSFTNGP04.phx.gbl...
    > Rafage-
    > Save a lot of hassle by using the free add-in PopTools, which incidentally
    > includes a superb rng (current state of the art for MS sims).
    >
    > Dave Braden
    >
    > Rafaga wrote:
    >> I would like to set up a spreadsheet intended for Montecarlo simulations
    >> to iterate a number of times (say 1000), while saving the frequency of
    >> each outcome on a separate table or graph. I know that pressing F9
    >> recalculates the spreadsheet, generating a new outcome each time. What
    >> would the VBA code look like for this routine?

    >
    > --
    > Please keep response(s) solely within this thread.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1