|
PureBytes Links
Trading Reference Links
|
Walter,
Have you tried to save the file in CSV format from Excel and have
Downloader read the *.CSV file. (CSV is a pure text file with fields
separated by commas).
Then change the settings in downloader to:
Under TOOLS/CONVERT change Source file type to ASCII, type in the folder
name where your CSV file is, and under filename you can click on Browse and
pickup your *.CSV file.
Destination is MetaStock file type, and do type in your data folder
(Metastock data)
Now click on Options and pick Daily from SOURCE tab, then under Destination
tab I have Append to Existing file and replace matching data selected as
well as include Open and Open interest.
If you are creating a file that does not exist, check Create new file.
That is the procedure I use everyday. and it works.
Hope this helps.
Fred
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Walter Lake
> Sent: Thursday, April 22, 1999 6:49 AM
> To: Metastock bulletin board
> Subject: Convert Excel 97 data to MS
>
>
> Hi Ton et al
>
> I have a nice simple (no code, functions, etc.) data worksheet,
> consisting
> of the following columns: date-O-H-L-C that I want to transfer
> from Excel 97
> to MS.
>
> Nothing is working.
>
> This is what the data looks like:
> 5/29/92 1,803 1,803 1,794 1,798
>
> It is saved into an Excel 4.0 format as per instructions.
>
> The Downloader Manual says on page 72:
>
> " ... MetaStock cannot directly convert Excel 5.0 files. Therefore, to
> convert an Excel 5.0 or 7.0 file, you simply use Excel's Save As
> command in
> the File menu to save the spreadsheet in an Excel 4.0 worksheet format.
> ..."
>
> Does anyone have a working system?
>
> Best regards
>
> Walter
>
>
>
>
>
|