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

Re: [amibroker] Clean Up Database



PureBytes Links

Trading Reference Links

Errnie,
 
I see two categories of symbols that I don't want - those with no quotes or static quotes, and those that are not useful to me.  I currently have an AFL script that looks for the first, but not the second.
 
Tonight, I'm going to modify my AFL script so that it will:
 
1) Find all symbols with no prices or static prices in the last month.  
 
2) Find all symbols in categories in which I'm not interested (Preferred stocks, Mutual Funds, etc.).
 
3) Stuff the static symbols in one watchlist.
 
4) Stuff the "not interested" symbols in another watchlist.
 
Then it's a simple matter to delete the symbols from the target watchlist.   This process should be fewer steps, but still allow review prior to deletion.
 
When it works smoothly (maybe tonight), I'll post it here.
 
Regards,
 
Dan.
 
 
-------------- Original message --------------
Is there a way to set Clean up database into automatic mode so I don't
have to spent all day deleting symbols that have no data or the data is
not up to date because the company may hve merged or the symbol has
changed. I am using Quotes plus data and after a while it seems the
database loads up with hundreds of these symbols. The only way I see to
delete them is to click on delete for each symbol as it is found my
computer just spent 6 hours just finding them. I can't sit for that
long and delete them.
There must be a better way.
Ernie




Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com

For other support material please check also:
http://www.amibroker.com/support.html





YAHOO! GROUPS LINKS