I have been asked by a user to look at some VBA code that he has in a spreadsheet for him as he keeps getting out of memory error's
Now i have looked at the code and as far as i can see it's use of Massive nested loops is part of the problem.
Unfotunatley i don't fully understand what he is trying to do, i believe that it is a system to predict future prices by taking an initial price and by using a calculation & a random factor produce 3 new numbers on the next level so you build up a tree like structure of prices. This continues on down 100 times until a future price can be predicted, through an averaging of values.
The code in the attached spreadsheet (zipped up) will give you a clearer idea of what he is trying to achieve !
Now can anybody think of a more memory efficient way of doing this ?? as i am a little lost.
Reply With Quote