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