You can speed that spreadsheet up significantly. As coded, you are using the RCHGetYahooQuotes() function to get each data item individually. That means you are going to the Internet 3200 times to grab a piece of data. Yahoo has a limit of 200 tickers per request, so you could array-enter the formula twice to get all the data for the 400 companies.
For example, I array-entered this formula over range F3:M202 to grab the data for the first 200 companies: =RCHGetYahooQuotes(A3:A202,"ohgl1pb3b2a2") On 9/3/07, Don Lindberg <[EMAIL PROTECTED]> wrote: > > Lionel, > > I don't know if you are aware of the smf_addin forum on Yahoo Groups. > This is a VERY useful add-in for Excel, allowing you to pull all sorts of > stock information from various stock web sites ( Yahoo, MSN, Morningstar, > Reuters and more.) If you are not already using this fine add-in I suggest > you check it out. I have attached a spreadsheet of the Barron's 400 that > gives Exchange Membership, Sector/Industry Membership, and full quotation > information. Be advised that you must first install the smf_addin before > you can use this spreadsheet otherwise most of the cells will return errors. > Hope you find this useful. >
