|
PureBytes Links
Trading Reference Links
|
In fact you don't even need to do the last part if you've already removed
the colons in the text editor-so all you need to do is:
Select the entire spreadsheet and paste it to a text editor like notepad.
Do a search and replace to remove the colons from the time column.
Save it as a .txt file.
Open this file in excel. It should be in delimited format with tabs
separating each field.
Jim
----- Original Message -----
From: "Jim" <g67j3sq245qlo@xxxxxxxxxxx>
To: <omega-list@xxxxxxxxxx>; "Zoran Gayer" <elliottwave@xxxxxxxxxxxxxxxx>
Sent: Sunday, August 18, 2002 3:59 PM
Subject: Re: [MTList] Time problem in ASCII data file
> Zoran
>
> Try the following:
>
> Select the entire spreadsheet and paste it to a text editor like notepad.
> Do a search and replace to remove the colons from the time column.
> Save it as a .txt file.
> Open this file in excel. It should be in delimited format with tabs
> separating each field.
> On the last step of this import wizard make sure you select "text" for the
> column data format, for this column.
>
> Hope that helps/works
>
> Jim
>
>
> ----- Original Message -----
> From: "Zoran Gayer" <elliottwave@xxxxxxxxxxxxxxxx>
> To: <omegalist@xxxxxxxxxxx>
> Cc: <omega-list@xxxxxxxxxx>
> Sent: Sunday, August 18, 2002 3:21 PM
> Subject: RE: [MTList] Time problem in ASCII data file
>
>
> > Tried that - as soon as you do that it changes the value.
> > Try this it will show the problem.
> > Open an EXCEL spread sheet.
> > Put in 15:30 in hh:mm format.
> > You can then change that into 1530 by changing it with hhmm format
> > procedure.
> >
> > Then the obvious thing is to change it text format.
> > That gives you 0.645833. You have lost 1530 which is what you want.
> >
> > Trade Station to function correctly in ASCII needs to read the numbers
> > 1530 in text format. Hence the problem, how do I get from 15:30 time
> > format to 1530 text format?
> >
> > This must be a common problem to anyone handling ASCII files in Trade
> > Station 2000i. There got to be a simple way around this but the
> > solution escapes me.
> >
> >
> > Zoran
> >
> >
> >
> > -----Original Message-----
> > From: Mike Marcott [mailto:omegalist@xxxxxxxxxxx]
> > Sent: Sunday, August 18, 2002 11:40 PM
> > To: 'Zoran Gayer'
> > Subject: RE: [MTList] Time problem in ASCII data file
> >
> > Zoran,
> >
> > After changing the number to 1530 try selecting the column and choose
> > format but this time try "Text". Let me know if that helps. Good Luck.
> >
> >
> > _____________
> > Best Regards,
> >
> > Mike
> > mailto:omegalist@xxxxxxxxxxx
> >
> >
> > > -----Original Message-----
> > > From: Zoran Gayer [mailto:elliottwave@xxxxxxxxxxxxxxxx]
> > > Sent: Sunday, August 18, 2002 7:50 AM
> > > To: omega-list@xxxxxxxxxx
> > > Subject: FW: [MTList] Time problem in ASCII data file
> > >
> > >
> > >
> > >
> > > Steve,
> > >
> > > That is the problem, when I do that it changes value
> > >
> > > It takes 15:30 which was formatted in time and changes it to
> > > 1 not 1530
> > > I can change the format from 15:30 to 1530 by changing hh:mm
> > > to hhmm but
> > > that does not change the time format.
> > > I need to change 1530 time format to 1530 number format
> > > without changing
> > > the number 1530 into something else.
> > > It has to be simple; everything I tried does not work.
> > > I have hade the problem a month now and sure am frustrated as hell.
> > >
> > > I need to do my chart analysis and I have this formatting problem that
> > > stopping me getting at my charts on the US market.
> > > I think the problem started when quote.com changed the format
> > > from 1530
> > > to 15:30. However, I am not sure of that.
> > > It started a month or so ago.
> > >
> > > I could not solve the problem for I looked at the first few lines and
> > > they were OK. The format was good.
> > > It is later when I started to look at the specific data that I noticed
> > > that the later entries had to 15:30 not 1530.
> > > I thought I had the problem licked but then I found I could not change
> > > the 1530 time format into a number format without altering the number
> > >
> > > Trade Station will only read this position in an ASCII file only as a
> > > number format column.
> > > I even tried using CSV in MS DOS and older Excel formats and
> > > cannot get
> > > way from it.
> > >
> > > I am stumped
> > >
> > > Zoran
> > > .
> > >
> > >
> > > -----Original Message-----
> > > From: Steven W. Poser [mailto:sposer@xxxxxxxxxxxxx]
> > > Sent: Sunday, August 18, 2002 9:28 PM
> > > To: 'Zoran Gayer'
> > > Subject: RE: [MTList] Time problem in ASCII data file
> > >
> > > Zoran - Try highlighting the column, then click on the format item on
> > > your menu, then choose cells, number, and make decimal places
> > > "0". That
> > > should do it. Steve
> > > -----Original Message-----
> > > From: Zoran Gayer [mailto:elliottwave@xxxxxxxxxxxxxxxx]
> > > Sent: Sunday, August 18, 2002 4:08 AM
> > > To: mtalist@xxxxxxx
> > > Subject: [MTList] Time problem in ASCII data file
> > > Need help on something that may be simple to do.
> > >
> > > I have DOW data in 5-minute format.
> > >
> > > The problem is that the time for Trade Station 2000i needs to be
> > > expressed as a number and not formatted to time.
> > >
> > > The data I have is in CSV data file. The time was expressed in this
> > > format '9:30'.
> > > I can reformat the time column in the Excel to read in the required
> > > format that is '930' but it does not change the underlaying
> > > time format
> > > to a number.
> > > Trade Station thus continues to read it as time and not as a number.
> > >
> > > Does anybody know how to get rid of (:) in the '9:30' so that it reads
> > > '930' as a number and not as time '930'.
> > >
> > > If I can convert one these (:), then I may be able to convert all the
> > > other times in the file from a time number to a normal number.
> > > Then my Trade Station will read the ASCII CSV file OK.
> > >
> > > I sure this must be simple but the method escapes me.
> > >
> > >
> > > Zoran
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
|