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

[amibroker] Re: cleaning up the database



PureBytes Links

Trading Reference Links

Yuki,
run in AA the
Filter=C<5;
AddColumn(C,"");
for all stocks, n=1 last quotations.
Right click on the results, move to an emply WL #xx.
Symbols->organise assign->WatchList.
Select all the WL#xx stocks [using shift] and hit the magic "delete".
You will never see them again.
Dimitris Tsokakis
--- In amibroker@xxxxxxxxxxxxxxx, Yuki Taga <yukitaga@xxxx> wrote:
> Think I got the zero data stocks out of the database.  The trick,
> which is not at all either intuitive or in any reference I can find,
> is to run Data Purify with NOTHING checked.  This apparently flags
> all empty symbols, which then can be moved to a watch list and nuked
> with ease.
> 
> Now, however, I still have thousands of stocks in the database that 
I
> wouldn't trade with YOUR money.  ^^_^^
> 
> Can anyone write a script, or better show me how to write one, that
> eliminates stocks from the database based on price.  (Below 5 
dollars
> for sure, maybe below 10.)  How about volume?  (Below MA 50 < 
100,000
> for sure.)
> 
> There may be a subtle problem with the volume side.  For example,
> some indices apparently have no volume data, but I'd like to keep
> them anyway.
> 
> Yuki


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->

Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/