|
PureBytes Links
Trading Reference Links
|
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
|