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

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



PureBytes Links

Trading Reference Links

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/