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