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

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



PureBytes Links

Trading Reference Links

And to speed things up set "ApplyTo" to "current stock". 
UM


----- Original Message ----- 
From: <uenal.mutlu@xxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Wednesday, June 04, 2003 11:25 PM
Subject: Re: [amibroker] Re: All Those Tickers........


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