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

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



PureBytes Links

Trading Reference Links

Hi Steve, it is already ready made. Just get the latest version of 
the file "Functions.afl" from the web: http://groups.yahoo.com/group/abtool 
and place it under the ABtool directory, and restart AB.
Then start a new script in AutomaticAnalysis and put the following:

#include "ABtool/Functions.afl"
DeleteStocksFromDB(13);

and press Explore and then wait until it finishes.
In the xxWindow it will display each stock processed..

// UM

----- Original Message ----- 
From: "steve_almond" <steve@xxxxxxxxxxxxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Wednesday, June 04, 2003 10:50 PM
Subject: [amibroker] Re: All Those Tickers........


> UM,
> 
> Your code seems to do what I want. Problem is I'm a moron as regards 
> code....
> 
> Here's what I've done:
> 
> 1. Downloaded your ABtool, unzipped it and put ABTool.dll in my 
> plugin folder. Restart AB and checked that ABTool is a plugin - OK.
> 
> 2. Run my exploration and moved the "failed" stocks into watchlist 
> 13. There are 5326 stocks to delete.
> 
> 3. Now, just where do I put this piece of code to delete watchlist 
> 13? In AA window? Do I simply write:
> 
> DeleteStocksFromDB(13);     
> 
> and then Explore?? Scan??
> 
> Please help with this last step.
> 
> Thanks,
> 
> Steve
> 
> 
> --- In amibroker@xxxxxxxxxxxxxxx, uenal.mutlu@xxxx wrote:
> > 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@xxxx>
> > 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/