|
PureBytes Links
Trading Reference Links
|
Hi Bob,
This works perfectly! Thank you all for offering tips!
Eski
Eski, assuming your comma-ending symbols never got
populated with any data, try running Database
Purify from the Tools
menu. Run Database purify and select the 'Report missing quotes'
check box.
When Purify completes, sort
on 'Problem/Description' in the results You'll get a lot of symbols that are
reported as missing
some quotes, but at the bottom of the list should
be all the stocks with no quotes. They will
be clearly labeled as such.
Shift-left button select those symbols then
right-click and chose 'Add selected symbols to watch list...' (Make sure
use
the 'selected symbols' instead of
'All')
Then go the the Symbol menu and select Organize
Assignments and follow Patrick's instructions for deleting the
symbols.
Regards,
Bob
----- Original Message -----
Sent: Monday, February 08, 2010 5:55
PM
Subject: Re: [amibroker] clean up wrong
symbols from the database
I tried the following and it seems that any symbol with "," will not be
picked up from the explore process.
I even tried StrFind( Name(), "," ) but
it's not picking up anything.
NumColumns = 2;
//Filter =
StrFind( Name(), "," ) != 0;
Filter = 1;
Column0 = V;
Column1 = C
;
Eski
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/
![]()
__,_._,___
|