|
PureBytes Links
Trading Reference Links
|
THANKS i was just looking into that.
here how i ended up doing it
I get my ticker list from MSN.
Did what you said in excel ( make it ticker,group)
I used the import wizard to import the list
name it group.format
then EDIT the FORMAT and put in the keyword group after the ticker and
delete the rest
then did ascii import on the file
(TJ you need to add group,pe,eps,etc to the drop down menu)
Nick
At 08:02 PM 8/11/2001 +0000, you 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/>http://docs.yahoo.com/info/terms/
Your use of Yahoo! Groups is subject to the
<http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.
|