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

RE: Database maintenance



PureBytes Links

Trading Reference Links

The max # of days storable in QP is now 3000, Alain.
A scan showed that 40 have the current max [2360 days] and that
there is a large peak near 1850 days [7.6 years].
Minimum days     	# of symbols
2360				  40
1800			    	3317
1700				3476
1600				3606
1500  			3782

Bob

bjagow@xxxxxxx <mailto:bjagow@xxxxxxx>


-----Original Message-----
From: owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Alain Jossart
Sent: Tuesday, May 04, 1999 1:44 AM
To: metastock@xxxxxxxxxxxxx
Subject: Re: Database maintenance



(1) If max 2200 days of historical data is convenient, maybe have a look at
Quote Plus data service.

(2) Otherwise, Equis MSFL and some programming skills (VB/VC/Delphi) is the
path to freedom :)
_________________________________________________
At 09:31 3/05/99 -0400, Robert Duplain wrote:
>I'm looking for a simple and rapid way to clean my Metastock database.
>I have some 16000 stocks in the database in 90 directories.  Many of the
>stocks are now inactives or dead and the quotes are not anymore updated.
>I want to delete from my database all those inactive stocks and regroup the
>remaining stocks in less directories.
>Using Downloader for this task is quite hurdle as we cannot sort the stocks
>by dates and then use the delete function to delete obsolete stocks in a
>block.  So we have to delete one at the time.  It would take weeks.
>
>Do anybody know a better way to do the job ?
>
>I heard about an Equiis database maintenance program.  Did anybody used it
>? Would it easily do the job?
>
>Thanks
>Robert
>
>