|
PureBytes Links
Trading Reference Links
|
Sashi,
Glad you succeeded!
I suggested copying to two folders and keeping the original untouched
only to "be on the safe side".
The Merge is used mainly in case the single security changed it's
symbol, thus the mass merge is impossible.
Regards,
Zvi
----- Original Message -----
From: "Shashi Aggarwal" <shashiag@xxxxxxxxxx>
To: "Metastock Digest (E-mail)" <metastock@xxxxxxxxxxxxxxxxxx>
Sent: Thursday, September 20, 2001 7:08 PM
Subject: Data Issue resolved
> Zvi,
>
> Thanks. Yours was the best suggestion. But I modified it slightly in
that
> instead of copying to 2 folders, I just copied to one folder;
deleted data
> after 9/10/01 in the original folder and before 9/17/01 in the new
folder,
> then used Tools\Convert to merge the 2 data sets. (When I tried
using the
> Merge command, it only lets you select 1 security at a time, not
thousands
> as in my case. You cannot select multiple securities using either
Shift or
> Ctrl keys; I guess Equis never thought one would be merging
thousands of
> securities).
>
> Even though last week's situation was unusual, I do think Equis
should have
> an option in the Downloader allowing one to delete data from a range
of
> dates, not just Before or After a particular date, so one doesn't
have to do
> it in this convoluted way. I have passed this suggestion on to
them -
> hopefully, they will do something about it!
>
> Shashi
>
>
> ------------------------------
>
> Date: Wed, 19 Sep 2001 12:22:11 +0200
> From: "Zvi Oren" <consilium@xxxxxxxxxxxxx>
> Subject: Re: Data issue
>
> Shashi,
>
> To delete those days:
>
> 1. Copy your data from the original folder into two additional
folders
> (using Windows Explorer or, better, DownLoader's Tools/Copy).
> 2. In the 1st new folder delete all data before 9/15, in the 2nd -
> delete all data after 9/10.
> 3. In the DownLoader use Tools/Convert: Source - MetaStock, 1st
> folder; Destination - MetaStock, 2nd folder (check all
> securities).
> 4. Delete the original folder, rename 2nd folder to original.
>
> Regards,
> Zvi
>
> - ----- Original Message -----
> From: "Shashi Aggarwal" <shashiag@xxxxxxxxxx>
> To: "Metastock Digest (E-mail)" <metastock@xxxxxxxxxxxxxxxxxx>
> Sent: Wednesday, September 19, 2001 1:23 AM
> Subject: Data issue
>
>
> > The US markets were closed from Tuesday to Friday last week, as we
> all know.
> > When I downloaded the data on Monday evening (9/17) from my data
> provider
> > (Telescan), instead of there being NO price/volume data for any
> stock for
> > those dates, I see that all 4 days have the closing price of
Monday
> listed
> > for these 4 non-trading days and volume listed as zero i.e. there
IS
> data
> > where there should be none, and its all nonsensical.
> >
> > Possible solutions I can think of:
> > 1) If I delete the data after Sep. 10th and download again, I
again
> get the
> > same result, so that doesn't help.
> > 2) Another solution is to open the data file for each symbol
> individually
> > and then delete the rows corresponding to Sep. 11 - Sep. 14.
> However, this
> > is a gargantuan task considering that thousands of stocks are
> involved.
> >
> > Metastock's Downloader does not give an option to delete data from
a
> > preselected date range, only Before or After a particular date
> > (Tools\Delete\Data). Anyone have any idea how to get rid of data
for
> these 4
> > dates (9/11 - 9/14) quickly and efficiently, while preserving all
> data
> > before and after those dates? Thanks in advance.
> >
> > Shashi
> >
>
|