PureBytes Links
Trading Reference Links
|
Denis,
I tried a couple of scenarios:
1. Tried to import the "concatenated" file (full file 700+ records with
different values in the TICKER column. It did the same thing. Namely bunched
them all up into a single MS data file CACS.
2. Tried to import multiple xls files at once. These were the raw files from
quote.yahoo.com. This works fine, but prompts me for each ticker symbol. I
wonder if there is a way for MS to automatically pick up the TICKER from the
name of the file. The files are CACS.xls and KEA.xls.
3. Tried to import multiple xls files. This time I opened the XL files in MS
Excel and added the ticker symbol in its own column. Some work up front, but
no problem importing in MS.
I think I'll use method 3 and automate the part where I manually update the
TICKER column in the Excel file.
Just another note. It seems that the safest thing to do with these downloads
is to delete all the data and start from scratch everyday. Is this correct?
It makes sense if there were any adjustments or splits, etc.
Yes I am using version 6.52. Picked it up from ebay for $220.
Thanks for your input.
David
From: Denis Trover <dtrover@xxxxxxxxxxxxx>
Reply-To: metastock@xxxxxxxxxxxxx
To: metastock@xxxxxxxxxxxxx
Subject: Re: Question on converting multiple stocks in Downloader
Date: Fri, 04 Feb 2000 11:51:25 -0800
David,
I just tried using Convert on the file of four entries you posted and,
much to my surprize, it made up two new MetaStock files each with two
entries with data in correct order. After that I made up another file
with two entries for each stock with the two following days in each case
ans again used Convert. Everything worked well. I don't understand why
you are getting the results that you are. I am using Version 6.52 of
the Downloader EOD. Is yours the same version?
I rarely use the Download program as my data supplier is QuotesPlus and
they automatically update my MetaStock files.
Denis Trover
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
|