tommych - I doubt that this spreadsheet would run in Open Office because it uses sophisticated macros that I highly doubt would transfer over to Open Office.

You know what's funny is that I first found this Excel Spreadsheet about 3 weeks ago, but with all the new baby stuff, I forget to post it.  Anyway at the time the spreadsheet was projecting the market to drop for a 2 - 3 more weeks and it got it right LOL.  Again maybe it's coincidence, but it's fun to play around with.  Now it's projecting a bottom soon, so we'll see.  Again it's a fund tool.

Anyway I would love to be able to modify the spreadsheet to test larger amounts of time instead of being locked into the recent 25 days.  We know that the market cycles tend to repeat and move in very similar fashions over the years, why, because markets trade on the collective emotion the masses i.e. greed and fear, and human emotions never change.  No matter how much our technology grows, we are still an emotional species governed by our emotion, thus market cycles (bull/bear) etc tend to repeat in similar patterns over decades and decades.  

Therefore if there are any 'Excel Gods' here, it would be neat to be able to change the time variable i.e instead of testing for the last 25 days, add an input variable so that we can test for similar time frames of 2 months or 3 months or a year etc. 

It would be nice for example to have all the daily close data for the Dow Jones going back to 1920 where you could scan that whole time frame and find months or years where the market traded in a similar fashion, not just the last 25 days.  History doesn't repeat exactly in the stock market, but sometimes it's very close. 

Anyway it might not amount to anything, but it would be fun to test.  However I would use it for other things and analysis, for example I could test say Gold metal and say hey notice that gold or silver is trading just how it did in 1978 etc.