The symbol name can not be modified by Symbol > Information. As far
as I know there is no easy way to do this. I have done this before
but it takes so long I just decided I liked lower case.
This is one way to do it.
1. Save your symbol list using AmiQuote > Tools > Get tickers from
AB. Save this as a csv file.
2. Use Word to change the case.
3. Save your database using an export program. I added one to the AFL
formulas on the AB site. Search on export. There are a number of
export programs there. The one I added will export EOD or intraday
data to a directory on your C drive.
4. Create a new database.
5. Import the uppercase symbols using Symbol > Watchlist > select a
watchlist number and then import the ticker list. Don't just import
the data you saved since it has the lower case names.
6. Use Import Wizard to import the data. It doesn't care what the
case is now. You may be able to import all the files at once. I never
tried 6000+ but it is worth a try.
I tried to use a script to change it but it seems the object model
will not allow the change. Makes sense that you couldn't change the
name of an object. The script I used is below. I can see the case
changed but when I read back the ticker name after "changing" it, it
was not changed.
Barry
/*
** AmiBroker/Win32 Scripting Program
**
** File: None
** Created: Barry Scarborough - 7/14/08
** Purpose: Change the case of symbols to upper case
** Language: JScript (Windows Scripting Host)
*/
var oAB = WScript.CreateObject("Broker.Application");
var fso = new ActiveXObject("Scripting.FileSystemObject");
var oStocks = oAB.Stocks;
var Qty = oStocks.Count;
WScript.Echo("Change name of start" );
for( i = 0; i < Qty; i++ )
{
oStock = oStocks( i );
var ticker = oStock.Ticker;
var ucTicker = ticker.toUpperCase();
oStock.Ticker = ucTicker;
WScript.Echo("Original ticker is " + ticker + " was changed to " +
ucTicker + " but updated ticker has " + oStock.Ticker );
}
WScript.Echo("Change to upper case complete." );
--- In [email protected], Graham <[EMAIL PROTECTED]> wrote:
>
> Try using Symbol-Information
>
> --
> Cheers
> Graham Kav
> AFL Writing Service
> http://www.aflwriting.com
>
>
> 2008/7/15 Louis Préfontaine <[EMAIL PROTECTED]>:
> > Hi,
> >
> > For the first question I don't know (but would like to know) the
answer, but
> > for the second I simply renamed the folder and it seemed to work
for me.
> >
> > Louis
> >
> >
> >
> > 2008/7/14 droskill <[EMAIL PROTECTED]>:
> >>
> >> Ok - I'll admit these are stupid issues that I'd love to fix but
I'm
> >> sensitive to screwing up my AB data. I'm wondering if anyone has
any
> >> idea how to fix these:
> >>
> >> 1. Symbols in lower case: When I first started putting together
my
> >> quotes, I put some in lower case (my datasource is TC2005) - I
want to
> >> have them all uppercase. I don't want to delete them and then add
> >> them back because this would require re-adding them to all my
> >> Watchlists. Any easy way around this?
> >>
> >> 2. Changing the name of a database - is there any easy way to do
this?
> >>
> >> Thanks!
> >>
>
