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

RE: [amibroker] All Those Tickers........



PureBytes Links

Trading Reference Links

One way is to set up a second database with just the tickers you want
Or
Put them into a different group, or market within the same database

Cheers,
Graham
http://groups.msn.com/ASXShareTrading
http://groups.msn.com/FMSAustralia

-----Original Message-----
From: uenal.mutlu@xxxxxxxxxxx [mailto:uenal.mutlu@xxxxxxxxxxx] 
Sent: Wednesday, 4 June 2003 10:47 PM
To: amibroker@xxxxxxxxxxxxxxx
Cc: abtool@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] All Those Tickers........

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




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