|
PureBytes Links
Trading Reference Links
|
In downloader, you should be able to import excel data to MS format (as far
as I remember) and then downloader also has a feature (again I think) to
copy the imported data to create MS data files. Assuming it is daily data,
you should be able to do this at one shot for all the 180 securities.
To make sure the formatting is ok, you can chart the data from the data file
you have created and if it does not look ok, you can view the data of one
security by opening it in downloader (which opens in spreadsheet format),
determine what needs to be formatted, go back to your excel file and format
and repeat the import and copy process to create the appropriately formatted
MS data file.
This is all from memory, as I do not use MS or downloader for a long time.
Good luck
Harish
----- Original Message -----
From: "Hugh Valliant" <valliant@xxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Thursday, July 04, 2002 12:18 PM
Subject: Excel to MetaStock assistance
>
> Each day I download some eod data for some 180 different securities into
an
> Excel worksheet. Securities are by rows
>
> I would like to transfer, by an automated means, into MetaStock 6.52
>
> Can I use the downloader to do this?? Any ideas? Do I need to rearrange
> into columns
>
> Or do I have to copy and paste each set of data individually.
>
> TIA
>
> Hugh
>
>
> \\\\!////
> \\ _ _ //
> ( @ @ )
> -------------------------oOO--(_)--OOo-------
>
> MI-COM Technology
> Computer Solutions for Small Business
> Helping you access and travel the Information Highway
>
> Hugh A. Valliant
>
> Bus. (416) 726-5355 Fax. (416) 693-1149
>
> E-mail valliant@xxxxxxxxxxxxx
> valliant@xxxxxxxxxxxxxx
> http://www.mi-comtech.com/
> ICQ UIN 4366968
>
>
|