|
PureBytes Links
Trading Reference Links
|
Thanks for the detailed directions.
I tried importing the CSV into a new 5-minute eSignal DB and got an error in
the 1st ticker:
"Logging started for 'D:\Program Files\AmiBroker\AmiSymbols.csv' file, using
format definition file 'Formats\default.format'
Error in line Agilent Technologies
Inc,A,1,9,34,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,
Invalid date format/value"
Figured you might have set it up for EOD, so repeated importing into a new
EOD DB and got the identical error message.
I don't understand why AB grabbed 'default.format' instead of
Formats\symbolonly.format.
Bob
-----Original Message-----
From: elee67 [mailto:elee67@xxxxxxxxx]
Sent: Wednesday, February 23, 2005 11:55 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Re: Revised Symbols.zip in files section
AmiBroker keeps track of symbols in its own database.. if I'm not
mistaken, broker.workspace and broker.master are indexes to the symbol
files and sector/industry information for that particular database...
SO you need to modify the amibroker database to get the industry and
sector information. Now the problem is with the files I supplied, the
symbols are keyed off of the CSI symbol database. If the symbols match
with esignal, then it will update the sector and industry fine.. If it
doesn't match, then you have two options that can happen via the
import specification of Amibroker : $AUTOADD 1 will auto add the
symbol and $AUTOADD 0 will not autoadd the symbol.
The only two ways that I know of to update sector/industry is :
1- use import with the csv file. if the symbol matches, it will update
the symbol with the appropriate sector/industry.. provided you created
your database based on the sector/industry file that is in the zip
file. Otherwise you may want to check with amibroker support...but I
think you can delete broker.workspace and broker.master(Make a backup
first) from your database directory.. I think amibroker will recreate
those files with the broker.industry and broker.sector file from the
zip file I supplied. Once you get the correct sector/industry
information into your database, use the instructions provided earlier
to create the import types and import the csv file...that will
update/create the symbols in your database with the appropriate
sector/industry information. NOTE : You can modify the
symbolonly.format file and set AUTOADD to 0 if you don't want to add
any new symbols to your database.
2 - write a script to take what is in the csv file and update the
tickers that way...but I have not written a script yet...
Hope that helps..... Search help for Import and read up on it.. Import
is a great way to modify existing symbol information such as
sector/industry.
--- In amibroker@xxxxxxxxxxxxxxx, "Bob Jagow" <bjagow@xxxx> wrote:
> I'm not trying to translate anything--just want to assign sector and
> industry to eSignal tickers.
>
> That is, eSignal provides the fullname but puts everything in
> Markets/Undefined, Groups/Undefined, and Sectors/Services/Advertising.
> Haven't searched eSig BBds yet.
>
> Bob
>
>
> -----Original Message-----
> From: elee67 [mailto:elee67@x...]
> Sent: Wednesday, February 23, 2005 10:53 AM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Re: Revised Symbols.zip in files section
>
>
>
>
> Sector and Industy has nothing to do with translations... It is only
> used if you use amiquote to update ticker price data from yahoo or msn.
>
> You need to create the tickers or update the tickers using the csv
> files which will assign tickers to the appropriate sector/industry.
> The only caveat is that the ticker symbols must match what esignal
> provides... otherwise it won't get data. I.E. DJI is the symbol for
> the dow industrials average.. with yahoo, you need to translate it to
> ^DJI in order to get the data. wiht MSN you need to translate it to
> $INDU. With ESignal, you would probably need to input an alias to the
> symbol in order to retrieve quotes for it.
>
> Symbol management is not a fun task to do...for most basic stock
> symbols, its fine.. but once you get into indexes, otc bb stocks, you
> get different ticker symbols from the different services. Also
> preferred stock is a problem. i.e. AA+ is AA-P on yahoo and AA- on
> MSN( I think).. not sure what that is on esignal.
>
> I will be looking at esignal in the next week or so and will try to
> figure out how best to map symbols over to what esignal has. I will
> then try to create an ALIAS column so that when you import the
> symbols, there will be an alias to the symbol such that it will use
> the alias to get data from esignal. I would assume that might work,
> but not sure if AmiBroker will use alias to get data from esignal or
> not... if it doesn't. then you'd have to create a list of esignal
> ticker symbols separate..
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "Bob Jagow" <bjagow@xxxx> wrote:
> > Do I have to go the amiquotes route in order to assign sector and
> industry
> > to eSignal tickers?
> >
> > Bob
> >
> > -----Original Message-----
> > From: elee67 [mailto:elee67@x...]
> > Sent: Tuesday, February 22, 2005 3:32 PM
> > To: amibroker@xxxxxxxxxxxxxxx
> > Subject: [amibroker] Re: Revised Symbols.zip in files section
> >
> >
> >
> >
> > I am still sourcing info to determine the best places on the net to
> > get symbols and symbol updates.. there are a few errors in the
> > files..but will be posting an update in the next week or two to fix
> it...
> >
> > As for importing the csv files :
> >
> > Before you do anything...
> >
> > Under your Amibroker installation directory.. you will need to go into
> > the Formats Folder.. There will be a file called import.types. You
> > need to edit that file and add the following line to end of the
file :
> >
> > Symbol (*.*)|*.*|symbolonly.format
> >
> > Create a new file called symbolonly.format and put the following lines
> > in it :
> >
> > $FORMAT Fullname,Ticker,Market,Skip,Industry
> > $SKIPLINES 0
> > $SEPARATOR ,
> > $DEBUG 1
> > $BREAKONERR 0
> > $AUTOADD 1
> > $NOQUOTES 1
> > $OVERWRITE 0
> >
> > Then take the brokers.sectors and brokers.industries and copy to your
> > Amibroker install directory(i.e. C:\AmiBroker\).
> >
> > After that.. Open up AmiBroker. Best to create a new database in order
> > to get the approprioate sector and industries....Then under Files
> > there is Import Ascii.. Choose that and then choose the amisymbls.csv
> > and it should import the symbols in.
> >
> >
> > The mapping files need to be copied and pasted into amiquote in order
> > to d/l the quotes from yahoo or msn via AmiQuote.
> >
> > Hope that helps to get you started...
> >
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, "Tinus Rautenbach" <tr@xxxx> wrote:
> > >
> > > Hi
> > > Can anyone tell me where / how I can import the amisymbols.csv and
> > > index.csv files into amibroker. I am only seeing manual ways to
> do this
> > > but was hoping that there is an easier way :)
> > > Thanks in advance
> > >
> > > Tinus Rautenbach
> > >
> > > -----Original Message-----
> > > From: elee67 [mailto:elee67@x...]
> > > Sent: 14 February 2005 12:17
> > > To: amibroker@xxxxxxxxxxxxxxx
> > > Subject: [amibroker] Re: Revised Symbols.zip in files section
> > >
> > >
> > >
> > > The file is located in the Files section of this group. Filename is
> > > Symbols.zip
> > >
> > > These files are CSV files - comma separated values...
> > >
> > > brokers.sectors and brokers.industries should be copied to your
> > > Amibroker install directory. Create a new database. then you have to
> > > import amisymbols.csv. You also have to modify index.csv to
determine
> > > which symbol set you wish to use.. symbol or fixsymbol then import
> > > that into index.csv.
> > >
> > > the mapping files need to be copied and pasted into amiquote in
order
> > > to d/l the quotes from yahoo or msn....NOTE - u also need to modify
> > > the index mappings depending on the symbol set you use.... just open
> > > the csv in Excel, delete a column and save it again...
> > >
> > >
> > >
> > >
> > >
> > >
> > > Check AmiBroker web page at:
> > > http://www.amibroker.com/
> > >
> > > Check group FAQ at:
> > > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> > Check AmiBroker web page at:
> > http://www.amibroker.com/
> >
> > Check group FAQ at:
> > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > Yahoo! Groups Links
>
>
>
>
>
>
> Check AmiBroker web page at:
> http://www.amibroker.com/
>
> Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> Yahoo! Groups Links
Check AmiBroker web page at:
http://www.amibroker.com/
Check group FAQ at:
http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~->
Check AmiBroker web page at:
http://www.amibroker.com/
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|