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" <[EMAIL PROTECTED]> 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. > > >
