Hi Eski,
Just thinking off the top of my head here, but could you do an exploration
of your entire database (e.g., filter = 1) with the only columns displayed being
for the Close or perhaps Volume. Then sort the exploration to identify all
symbols with a zero value for the close (or volume) {here I'm assuming that the
erroneously added symbols do not obtain any data from your data provider}. If
you can do this, now select the zero valued symbols (you can select them by
<LMC> (i.e. left mouse click) on the first and then do a
<shift><LMC> on the last) and then do a RMC and select "Add selected
results to watchlist", and select an empty watchlist to add the bad
symbols to. Now open Organize Assignments ( either <ALT>O, or from the
toolbar: Symbol -> Organize Assignments), select Watchlists, scroll to the
watchlist you put the bad symbols in, highlight all and then click on
delete. You'll get a warning before deleting, but ignore it.
This is a bit labor intensive, I know. A couple days ago someone
posted a code for deleting all symbols with .ob endings which you might adapt if
you think you would have to do this more often or for different databases.
Or you could modify the EZ Cleanup jscript I wrote long ago (I think it is in
the library or files sections) or the Cleanup jscript Thomaz provides in
Tools (and which my effort was based on). That mod would be to
find stocks with 0 trading for one day, but it might also delete legitimate
stocks that trade infrequently.
Peace and Justice --- Patrick
----- Original Message -----
Sent: Monday, February 08, 2010 10:10
AM
Subject: [amibroker] clean up wrong
symbols from the database
Hi,
I
accidentally added 500 symbols into the database with extra comma in the
symbol.
For example, the symbol "AAPL" becomes "AAPL,"
Is there a way to
remove all those wrong symbols with comma?
Thank you.
Eski
__._,_.___
**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
![]()
__,_._,___
|