RE: [amibroker] Ticker Symbol Length Issues, AmiBroker Email List Archive

Dan,

Dingo, beat me to it. If you know what each symbol will be you can import the names into the DB so in my case since I know that the Automobile Sector - Advance Decline Line will have a symbol “*AUTO1 A/D Line” I create text file to import. It still is a lot of copying and pasting in a word file or excel.

For example, here is a simple ATC to create the number of issues whose RSI is “overbought or oversold” for each sector.

if(SectorID()== 1)

{

sym = "*"+"AERO1 RSI OB";

AddToComposite( RSI() > 70, SYM, "V");

AddToComposite( 1, sym, "I" );

syma = "*"+"AERO1 RSI OS";

AddToComposite( RSI() < 30, syma, "V");

etc, etc,

I am sure there must be better ways to do this but it works and it is much easier than what I was using before.

I then create indicators of the percentage to plot on the sector layouts.

Again, none of this may be applicable for what your trying to do but I thought I would toss it out there. There are very few times when I can offer anything of value to board relative to the help they have given me.

Regards,

Duke Jones, CMT

From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of dingo
Sent: Sunday, August 14, 2005 11:06 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Ticker Symbol Length Issues

I haven't tried this but try this:

1. If you don't have an existing composite without a name then create one and make sure it has data in it.

2. create a text file that contains the ticker and create a name and separated them with a comma.

3. use the importer to import that ticker and name but no "quotes".

If the ticker now has a name and all of the data it had before you've got a method for doing what you want:

1. in the composite building formula write out a text file as in step 2 above.

2. after the composite building formula finishes then import the text file.

The above steps can be combined using vbscrip or jscript or maybe even Batman.

From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Dan Clark
Sent: Sunday, August 14, 2005 11:59 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Ticker Symbol Length Issues

Duke,

This is similar to what Tomasz is suggesting. But…

How do you map the ATCs to stock symbols and have something readable? I can map Sector/Industry symbols to Stocks through Full Name.

The key issue is entering the valid names in the Full Name field. I can’t manually enter thousands of Full Names manually. How do you get around this issue?

Regards,

Dan.

From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Duke Jones, CMT
Sent: Sunday, August 14, 2005 8:42 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Ticker Symbol Length Issues

Dan,

Not sure if this will be of help but the best work around I have found is to use a 4 letter sector/industry root symbol. For example I have:

*AUTO1

*AUTO2

*AUTO3 etc

AERO1 = Aerospace Sector

AERO2 = Aerospace-Defense

AERO3 = Aerospace-Defense Eqp

The number “ 1 ” as in AUTO1 is always a sector. Since you have the numeric there is no risk of duplicating a real symbol. This also makes it easy to code ATC’s for indicators like Advance/Decline lines etc. for each group/sector because you know the symbols will be consecutive. I have 25 Sectors and over 200 industry groups so I needed to find something to reduce the work and operate under my limited code restrained brain functions. J

If you find another work around let us know.

Regards,



Duke Jones, CMT

From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Dan Clark
Sent: Sunday, August 14, 2005 1:12 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Ticker Symbol Length Issues

Hi,

I’ve discovered the joys of Composite symbols. However…

I ran into what appears to be a serious issue when creating Composite symbols – ticker symbol length. It appears that the maximum length for a ticker symbol is 25 characters.

When creating Composite symbols, you append or prepend a character string to differentiate types of Composite symbols. If the first 25 characters of a Composite symbol are exactly the same, the excess characters are truncated and values are merged to one symbol. The symbol is then corrupt.

For example, I create QP Industry Composite indexes of my stock list, and then create an “Indicator” Composite symbol of each Industry Index symbol. Here’s how the error occurs:

·        QP has two Industries:

Aerospace-Defense

Aerospace-Defense Eqp

·        Composite Industry indexes are created by prepending “~iInd_” to the industry name:

~iInd_Aerospace-Defense

~iInd_Aerospace-Defense E

Notice that “qp” is truncated from the second industry.

·        Then Composite Indicator symbols are created by prepending “Rk” to the Industry Index symbols:

“Rk~iInd_Aerospace-Defense”

However, instead of two Composite Indicator symbols, only ONE is created! Since the left 25 characters of the Indicator Composite symbol (“Rk” + Industry Index symbol name) are same for both Industries, values from the two Industry Index symbols are merged to one Indicator Symbol!

Composite Indexes and Indicator symbols are a HUGE benefit. Composite Indicator symbols allow me to preprocess and save Indicators like RSI, and then use them like a normal ticker.    Before, my scans and charts computed Sector and Industry Rank on the fly, which was SLOW! Now, with Sector and Industry Composite Rank symbols, scans and charts are at least 3 times faster!

How can I get around this character length limitation?   Tweaking symbol names might work for a while, but at some point the symbol names will become meaningless.   Can I increase the Symbol length? Tomasz, can you increase Symbol length?

Thanks and regards,

Dan.

--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 8/12/2005

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 8/12/2005

Please note that this group is for discussion between users only. To get support from AmiBroker please send an e-mail directly to SUPPORT {at} amibroker.com For other support material please check also: http://www.amibroker.com/support.html

YAHOO! GROUPS LINKS

Visit your group "amibroker" on the web.
To unsubscribe from this group, send an email to: amibroker-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 8/12/2005

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 8/12/2005