LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Bootstrapping in Excel

Hey guys,

I'm pretty much brand new to VBA and I'm trying to figure out how to
bootstrap in Excel and run around 10,000 simulations. I'd like to do
it without using @Risk or Monte Carlo.

I have a macro now that essentially simulates one set of data, copies
it into another cell, and repeats a specified amount of times. But
since the end of the macro tells it to rerun the macro, the macro
returns an "out of stack space" error after 188 simulations.

Is there any way to get around this or to run simulations in Excel
without using MC or @Risk?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"