|
PureBytes Links
Trading Reference Links
|
Gary,
I also looked at my corrupted files with Downloader and it appeared as
if my only problem was the bad day(s) at the end of the file. I removed
the bad data with Downloader and did the update and all looks good.
Most of the files in that directory did have very large files (most have
30 years of daily data while my Dow daily goes back to 1915). So for me
all systems are go.
Denis Trover
Wooglinx@xxxxxxx wrote:
>
> Gary:
> I hope the following may provide some clues as to what may be associated with
> the current data problem QP2 is having updating MetaStock directories:
>
> In preparation to implement your fix, I used the DownLoader to look at the
> data files for some of the stocks in my directories. What I had hoped to do
> was to delete the data in those stocks which did not pick up the correct data
> on 2/2/2000 and where the date of 5/30/96 was inserted erroneously in last
> night's download. My objective was to reduce the amount of work as compared
> to deleting all the stocks and then having to key in all the names and
> symbols once again.
>
> To my surprise, on attempting to OPEN the data file on a stock with errant
> data (using the MS DownLoader), a report came up saying there was no data in
> the file. And when the report was closed, the opened data file had no data.
> Conversely when I used MetaStock the same stock plotted all the data except
> the bar for 2/2/2000. By comparison, a stock in the same directory that
> properly downloaded yesterday, showed the data when OPENed with the last date
> as 2/2/2000. Of course, the same stock plotted completely including the last
> bar.
>
> I then tried to update all my directories using QP2 (mind you, I was still
> using yesterday's download since I do not want to freshly download data until
> I'm sure my data files are "clean/ready"). The reason I wanted to update was
> to fill the empty data files <dah>. This did not work, i.e., nothing changed.
>
> Now to make things more complex, there was data in these data files earlier
> today! Only the last date in the file and the associated O,H,L,C were wrong.
> The date was 5/30/96. Now there is no data.
>
> Using the techniques of Kepner - Tregoe on problem solving one has to focus
> on "what has changed, what is different now". The ONLY thing I did was to
> focus on one stock in one directory where I have a substantial position. I
> wanted to see the chart updated to include the data of 2/2/00 which would not
> plot. (It had the 5/30/96 date where it should of had 2/2/2000.) Using the
> DownLoader, I made two attempts to purge the data from the one stock data
> file. The first attempt was to delete data PRIOR to 12/1/97 which I had hoped
> would delete the 5/30/96 row. This did not work probably because there were
> dates later than 12/1/97 "in the way". So then I deleted all the data in that
> one file and ran the QP2 update of ALL directories. Walla, the data for the
> one stock plotted correctly in MetaStock. At the time, I did not proceed to
> work on other stocks, hoping you would come up with a simpler, more universal
> fix. (I have about 1,300 stocks in 57 different directories. Just finding
> which ones would be errant appeared to be daunting.)
>
> Rather than delete each of the 1,300 securities, I found a way to delete the
> data in each stock data file and adjusted the first date so that the first
> date and the last date are the same (11/4/96). I also updated all 1,300
> stocks in the 57 directories from QP2 as of 2/2/00 download. Guess what, all
> the data appears to have been updated correctly. I will now proceed to get on
> line and update for today 2/3/00 (I hope without difficulty.)
>
> Now, while all my data appears to be correctly updated as of yesterday, I
> must tell you, I do not feel very secure with the answer you provided in your
> e-mail. Some of my data files on indices go back to 9/3/91 and they now are
> correct. That's a very large file. This leads me to believe there may be
> something else contributing to the problem. Could it be that some flag is not
> set properly or becomes errant from time to time? Why would some data be
> correct and others not correct when the start dates (file size) are the same?
> I hope this helps in some way. I spent 5 hours tonight chasing this problem
> and re-initializing the start dates on all my files. I hope there is a more
> fundamental answer / correction to QP2 because I do not want to go through
> this again.
>
> Good hunting,
>
> Jim Barone
|