Home > Forum Home > Building Market Trading Systems > Downloading Market Data For Free > Issues with query tables Share

Issues with query tables

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


Forum TopicLogin

Issues With Query Tables

Rate this:
(3/5 from 1 vote)
Confused 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 on
 
View Full Post

Find relevant Excel templates and add-ins for Issues with query tables in the