[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [amibroker] Re: Revised Symbols.zip in files section



PureBytes Links

Trading Reference Links

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@xxxxxxxxx]
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









------------------------ 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/