|
PureBytes Links
Trading Reference Links
|
Did you modify the import.types as specified in the previous postings?
You also needed to create symbolsonly.format.
Amibroker uses the format file to determine what fields are imported
when using import ascii. the default.format does not have the required
industry number import defined... hence you get the error.
See msg #78563
NOTE - As mentioned before.. you need to delete the broker.workspace
and broker.master in your data directory. make a backup copy just in
case. When you open amibroker, i believe it will recreate those with
the appropriate sector and industry numbers as defined in the
broker.sectors and broker.industries file that are in the zip file.
You need to replace your existing sector and industry file in the
amibroker directory with the ones from the zip file.
--- In amibroker@xxxxxxxxxxxxxxx, "Bob Jagow" <bjagow@xxxx> wrote:
> 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@x...]
> 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/
|