Ticker list with leading zeros

AmiBroker
1

My ticker list display now contains hundreds of leading zeros. The real tickers following seem to be OK. This is a 6.30.5 copy of Amibroker,
My data source is Worden TC data.
I do have a backup system from which I could move a USB copy if that is safe to do.
What is the safeest fix?
Thanks.

2

What is meant by ticker list?
Do you mean that some symbol names (of symbol window) have 0 at start?

E.g. like this
3

If so then add all those symbols having undesirable names to an empty (same) watchlist and then

  1. open analysis
  2. Set "Apply to" to that watchlist
  3. then apply below code to analysis and run scan
// set 'Apply to' -> Filter and choose Watchlist of symbols with leading zeros
// Then run scan
// https://forum.amibroker.com/t/ticker-list-with-leading-zeros/13055/2
// derived from
// http://www.amibroker.com/kb/2006/09/01/how-to-change-property-for-multiple-symbols-at-once/
wlnumber = GetOption( "FilterIncludeWatchlist" ); 

SetOption( "RefreshWhenCompleted", True );

if ( Status( "action" ) == actionScan ) {
    Buy = 0;
    
    if ( InWatchList( wlnumber ) ) {    
		AB = CreateObject( "Broker.Application" );
		st = AB.Stocks( Name() );

		Ticker = st.Ticker;
		_TRACE(Ticker);
		
		st.Ticker = StrTrim(Ticker, "0", 1);
    }
}

... resulting in:

3

3

Use notepad++ and record a macro. Or use search/replace function. Or both.

4

i had something similar with some tickers and with dates once, generally something caused this to be happen by a problem with the data plugin ( or netwrok/windows), i do not think it has anything to do with Amibroker.

If its a one off, it should be fine and there is a good suggestion to rename them but if you delete them and do a fresh backfill then it should be ok.

5

sorry if I was unclear. The ticket list is found in the URH of the panel and lists both the market code (as in AAPL) and if you expand it the actual name of the security.
Normally the scrollable list is hundreds of alphabetic codes in A to Z order. What I now have instead is a list of the same length as normal, but consisting of entries of 0 (the number zero) for half of the list followed by what would have been the initial half of the correct list (that is A to mid alphabet) and with what would have been the remainder of the last half of the normal list missing. Looking back at my TC products, their symbol list is the expected A - Z order.
My unused backup which has been upgraded also to the latest Amibroker level looks normal.
I am off to look at the other answer to my question which looks a bit more complicated.
Thanks for the help.

6

A screenshot would help make it clear.

"A good sketch is better than a long speech."
-- Napoleon Bonaparte

1 Like
7

**[quote="ghanson, post:6, topic:13055, full:true"]

A screenshot would help make it clear.

"A good sketch is better than a long speech."
-- Napoleon Bonaparte
[/quote]

**

  1. I have a screen shot taken by a camera as my snip software won't let me take the picture I can not yet load the clipping, but let me describewhat is on the picture, Start with the usual listing of the stock symbols (or with the optional full names of the securities), Pretend you have started the scroll down. You expect to see each of the stocks in which you have data. Instead of this you see a first line with a "0" followed by yet another zero and on and on. After looking at thousands of lines with one zero a lline, you now get to the top line of the normal ticker listing, In my case, this starts with some lines of "$a,,,,,,," At this spoint you see the slider on the right side is nearly half way down. If you use the slider to slide down some more, you see all of the symbols you would have expected. As soon as I can find how to send my photo, I will add it here.