For those of your interested, I made a simple macro in Excel that will weed out stocks from the final universe that do not meet the float, avg volume, EPS, and price constraints that Spydertrader mentions. I am not sure who wrote the original macro ("fetch yahoo"), so I am not sure who to credit other than Spydertrader for sending it to me.
The macro fetches, from Yahoo.com, the relevant data for a list of symbols you can easily cut & paste from the stocktables.com excel download and hides any rows that fail the test. You can also change the criteria; for example, I currently use 150,000 avg daily volume constraint instead of 200,000 like Spydertrader, as my account is smaller and consequently, so is my trade size. You can change this to whatever you need. The input areas are generally in yellow.
Once you input the list of symbols into the first sheet called "Watch List", you hit the "Fill" button and it will automatically download all the data you need. I had to separate the "Float" tab because Yahoo displays the Float with commas which causes problems when delimiting.
Finally, click the "Hide" button, and only the stocks that meet all the criteria will be displayed. You can highlight the symbols and copy them directly into a Wealth Lab watchlist on the website or in Wealth Lab Developer. The cool thing is it the copy will ignore any hidden rows, so you only paste the symbols you need.
I have input the list of symbols directly from Stocktables.com for 4/26/05, sorted by symbol and by 90 RS and EPS %'s. All you have to do at this point is click "Fill" then "Hide". You can also unhide to see the list again and clear the entire list as well.
Feel free to modify, delete, or otherwise manipulate the spreadsheet. I would be interested in any improvements that are made.
I hope this cuts down on some of your prep time.
smtrader