|
PureBytes Links
Trading Reference Links
|
from your post:
"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."
Hi Brett,
does this procedure work even if the stocks in the newly assigned group came
initially from a variety of different groups? Will they all be moved back to
their original groups if I use "Copy" in Organize Assignments. How does each
stock "know" which group it came from initially?
Incidentally, the "Copy" switch in Organize Assignements in my case really
does a MOVE and not a COPY, i.e. the stocks in the original group etc. are
removed. Is that a bug in the program?
Thanks
Alf
----- Original Message -----
From: <brett_f1@xxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Saturday, August 11, 2001 10:02 PM
Subject: [amibroker] Re: import to a watchlist
> 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/
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
|