|
PureBytes Links
Trading Reference Links
|
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 amibroker@xxxxxxxxxxxxxxx, Graham <kavemanperth@xxx> wrote:
>
> Try using Symbol-Information
>
> --
> Cheers
> Graham Kav
> AFL Writing Service
> http://www.aflwriting.com
>
>
> 2008/7/15 Louis Préfontaine <rockprog80@xxx>:
> > 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 <droskill@xxx>:
> >>
> >> 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!
> >>
>
------------------------------------
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/amibroker/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:amibroker-digest@xxxxxxxxxxxxxxx
mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|