|
PureBytes Links
Trading Reference Links
|
I emailed S&P directly. They indicate sometime in May before they have
constituent lists back up.
I have also asked for the lists to be available in ".csv" format rather
than just ".xls"
Constituent lists are already available for download for US market in
both ".csv" & ".xls".
Just have to play the waiting game for ASX.......
ATB
Michael.
P.S I don't use Excel. So Im not sure such add-in would work. But thanks
for the info.
Randy Harmelink wrote:
>
> 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/
> <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,
> <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
> <mailto:OzFalconAB%40bden.org>> 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/
|