|
PureBytes Links
Trading Reference Links
|
Brett
You are correct, I found #2509 right after pressing the send button,
and now you led me to reread this.
Thankyou
Nice Work
Brian
--- In amibroker@xxxx, brett_f1@xxxx wrote:
> Warren and Trader,
>
> The first step is to save your workspace. Then, I suggest you load
> all remaining quotes and then make a backup of your workspace.
Click
> on File, Save Workspace As, and then pick on a new spot on your
hard
> drive or CD/R or CD/RW. If you do not laod all quotes first, your
> backup data base will contain only those quotes loaded thus far.
>
> Create a new file in the Formats folder below Amibroker that
defines
> the format of the data you wish to import. Here's the file I
created
> to import a ticker list from Zacks website.
>
> # Format definition file created for modifying stocks - put into
> group for Zacks
> # by Brett Forrester 6-18-2001
> $FORMAT Ticker, group
> $NOQUOTES 1
> $OVERWRITE 1
> $SKIPLINES 0
> $SEPARATOR ,
> $CONT 1
> $AUTOADD 0
> $DEBUG 1
>
> (Note: Be careful of the word wrap going on above...)
>
> Then, edit the import.types file in the same folder to include the
> new file you just created. Here's the line I added for import of
> Zacks list:
>
> Zacks Group (*.csv)|*.csv|TC2000 into Zacks.format
>
> The most important part thus far is setting up the $FORMAT line.
You
> must know the format of the data you are importing. For me, I cut
> and paste a list from Zacks that contains 3 columns of
information.
> It contains the Ticker symbol, the Company Name and something else
of
> no consequence in the last column.
>
> To get the dat from Zacks into Amibroker workspace group of my
choice
> I do the following:
>
> 1. Copy data onto windows clipboard.
> 2. Start Excel or any other spreadsheet program.
> 3. Paste data into blank worksheet.
> 4. Strip out all unneeded lines and columns.
> 5. What I'm left with is one column of tickers (that are actually
> still hyperlinks).
> 6. Next, I add a column that contains the group number I wish to
> populate. Fill the column with this number.
> 7. Save the file with a .csv extension.
> 8. In Amibroker, do an ASCII import of the file using the format
> type you created. This will move the tickers from old group(s) to
> the new froup number you assigned in the .csv file. It is
important
> to note that your workspace will not show that it has changed at
this
> point even though the group assignments were changed.
> 9. Start Automatic Analysis.
> 10. Clear the window and input the following two lines:
>
> numcolumns=1;
> filter=1;
>
> 11. Click Use Filter. Define the filter to be the group you moved
> the tickers to. Set the range to be the last day of data in the
> workspace. Click on Explore.
> 12. Right click on the output data and save the results to the
Watch
> List of your choice.
> 13. Decide whether or not you wish for the group assignments to
> remain or not. If not, use Organize Assignments to move them back
to
> their original groups.
> 14. Double check that your workspace seems fine and then Save your
> workspace - this will now save the assignments for you. If it does
> not seem fine, exit the program without saving your work.
>
> This routine works well for me - I do this every Saturay morning
and
> it takes not too much time. The longest part is loading the
> remaining quotes and then then subequent save. It's also when I've
> updated my database as well for all tickers so this adds to my save
> time.
>
> Brett
>
> --- In amibroker@xxxx, "Warren Benson" <b8956@xxxx> wrote:
> > Brett,
> > So would I, since what you are doing is almost exactly what I
want
> to do.
> > Thanks'
> > Warren
> > -----Original Message-----
> > From: traders10@xxxx [mailto:traders10@x...]
> > Sent: Saturday, August 11, 2001 11:37 AM
> > To: amibroker@xxxx
> > Subject: [amibroker] Re: import to a watchlist
> >
> >
> > Brett, I would like to see your procedure for importing to an
> unused
> > group. If you could post it please....
> > Thanks
> > Trader
> >
> > --- In amibroker@xxxx, brett_f1@xxxx wrote:
> > > Warren,
> > > As far as I know, you can not directly ASCII import into a
watch
> > list
> > > yet. To get around this, I import an ASCII list into an empty
> > group
> > > number and then take the stocks from that group and assign them
> all
> > > to a watch list using exploration. The main trick to doing
this
> is
> > > adding a column to the ASCII list that contains the group
number
> I
> > > want the list assigned to and having the correct import type
> > defined.
> > >
> > > If you still need help, I can post detailed example of how I do
> > > this. I work with TC2000 data and output from Zacks web site
so
> > the
> > > example would centered around how I do that. I've corrupted my
> > > database enough times in the past that I've sorted out the
> glitches
> > > now with my procedures. Most of the glitches have been located
> > > upstream of the keyboard input <gr>.
> > >
> > > Brett
> > >
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
|