OK, I see what you mean, I should do the same thing then. I am currently downloading data from Bloomberg machine, there is a script that would automatically extract data from Bloomberg. I get data for Bonds, Currencies, ETF, Futures and Mut.Funds. Now the Bloomberg subscription is expiring in a couple of months and there is no plans on renewing the subscription, so I will have to get ready for new data source. I just need EOD data. I don't think I would have problems getting ETF data from yahoo as long as the ticker is supported by Yahoo. The problem was more with stocks, since everyday there might be possiblity of stocks getting deleted/added to AMEX,NYSE and Nasdaq. I gues your method of extracting data would be sufficient for me, I just need to automate the whole process. Base on your experience, when would be the best time to run the process, would it be early morning the next day or night time after trading? Did you get pretty realiable data from Yahoo? I will try this method before considering paid data provider, and see how far I can go with yahoo.
Thanks again Jim... ;) Gary. --- In [EMAIL PROTECTED], "jrswindle2001" <[EMAIL PROTECTED]> wrote: > > Hi Gary, > > I use an old Visual Basic 6 program to start at the top level > (sectors) and get all of them. Then scan through those getting all the > industries. Then scanning through that list and getting all the > symbols. Finally scanning that list to get all the data for the > symbols. So a total of 3 passes and parsing data from the Yahoo web > pages on each pass. And yes, it is all Yahoo data. > > What kind of list of US Stocks are you looking for? Are you looking > for each and every US Stock? Quite a bit there I would imagine, and > no, no idea where it would be. > > Good luck! > > Jim > > --- In [EMAIL PROTECTED], "Gary" <ghost200_2000@> wrote: > > > > Jim, > > > > I have a question for you, how did you pull the list of tickers (US > > traded) from yahoo? and how did you pull the industries/sectors info? > > All this data is from Yahoo? I am curious... > > Let me know if there is any website that allows you to get list of > > tickers for US traded stocks for free... > > > > Thanks, > > Gary > > > > --- In [EMAIL PROTECTED], "jrswindle2001" <jr.ab@> wrote: > > > > > > Thanks Nick! > > > > > > --- In [EMAIL PROTECTED], Nick Busigin <nick@> wrote: > > > > > > > > On Sat, 7 Apr 2007, jrswindle2001 wrote: > > > > > > > > > If anyone is interested, I have posted a new AB blank database > > > (stocks) > > > > > on my website. Data is effective as of 04/05/2007 > > > > > > > > > > http://www.icc-az.com/Update-AB.html > > > > > > > > > > It is setup for the Yahoo down-loader, US-Stocks.zip > > > > > > > > Thanks once again Jim!!! > > > > > > > > Nick > > > > > > > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=- > > =-=-= > > > > Help fight the war against Spam; > > > > Erase all addresses before forwarding any item of email. > > > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=- > > =-=-= > > > > > > > > > >