Ray, Are you on Dial Up or Broad Band. I can do both the Basic Fundamentals and Extended Fundamental on the whole data base in about 1.5 hours. I only run these once a week, as the data does not change that often. I use ATT DSL, which is very reliable, cost me $20 month and gives me transfer rate of about 1.5MPS. If you are on Dial Up, than the numbers you are talking are very normal.
Don Lindberg _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of ax_ray2222 Sent: Wednesday, July 04, 2007 2:58 PM To: [email protected] Subject: [amibroker] Re: How to use ATC only with positive EPS? Prash, thank you for that. It seems that the 1 day update for the 7000 symbols from Yahoo takes more than an hour. Is that right? Also to download the Fundamentals have to leave it running over night....It seems to me that something is not working properly....any idea what can be? Ray --- In [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com, "Prashanth" <[EMAIL PROTECTED]> wrote: > > Your exploration contained a Fitler which targetted scrips with volume greater than 100K. > > Do this to get a number of scrips > > Filter=1; > Addcolumn(c,"C"); > > Cheers > > Prashanth > ----- Original Message ----- > From: ax_ray2222 > To: [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com > Sent: Wednesday, July 04, 2007 8:00 PM > 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 > > > > > > > > > > > > > > > > > > > > >
