Issues With Query Tables: Downloading Market Data For Free Excel help response (13 Sep 2007)

To get right to the point here I've wirtten a routine, nearly exactly what you show below, to grab data from yahoo finance. I list a number of stock sybmols on a worksheet, the routine goes and gets finance data on those symbols from yahoo finance and places them onto a worksheet so I can compare the finanancials in a given industry grou, sector, or between stocks I'm looking at...it depends whats in the list. It works great except for a small little problem.

My querytables are not consistent in returning data. For example, if I create a list of stock symbols which are the same, say SLB, and list, oh say 30 of the same symbol, I may get 95% of my data. I've created an error handler to grab the errors and you would think I would get the same error but it don't. Sometimes it's error 438 or 1004 or something else.

This is driving me nuts. Each time I have the routine grab a list of stocks it returns the correct info but doesn't always grab all of it. It's almost like the routine is grabbing the data too fast and Excel can't keep up.

Have you had experience with this or know a fix? If you would like me to submit my code I'm more than happy to do that too.

Thanks.

Paul

Issues with query tables

Excel Help for Issues With Query Tables in Building Market Trading Systems

Issues With Query Tables

	To get right to the point here I've wirtten a routine, nearly exactly what you show below, to grab data from yahoo finance. I list a number of stock sybmols on a worksheet, the routine goes and gets finance data on those symbols from yahoo finance and places them onto a worksheet so I can compare the finanancials in a given industry grou, sector, or between stocks I'm looking at...it depends whats in the list. It works great except for a small little problem. My querytables are not consistent in returning data. For example, if I create a list of stock symbols which are the same, say SLB, and list, oh say 30 of the same symbol, I may get 95% of my data. I've created an error handler to grab the errors and you would think I would get the same error but it don't. Sometimes it's error 438 or 1004 or something else. This is driving me nuts. Each time I have the routine grab a list of stocks it returns the correct info but doesn't always grab all of it. It's almost like the routine is grabbing the data too fast and Excel can't keep up. Have you had experience with this or know a fix? If you would like me to submit my code I'm more than happy to do that too. Thanks. Paul
	Posted by seegerp on 13 Sep 2007