Donald: You are correct, but I think that you can copy cells to another row/column and the array formula will not be copied. You can then operate on the new array without worrying about the formulas.
Lionel From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Don Lindberg Sent: Tuesday, September 04, 2007 3:25 PM To: [email protected] Subject: RE: [quotes-plus] FW: Barron's new B400 index Randy, I see the value of the array entry for speed of download, but I want the capability of sorting the data on different columns, and my understanding is Excel doesn't allow you to move cells that make up an array formula. If I am wrong in my assumption please let me know. Donald F Lindberg _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Randy Harmelink Sent: Tuesday, September 04, 2007 11:41 AM To: [email protected] Subject: Re: [quotes-plus] FW: Barron's new B400 index 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.
<<image003.jpg>>
<<image004.jpg>>
