Author Topic: Help for change many symbol in the Dbase  (Read 680 times)

kiss.sphinx

  • Newbie
  • *
  • Posts: 1
    • View Profile
Help for change many symbol in the Dbase
« on: November 22, 2016, 11:14:18 am »

I have many symbols in database with an old prefix (1 example is:  BE_XXX  ).
I want to change all ticker prefix in the database with [BE: or other prefix]  (to download and retrieve data from Google [without using translation file on Amiquote])

I have many hundred symbols in database and I don't know well the Language.

--------------------------------------------------------------------------------------------------
(I found this script (below) on the web (I try to modify it)... but I can't to resolve my problem)

AB = CreateObject("Broker.Application");
sts = AB.Stocks();
Qty = sts.Count;
for( i = Qty - 1; i >= 0; i = i - 1 )
{
 st = sts.Item( i );
 Ticker = st.Ticker; 
 printf("changing " + ticker + "\n" );
 Length = StrLen(Ticker );
 if( StrFind(ticker, ".TO") )
      st.Ticker = StrLeft( ticker, Length-3)+"-TC";
}
-----------------------------------------------------------------------

Can anyone help me to resolve this problem? I'm sure that's very simple but I'm a very novice programmer....
Thanks in advance

Kiss