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
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
Aucun commentaire:
Enregistrer un commentaire