No. of Recommendations: 0
Now, MY assumption is that you are trying, ultimately, to look for contrasts between individual companies and the industry data.

You're correct in your assumption, but the problem is that I need to do this for all industries. My screens are not specific to an industry or a sector. In facts the idea behind these screens is to find discrepancies between every stock in the database and its industry.

Last weekend I tried to extract all the fields I need for one of my screens using the last SIPro data download. It took about 20 minutes to produce a 5MB excel file, and this is just for one screen. On the top of that, I will have to run a filter in Excel to highlight the stocks that pass my criterias.

There's a product called XLQ that access all the AAII fields in Excel but it doesn't iterate through the whole ~7000 stocks set. You have to enter one stock at the time, manually. This product wasn't conceived to work as a filter or a screen editor.

If there's a way to iterate through the AAII stock universe and access all the available fields, then I can implement some code in Excel or another language to produce my screens. I know Keelix from the MI board has developed some code to access the AAII database files directly for his backtester but if there's an easier way please let me know.

Many thanks for your replies.
Print the post  


When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.