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.
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. M