|
PureBytes Links
Trading Reference Links
|
Hi David.
Save the Excelfile with all your quotes in a csv-file and then convert the file in the Downloader and mark the box Traverse
Destination Folders in the Destinationtabb. This work fine for me.
Best regards.
Lars
David Bozkurtian skrev:
> 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
|