|
PureBytes Links
Trading Reference Links
|
I have a program that will convert any Ascii data format to
Tradestation format AND take care of the timestamps and check
the data for any of 21 possible errors.
It will process 10MB of data in seconds. much easier than using
the clipboard!
On 18 Aug 2002, at 22:49, Zoran Gayer wrote:
> 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
>
Regards
Mike
|