Lionel, Go to the Files section of the smf_addin group, and grab all the documentation files. All the answers are there, although it occasionally requires a little digging.
Donald F Lindberg _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lionel Issen Sent: Tuesday, September 04, 2007 2:17 PM To: [email protected] Subject: RE: [quotes-plus] FW: Barron's new B400 index Where do I find out about these commands like =RCHGetYahooQuotes(A3:A202,"ohgl1pb3b2a2") to access Yahoo Quotes? Lionel From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Randy Harmelink Sent: Tuesday, September 04, 2007 1:41 PM 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] <mailto:[EMAIL PROTECTED]> net> 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.
