|
PureBytes Links
Trading Reference Links
|
Just use in the header <DTMM/DD/YY> (or what is it your date format) -
see the DownLoader's manual.
Zvi
----- Original Message -----
From: "Glen Wallace" <gcwallace@xxxxxxx>
To: "MetaStock listserver" <metastock@xxxxxxxxxxxxx>
Cc: "Ken" <iamken@xxxxxxxxxxxxxxx>
Sent: Wednesday, March 20, 2002 4:49 AM
Subject: Re: converting non comma separated ASCII data into MSWIN
format
> I've had this problem, too. I can get almost all the way there, but
> I could never solve the problem with the "time" field, though.
> Here's where I get to ...
>
> 1. The text file can be converted to a standard Excel file using
> the "fixed width" data type.
> 2. Use yy/mm/dd as the date format and the file should open
> showing your standard date format (mm/dd/yy, probably).
> 3. Add column headings (DATE, TIME, OPEN, etc.).
> 4. Save the file in, say, Excel 4.0 format.
> 5. The file will now convert to MetaStock file format using
> DownLoader, but the time field is messed up.
>
> Any ideas?
>
>
>
> ----- Original Message -----
> From: "Denis Trover" <dtrover@xxxxxxxxxxxxx>
> To: <metastock@xxxxxxxxxxxxx>
> Sent: Tuesday, March 19, 2002 4:38 PM
> Subject: Re: converting non comma separated ASCII data into MSWIN
format
>
> > Ken,
> >
> > Have you tried using the Text Import Wizard in Excel and setting
the
> > delimiters as space and/or tab? I think that should work.
> >
> > Denis
> >
> >
> >
> > "iamken@xxxxxxxxxxxxxxx" wrote:
> >
> > > Hi,
> > >
> > > I have a boatload of non comma separated ASCII data that I need
to
> > > convert into Metastock format, but I don't know how to get
commas
> > > between the fields. My feeble attempts to do this in Excel have
failed,
> > > but I think there must be a painless way to do this? Any help
would be
> > > appreciated.
> > >
> > > Here's a sample of what I am working with.
> > >
> > > 19971201 925 118.71875 118.71875 118.71875 118.71875 2
> > > 19971201 951 118.71875 118.71875 118.71875 118.71875 1
> > > 19971201 954 118.78125 118.78125 118.78125 118.78125 1
> > >
> > > Thanks!
> > > Ken
>
|