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

Re: [amibroker] cleaning up the database



PureBytes Links

Trading Reference Links

Yuki,

You might consider keeping the one you're interested in in a watchlist, so
when prices change you can rescreen you d and update your list.

To create a screen:
criteria1 = Close > 5;
criteria2 = xxxxxx;

Filter = Critera1 and Criteria2 and ...
addColumn(Close,"Close");

Then place the list in your watchlist

Ara



----- Original Message ----- 
From: "Yuki Taga" <yukitaga@xxxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Tuesday, September 09, 2003 6:27 AM
Subject: [amibroker] cleaning up the database


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



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