[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [amibroker] Method to Copy Russell files



PureBytes Links

Trading Reference Links

Dave,
 
Thanks for creating these ticker lists and sharing them with us.  Would it
be worthwhile to save them somewhere on the files section?   Any others you
might be interested in?  I would be glad to lend a hand.
 
Dave
 
PS Dingo, thanks for sharing that neat little copy text tool.  I learn
something new each day.
PS Duke,  that was a big time saving tip, thanks.

  _____  

From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf
Of David Fitch
Sent: Saturday, July 22, 2006 6:46 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Method to Copy Russell files


Thanks Fred
That's just about what I was doing which I thought was very labor intensive.
Thought there might be a simpler way. I also do the R1K, R2k, and R Micro.
Duke's suggestion to use iShare web site helps because its already in Excel
format and all the junk left over from the pdf to excel conversion is
cleaned up. 
 
I'll save some a little time. Here's all 4 files in tls format.
Dave
 
 

----- Original Message ----- 
From: Fred S. Esch <mailto:fesch@xxxxxxxxxx>  
To: amibroker@xxxxxxxxxxxxxxx 
Sent: Saturday, July 22, 2006 3:52 PM
Subject: RE: [amibroker] Method to Copy Russell files


Dear David,

About two weeks ago I needed to build a fresh Russell 2000 ticker list for
Amibroker.  I converted the PDF from the Russell website
(http://www.russell.com/us/indexes/us/default.asp) into a .txt file via
Excel and ultimately into a .tls file via NotePad for Amibroker.  I've
attached both the Russell 2000 PDF and the .tls file for your review.  You
will note that the Russell is fairly current (June 30, 2006) but there are
only 1993 tickers;  this is normal as stocks fall off the listing during the
year.

 

Regards,

 

Fred

 


  _____  


From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf
Of David Fitch
Sent: Saturday, July 22, 2006 3:24 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Method to Copy Russell files

 

Thanks Duke
I'll give a look.
Dave

----- Original Message ----- 
From: "Lists" <Lists@xxxxxxxxxx <mailto:Lists%40dukejones.com> com>
To: <amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com> ps.com>;
<amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com> ps.com>
Sent: Saturday, July 22, 2006 3:04 PM
Subject: Re: [amibroker] Method to Copy Russell files

> David,
>
> You can also download the Russell holdings (as well as other indices) from
the ishares website. You have to register but its free and you can get an
excel or csv file which is easier than trying to copy from the Russell
PDF's. Attached is what the Russell 2000 looks like.
>
> Regards,
>
> Duke jones, CMT
>
>
> > -------Original Message-------
> > From: David Fitch <davidfitch@xxxxxxxx <mailto:davidfitch%40prodigy.net>
net>
> > Subject: Re: [amibroker] Method to Copy Russell files
> > Sent: 22 Jul '06 21:49
> >
> > Here ya go
> >
> >
> > [LINK: http://www.russell.
<http://www.russell.com/us/indexes/us/membership.asp>
com/us/indexes/us/membership.asp]
> > http://www.russell.
<http://www.russell.com/us/indexes/us/membership.asp>
com/us/indexes/us/membership.asp
> >
> >
> > Thanks
> >
> > dave
> >
> >
> > ----- Original Message -----
> >
> > FROM: [LINK: mailto:dingo@xxxxxxxx. <mailto:dingo%40adelphia.net> net]
dingo
> >
> > TO: [LINK: mailto:amibroker@xxxxxxxxx
<mailto:amibroker%40yahoogroups.com> ps.com] amibroker@xxxxxxxxx
<mailto:amibroker%40yahoogroups.com> ps.com
> >
> > SENT: Saturday, July 22, 2006 2:40 PM
> >
> > SUBJECT: RE: [amibroker] Method to Copy Russell files
> >
> >
> > Gimme a link to the pdf so I can take a fresh look.
> >
> >
> > d
> >
> >
> > --------------------
> > FROM: [LINK: mailto:amibroker@xxxxxxxxx
<mailto:amibroker%40yahoogroups.com> ps.com]
amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com> ps.com
> > [mailto:amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com> ps.com]
ON BEHALF OF David Fitch
> > SENT: Saturday, July 22, 2006 5:28 PM
> > TO: [LINK: mailto:amibroker@xxxxxxxxx
<mailto:amibroker%40yahoogroups.com> ps.com] amibroker@xxxxxxxxx
<mailto:amibroker%40yahoogroups.com> ps.com
> > SUBJECT: Re: [amibroker] Method to Copy Russell files
> >
> >
> > Thanks d
> >
> > I didn't find the key to change the mouse to text but I did use
> > File/Save as Text...
> >
> > Same thing?
> >
> > If so , I still gotta go through getting rid of extra stuff like
company
> > names, headers, disclaimers, page numbers. This I've done in past by
> > importing txt file to excel and manually cleaning up. Then since AB
> > won't recogize an excel type file, right ? , I cut and past the
tickers
> > back to text file.
> >
> > Now I can import.
> >
> > Probably making the tuffer'n it is.
> >
> > dave
> >
> >
> > ----- Original Message -----
> >
> > FROM: [LINK: mailto:dingo@xxxxxxxx. <mailto:dingo%40adelphia.net> net]
dingo
> >
> > TO: [LINK: mailto:amibroker@xxxxxxxxx
<mailto:amibroker%40yahoogroups.com> ps.com] amibroker@xxxxxxxxx
<mailto:amibroker%40yahoogroups.com> ps.com
> >
> >
> > SENT: Saturday, July 22, 2006 1:55 PM
> >
> > SUBJECT: RE: [amibroker] Method to Copy Russell files
> >
> >
> > The key is to change the mouse to the text select tool then you can
use
> > that to copy/paste out of the pdf.
> >
> >
> > d
> >
> >
> > --------------------
> > FROM: [LINK: mailto:amibroker@xxxxxxxxx
<mailto:amibroker%40yahoogroups.com> ps.com]
amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com> ps.com
> > [mailto:amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com> ps.com]
ON BEHALF OF David Fitch
> > SENT: Saturday, July 22, 2006 4:48 PM
> > TO: [LINK: mailto:amibroker@xxxxxxxxx
<mailto:amibroker%40yahoogroups.com> ps.com] amibroker@xxxxxxxxx
<mailto:amibroker%40yahoogroups.com> ps.com
> > SUBJECT: [amibroker] Method to Copy Russell files
> >
> >
> > I'm trying to copy the various Russell files, in PDF format, into
AB.
> > I've forgotten how I did it last year. I believe it needs to be
changed
> > to TXT file to import into AB. Can someone outline the steps. PDF to
> > Txt to Excel . Clean up tickers in Excel back to Txt then import to
> > AB?
> >
> >
> > I'm probably complicating this but my old brains cells seem a bit
fuzzed
> > up!
> >
> >
> > Thanks
> >
> >
> > Dave
> >
> >
>
>
> 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 other support material please check also:
> http://www.amibroke <http://www.amibroker.com/support.html>
r.com/support.html
>
>
> Yahoo! Groups Links
>
>
>
>
>