[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] clean up wrong symbols from the database


  • Date: Tue, 9 Feb 2010 07:59:46 +0530
  • From: "Prashanth" <prash454.ta@xxxxxxxxx>
  • Subject: Re: [amibroker] clean up wrong symbols from the database

PureBytes Links

Trading Reference Links



Hello,
 
If you have the ticker list for the symbols (with the ,), import the tickers into a Watchlist.
 
The using Symbols -< Organize Assignments -> Watchlist, select the watchlist stocks and press Delete.
 
This shall remove all the invalid tickers in one go.
 
Cheers
 
Prashanth
----- Original Message -----
Sent: Tuesday, February 09, 2010 5:25 AM
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


-----Original Message-----
From: ta4charts@xxxxxxxxxxx
Sent: Mon, 8 Feb 2010 10:39:39 -0800
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] clean up wrong symbols from the database

 

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

3D Marine Aquarium Screensaver Preview
Free 3D Marine Aquarium Screensaver
Watch dolphins, sharks & orcas on your desktop! Check it out at www.inbox.com/marineaquarium

Free Online Photosharing - Share your photos online with your friends and family!
Visit http://www.inbox.com/photosharing to find out more!


__._,_.___


**** 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/





Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___