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

Re: Question on converting multiple stocks in Downloader



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