|
PureBytes Links
Trading Reference Links
|
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
>
|