Affichage des articles dont le libellé est Help for changing many symbols on DBase. Afficher tous les articles
Affichage des articles dont le libellé est Help for changing many symbols on DBase. Afficher tous les articles

mardi 22 novembre 2016

Help for changing many symbols on DBase

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


Help for changing many symbols on DBase