Re: [amibroker] Method to Copy Russell files

["David Fitch" <davidfitch@xxxxxxxxxxx>]

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 
  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@xxxxxxxxxxxxx>
  To: <amibroker@xxxxxxxxxxxxxxx>; <amibroker@xxxxxxxxxxxxxxx>
  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@xxxxxxxxxxx>
  > > Subject: Re: [amibroker] Method to Copy Russell files
  > > Sent: 22 Jul '06 21:49
  > >
  > > Here ya go
  > >
  > >
  > > [LINK: http://www.russell.com/us/indexes/us/membership.asp]
  > > http://www.russell.com/us/indexes/us/membership.asp
  > >
  > >
  > > Thanks
  > >
  > > dave
  > >
  > >
  > > ----- Original Message -----
  > >
  > > FROM: [LINK: mailto:dingo@xxxxxxxxxxxx] dingo
  > >
  > > TO: [LINK: mailto:amibroker@xxxxxxxxxxxxxxx] amibroker@xxxxxxxxxxxxxxx
  > >
  > > 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@xxxxxxxxxxxxxxx]
  amibroker@xxxxxxxxxxxxxxx
  > > [mailto:amibroker@xxxxxxxxxxxxxxx] ON BEHALF OF David Fitch
  > > SENT: Saturday, July 22, 2006 5:28 PM
  > > TO: [LINK: mailto:amibroker@xxxxxxxxxxxxxxx] amibroker@xxxxxxxxxxxxxxx
  > > 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@xxxxxxxxxxxx] dingo
  > >
  > > TO: [LINK: mailto:amibroker@xxxxxxxxxxxxxxx] amibroker@xxxxxxxxxxxxxxx
  > >
  > >
  > > 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@xxxxxxxxxxxxxxx]
  amibroker@xxxxxxxxxxxxxxx
  > > [mailto:amibroker@xxxxxxxxxxxxxxx] ON BEHALF OF David Fitch
  > > SENT: Saturday, July 22, 2006 4:48 PM
  > > TO: [LINK: mailto:amibroker@xxxxxxxxxxxxxxx] amibroker@xxxxxxxxxxxxxxx
  > > 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.amibroker.com/support.html
  >
  >
  > Yahoo! Groups Links
  >
  >
  >
  >
  >