Ray, The second number is referring to the total number of Quotations for the stock in the Active Window, in your case that was NMSS. As for AmiQuote your stock ticker list may be a default set by AmiQuote in the initial setup. If you open AmiQuote and then tell it to get tickers from AmiBroker you will have the complete list, then save that list so you can call it up in future. The AmiBroker Manual tells you how to do that.
There is no such thing as an "automatic" delete. What you need to do is run a scan that finds all stocks under $5.00. Save the results to a Watch List. Then go into Symbol > Organize Assignments > Watch Lists. Choose the watch list you created with the under 5 stocks from the pull down, click on the 1st stock, scroll to the bottom of the list and while holding down the shift key click on the last stock. This will select all the stocks in the list. Then choose the Delete Option. This will remove them from your database. Don't forget to create a new AmiQuote ticker list from your now smaller database, or you will bring them all back in the next time you up date. Judging from the questions you ask over the last few weeks I think you have to spend some time with the manual and find some of your answers for yourself. The quickest way to alienate yourself on this list is to expect everyone else to give you answers without you doing your homework. Don Lindberg _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of ax_ray2222 Sent: Wednesday, July 04, 2007 3:20 PM To: [email protected] Subject: [amibroker] Re: How to use ATC only with positive EPS? Don, thank you it says "7275 in database and 3355 in NMSS" What does the NMSS 3355 mean? Also if I go to Aquote I have only 5255 symbols displayed there for same database. It is confusing.... How can I delete any symbol below $5 automatic? Seems that if you run a script you can not choose the symbols and delete them.... Ray --- In [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com, "Don Lindberg" <[EMAIL PROTECTED]> wrote: > > Ray, > > If you move your mouse over your database name at the very bottom right hand > corner of AmiBroker status bar it will show you total # of entries. > > Don > > > > _____ > > From: [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com [mailto:[EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com] On Behalf > Of ax_ray2222 > Sent: Wednesday, July 04, 2007 7:31 AM > To: [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com > Subject: [amibroker] Re: How to use ATC only with positive EPS? > > > > Don, how can I check how many tickers are in the database? I ran the > simple Explration for C.5 and V>100k and it gave me only 140 symbols, > which is not right.... > I try to see if the database has data collected (it says 7075 > symbols) if I open it in AQuote. > > Ray > > --- In [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com, "Don > Lindberg" <dlindber@> wrote: > > > > Ray, > > > > If you keep 2 data bases you have to log into each separately and > do the > > updates. That is why I work with Many different Watch Lists. I have > one data > > base, but all of my various calculations are done against one or > the other > > watch list. > > > > > > > > Don > > > > > > > > _____ > > > > From: [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com > [mailto:[EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com] > On Behalf > > Of ax_ray2222 > > Sent: Monday, July 02, 2007 11:41 PM > > To: [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com > > Subject: [amibroker] Re: How to use ATC only with positive EPS? > > > > > > > > Don thank you for that. If I create 2 databases, how do I keep them > > updated? do I have to log AB in both of them separate and update > each > > or both will get data from AQ? I'm puzzled here.... > > sorry for all this novices questions... > > Ray > > > > --- In [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> > ps.com, "Don > > Lindberg" <dlindber@> wrote: > > > > > > Ray, > > > > > > Keep the full AmiBroker Database, because Yahoo regularly changes > their > > > stock classifications and split information. Go into Auto Analysis > > and run > > > the following Exploration against all stocks. When the > Exploration is > > > finished in the AA window choose File, Export to CVS and Save the > > file into > > > your AmiQuote Directory. Now create a new empty Database and use > > AmiQuote > > > to populate it with the file you saved. You will now have only > Stocks >= > > > $5.00 whose 30 Day Avg Volume is >= $100,000. You could also just > > save this > > > to a Watch List in your primary Database, and then do all you work > > against > > > that Watch List. This has the advantage that any Sector and > Industry > > > Information won't have to be recreated. > > > > > > > > > > > > -----------------------------Exploration Code Begins > > > ----------------------------------------- > > > > > > Filter= Close >= 5 AND EMA( Volume , 30 ) >=100000; > > > > > > > > > > > > Buy=1; > > > > > > Sell=1; > > > > > > AddTextColumn(FullName(),"Name",1.2); > > > > > > AddColumn (Close,"Close",1.2); > > > > > > AddColumn (Volume,"Volume",1.2); > > > > > > > > > > > > -------------------------- Exploration Code Ends > > > ---------------------------- > > > > > > > > > > > > Hope this is what you wanted. > > > > > > > > > > > > Enjoy, > > > > > > > > > > > > Don > > > > > > _____ > > > > > > From: [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> > ps.com > > [mailto:[EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> > ps.com] > > On Behalf > > > Of ax_ray2222 > > > Sent: Monday, July 02, 2007 9:17 PM > > > To: [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> > ps.com > > > Subject: [amibroker] Re: How to use ATC only with positive EPS? > > > > > > > > > > > > Don, thanks for that. Now how can I create my own universe of > stocks > > > from Yahoo and not all 8000 almost what comes with the AB? so if > I > > > like to have only Stocks over $5 and over 100k average volume how > > > would I create that list and than create my new database? > > > any idea? or do you have that already and would you like to share > it? > > > > > > Thank you for that, Ray > > > > > > --- In [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> > > ps.com, "Don > > > Lindberg" <dlindber@> wrote: > > > > > > > > Ray, > > > > > > > > Won't work. The smf-addin is for Excel. The formulas only work > in > > > Excel. You > > > > would have to create some kind of Java Script, or VB Script, > and > > > that is not > > > > for the faint of heart. With some of the programming geniuses > we > > > have it > > > > this group I would think if it were possible someone would have > > > already done > > > > it. If you are not a programmer there is no plug and paste > stuff > > > that will > > > > work. But keep looking, that's how new things happen. > > > > > > > > > > > > > > > > Good Luck, > > > > > > > > Don > > > > > > > > > > > > > > > > _____ > > > > > > > > From: [EMAIL PROTECTED] <mailto:amibroker% 40yahoogroups.com> > ps.com > > > [mailto:[EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> > > ps.com] > > > On Behalf > > > > Of ax_ray2222 > > > > Sent: Monday, July 02, 2007 6:28 PM > > > > To: [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> > ps.com > > > > Subject: [amibroker] Re: How to use ATC only with positive EPS? > > > > > > > > > > > > > > > > Don, I was thinking if we can use smf-addin formulas to > retrieve the > > > > missing data from other web pages direct in the fundamentals > fields > > > of > > > > AB, that will make it so much more powerful.....what do you > think? > > > > > > > > Ray > > > > > > > > --- In [EMAIL PROTECTED] <mailto:amibroker% 40yahoogroups.com> > > > ps.com, "Don > > > > Lindberg" <dlindber@> wrote: > > > > > > > > > > Ray, > > > > > > > > > > I can pull data from the Web into Excel, but there is no way > that > > > I > > > > know of > > > > > that you can do that in AmiBroker. Your off on new territory > and > > > > way beyond > > > > > my skills. > > > > > > > > > > Good Luck, > > > > > > > > > > Don > > > > > > > > > > > > > > > > > > > > _____ > > > > > > > > > > From: [EMAIL PROTECTED] <mailto:amibroker% > 40yahoogroups.com> > > > ps.com > > > > [mailto:[EMAIL PROTECTED] <mailto:amibroker% > 40yahoogroups.com> > > > ps.com] > > > > On Behalf > > > > > Of ax_ray2222 > > > > > Sent: Monday, July 02, 2007 2:24 PM > > > > > To: [EMAIL PROTECTED] <mailto:amibroker% 40yahoogroups.com> > > > ps.com > > > > > Subject: [amibroker] Re: How to use ATC only with positive > EPS? > > > > > > > > > > > > > > > > > > > > Don you are right, but as an exercise....I 'd like to see > what > > > > > results I get and if it comes close to any other data.... > > > > > Do you know of any other way of getting fundamental data from > the > > > > > Internet direct, without using excel? > > > > > Like if EPS is missing from Yahoo to check Zacks page and > > > retrieve it > > > > > with the specified formula? That means I guess to add that > code > > > in > > > > > AmiQuotes somehow.... > > > > > > > > > > Ray > > > > > > > > > > --- In [EMAIL PROTECTED] <mailto:amibroker% > 40yahoogroups.com> > > > > ps.com, "Don > > > > > Lindberg" <dlindber@> wrote: > > > > > > > > > > > > Ray, > > > > > > > > > > > > You are missing the point. If you only pull data that has > > > positive > > > > > value > > > > > > then by default you are eliminating all the stocks that > Yahoo > > > > > doesn't give > > > > > > EPS data on. Given that fact your ATC PE and PS values are > > > BOGUS, > > > > > because > > > > > > they do not include all the stocks in any given Industry!!! > > > > > > > > > > > > > > > > > > > > > > > > It's the old "Garbage In, Garbage Out" For your ATC to be > of > > > any > > > > > value you > > > > > > can't just pick and choose the data you want. Trust me, its > all > > > or > > > > > nothing. > > > > > > Do the math. If an Industry is made up of 100 stocks, but > you > > > only > > > > > use data > > > > > > on 75 stocks because Yahoo doesn't give you data on the > other > > > 25 > > > > > your > > > > > > results ARE NOT indicative of the whole Industry!!!!! > > > > > > > > > > > > > > > > > > > > > > > > Don Lindberg > > > > > > > > > > > > > > > > > > > > > > > > _____ > > > > > > > > > > > > From: [EMAIL PROTECTED] <mailto:amibroker% > 40yahoogroups.com> > > > ps.com > > > > > [mailto:[EMAIL PROTECTED] <mailto:amibroker% > 40yahoogroups.com> > > > > ps.com] > > > > > On Behalf > > > > > > Of ax_ray2222 > > > > > > Sent: Sunday, July 01, 2007 10:20 PM > > > > > > To: [EMAIL PROTECTED] <mailto:amibroker% > 40yahoogroups.com> > > > ps.com > > > > > > Subject: [amibroker] How to use ATC only with positive EPS? > > > > > > > > > > > > > > > > > > > > > > > > How can I write an Industry ATC composite formed only by > the > > > > > positive > > > > > > EPS stocks? > > > > > > -create Industries with ATC formula but if stock has > EPS<=0.01 > > > > > don't add > > > > > > it to composite and > > > > > > -do not count it in the OI counter field, so the Industry > > > composite > > > > > will > > > > > > have the averages formed out of just the positive EPS > stocks. > > > > > > > > > > > > Any idea how this can be achieved? Thank you for any help, > Ray > > > > > > > > > > > > > > > > > > > > >
