PureBytes Links
Trading Reference Links
|
Hi Steve,
the plugin ABtool has a function for deleting single
and multiple tickers from the AB database. Just move
those stocks to delete into a watchlist and use the following
AFL code which is taken from the ABtool/Functions.afl.
You can also select them using a condition like in your example.
You can then put the result into any desired watchlist by
rightclicking within the results window of Scan/Explore.
//---------------------------------------------------------
function DeleteStocksFromDB(iWL)
{ // stocks in the given watchlist are deleted
// from the database
count = 0;
ticker = xxWLtickerFirst(iWL);
while (ticker != "")
{
count++;
xxWinText("" + ticker + "\n");
xxDeleteStockFromDB(ticker); // deletes from DB
ticker = xxWLtickerNext(iWL);
}
xxWLclear(iWL);
if (count > 0)
{
xxViewRefresh();
xxWLrefresh();
}
}
//---------------------------------------------------------
In your code call this function for example like this:
DeleteStocksFromDB(32);
This deletes all stocks in watchlist 32 permanently from the DB
and of course also from the watchlist.
You can find the latest ABtool/Functions.afl file here:
http://groups.yahoo.com/group/abtool
You just need to #include it at top of your own script
and issue the DeleteStocksFromDB() function.
UM
----- Original Message -----
From: "steve_almond" <steve@xxxxxxxxxxxxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Wednesday, June 04, 2003 4:04 PM
Subject: [amibroker] All Those Tickers........
>
> As I speak, I'm downloading the 'Complete US Stocks Database', some
> 7700 symbols in all, nicely arranged in Market/Groups/Sectors.
> Thing is, I don't really want all 7700 symbols. I get confused
> enough with a few hundred. So, the question is can I scan this vast
> database and select/keep only those with (for example):
>
> C*MA(V,21)>3,000,000
>
> I know how to do the scan/exploration, how do I eliminate the
> unwanted tickers, but keep the wanted tickers in their correct
> Groups/Sectors?
>
> Thanks,
>
> Steve
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get A Free Psychic Reading! Your Online Answer To Life's Important Questions.
http://us.click.yahoo.com/Lj3uPC/Me7FAA/ySSFAA/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/
|