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 -----
From: Eski Movsinuit
To: [email protected] ; [email protected]
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
------------------------------------------------------------------------------
Free 3D Marine Aquarium Screensaver
Watch dolphins, sharks & orcas on your desktop! Check it out at
www.inbox.com/marineaquarium
