Re: [amibroker] S&P Website (.xls constituants list)

["Randy Harmelink" <rharmelink@xxxxxxxxx>]

I have a free open-source add-in that can grab the information off the
web pages for you, using formulas in EXCEL.  The add-in, documentation
on its functions, and sample templates can be found in the files area
of this Yahoo group:

http://finance.groups.yahoo.com/group/smf_addin/

For example, the following function grabs one table cell off the S&P web page:

=RCHGetTableCell("http://www2.standardandpoors.com/portal/site/sp/en/au/page.topic/indices_asx200/2,3,2,8,0,0,0,0,0,0,3,0,"&$A3&",0,0,0.html",C$1,";>Sector",,,,$B3)

...where:

-- Cell A3 contains the page number (varies from 1 to 5 for the ASX S&P 200)
-- Cell C1 contains the column number of the table to extract
(1=ticker symbol, 2=Company name, ..., 6=Price)
-- Cell B3 contains the row number of the table to extract the data
from (varies from 1 to 50 on the first 4 pages of the ASX S&P 200, but
the 5th page only has data on the first row)

I was able to construct a table within EXCEL to grab the data using
the formula above.

On 4/2/07, Michael.S.G. <OzFalconAB@xxxxxxxx> wrote:
>
> I have noticed the S&P website has changed.
> Now S&P appears to only have the data in web pages now, and I am unable to download
> the ASX S&P 200 (etc) in .xls format.
>
>  Anyone know if S&P lists can still be downloaded in .xls format from the S&P website??


Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/