Allan, to import Aliases make sure that your ASCii Importer's Format Definition File has the following lines:
$AUTOADD 1 $OVERWRITE 1 Lester --- In [email protected], "Mark Jarvis" <[EMAIL PROTECTED]> wrote: > > I've successfully imported items into the Alias field using the ASCII > importer. The only issue that I have is that I think the ALIAS field length > is shorter than the Fullname or name field, so some of the long futures > symbols for IB wouldn't fit. > > On 05/02/07, Lester Vanhoff <[EMAIL PROTECTED]> wrote: > > > > I remember that in earlier versions of AB there were some problems with > > ASCii Importer and Alias field. I think you needed Close in your data file: > > Ticker, Date, Alias, Close. I'm not sure if this has been fixed. > > > > Lester > > > > > > --- In [email protected] <amibroker%40yahoogroups.com>, "Lester > > Vanhoff" <ebsn247lsm@> wrote: > > > > > > For a starter you can try this. > > > > > > 1) Look at the code below. > > > > > > // Show First N Characters Of The Ticker > > > > > > Filter = 1; > > > > > > c_1 = StrLen(Name()); > > > > > > // show last N characters (one-based) > > > c_2 = StrRight(Name(), 8); > > > > > > // show all characters less N (one-based) > > > c_3 = StrLeft(Name(), c_1 - 8); > > > > > > AddColumn (c_1, "Ticker Length"); > > > AddTextColumn(c_2, "Last Chars"); > > > AddTextColumn(c_3, "First Chars, Alias"); > > > > > > 2) Modify the above code to keep only the columns that you need, for > > example Ticker, Date and your new Alias column. > > > > > > 3) In Automatic Analysis set the Date Range to Last N Days = 1 and run > > Exploration, then click Export to save the results to a CSV file. > > > > > > 4) Use ASCii Importer to import data from the CSV file back to AB. Make > > sure that you have at least two fields included in Import Definition File: > > Ticker and Alias. > > > > > > http://www.amibroker.com/guide/d_ascii.html > > > > > > Lester > > > > > > > > > --- In [email protected] <amibroker%40yahoogroups.com>, "Allan" > > <allanbradl@> wrote: > > > > > > > > Hi Guys ! Iam looking for a way to write all the ticker names from > > > > my database in to the "Alias" field in Information tab (I understand > > it > > > > means to assighn Alias to the ticker ) Iam using IB format , > > > > TICKERNAME-STK-NXY or TICKERNAME-STK-TSE etc. so in this case I would > > > > want to take "TICKERNAME" of all the symbols and write it as an Alias > > > > without "-STK-TSE" part. Would appreciate any help.
