Re: WOW....This may be TOO much

[acs64@xxxx]

Thanks David, I'll give it a try tonight. I've got to re-evaluate my 
system with respect to the database size. Both uploading speed and 
processing speed. I'm pretty sure if I want to work with over 9,000 
in a database, I'll need to have more horsepower.

What would be the minimum recommendation for handling this size of 
database in regards to transmission speed and processing speed. 
Anyone know?

Larry
--- In amibroker@xxxx, "David Holzgrefe" <dtholz@xxxx> wrote:
> Larry heres on I use just change the price range to suit
> 
> 
> /*pricerangefinder
> David Holzgrefe
> 24.02.2001*/
> 
> lowprice = close>1.00; //low price
> hiprice= close<5.50; // high price
> hirange = lowprice <= hiprice;
> lowrange = hiprice >= lowprice;
> 
> buy = hirange and lowprice;
> 
> sell = 0;
> 
> 
> Regards David
> ----- Original Message -----
> From: <acs64@xxxx>
> To: <amibroker@xxxx>
> Sent: Tuesday, May 22, 2001 3:47 AM
> Subject: [amibroker] Re: WOW....This may be TOO much
> 
> 
> > Hi Carlton,
> >
> > Can you give me an example of the filtering script you use? 
Thanks
> >
> > Larry
> >
> > --- In amibroker@xxxx, "Carlton McEachern" 
<carlton.mceachern@xxxx>
> > wrote:
> > > I carry the entire Toronto and Vancouver Stock Exchange list in 
my
> > database.
> > > I also carry a database of all mutual funds available in Canada.
> > Data
> > > import used to be pretty slow but Thomaz fixed that early on in 
the
> > > development of AmiBroker. One thing I do with analysis is 
filter
> > out
> > > equities not in my price range - ie I usually exclude equities 
over
> > $40 CAD
> > > but I still want them in my database for the day I can afford 
them
> > in volume
> > > (eternal optimist). I usually filter out equities under $1.00 
as I
> > am not
> > > interested in the penney market but I still want them in my
> > database as
> > > there are a lot of tech startups and biotechs in that price 
range
> > which may
> > > be the next big thing. In short, I want a complete database 
but I
> > filter
> > > out by price to suit my trading patterns. Filtering with AFL is
> > easy in the
> > > analysis window using the < > functions. If you have the hard
> > drive space
> > > and computing power you might want to consider doing the same.
> > >
> > > THE CRAZY CANUCK
> > >
> > >
> > > CARLTON McEACHERN
> > > BOX 259, RR #1
> > > ASTORVILLE, ONTARIO
> > > P0H 1B0 CANADA
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: acs64@xxxx [mailto:acs64@x...]
> > > Sent: Sunday, May 20, 2001 9:18 PM
> > > To: amibroker@xxxx
> > > Subject: [amibroker] WOW....This may be TOO much
> > >
> > >
> > > Hello All,
> > >
> > > Now that I have this mega-database of over 9,000 stocks, what 
do I
> > do
> > > with it? I'm thinking that daily updates with this size of 
database
> > > may be too time consuming. Historical updates sure have taken 
some
> > > time. Any suggestions out there for culling it back to a more
> > > manageable size and what a manageable size might be based on 
your
> > > experience?
> > >
> > > I'd like to keep key representatives from different sectors and
> > > industries maybe.....Is it possible to automate, with any of 
Ami's
> > > language, a means of keeping the best and dumping the rest? I'm
> > very
> > > curious what others may have done or what their approach to data
> > > overload is. Thanks in advance.
> > >
> > > Larry
> > >
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to 
http://docs.yahoo.com/info/terms/
> >
> >