UnThreaded | Threaded | Whole Thread (6) | Ignore Thread Prev | Next
Author: ProbTrader Two stars, 250 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 260  
Subject: Re: Custom fields based on industry medians Date: 1/5/2005 10:47 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
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.
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (6) | Ignore Thread Prev | Next

Announcements

Pencils of Promise - Back to School Drive
"Pencils of Promise works with communities across the globe to build schools and create programs that provide education opportunities for children."
Managing Your Wealth
Our own TMFHockeypop from Rule Your Retirement fame on the TV show Managing Your Wealth.
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.
Post of the Day:
Apple

The Saddest Place on iPhone Day
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and "#1 Media Company to Work For" (BusinessInsider 2011)! 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.
Advertisement