|
PureBytes Links
Trading Reference Links
|
Actually, having looked at it a bit more, the simple copy and paste
doesn't seem to work well, as the data isn't properly parsed.
DanG
Gary Funck wrote:
>
> > -----Original Message-----
> > From: DanC [mailto:danc@xxxxxxxxxxxx]
> > Sent: Sunday, July 14, 2002 10:14 AM
> > To: realtraders@xxxxxxxxxxxxxxx
> > Subject: Re: [RT] s&p 500 list of stocks with capitalization
> >
> >
> > Does anyone have any suggestions how to get the component data of an
> > index into a
> > spreadsheet from the below link?
> >
> > Dan
> >
> > Gary Funck wrote:
> >
> > >
> > > Here's a handy index component listing:
> > > http://www.cboe.com/OptProd/index_comp.asp
> >
>
> "Select All", "Copy", "Paste" should work fine.
>
> More elegant, is "Data","External Data","New Web Query" then select "Get tables
> only" (the default), and then in "Browse ..." dialog past in the URL. Click
> "OK", wait a bit, and voila, you've got your data (this is Excel 2000 and up).
>
>
> To unsubscribe from this group, send an email to:
> realtraders-unsubscribe@xxxxxxxxxxxxxxx
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Save on REALTOR Fees
http://us.click.yahoo.com/Xw80LD/h1ZEAA/Ey.GAA/zMEolB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
realtraders-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|