Importing Telechart as ASCII data fails
Author: devans
Creation Date: 9/9/2008 11:35 AM
profile picture

devans

#1
I'm importing an export from telechart that has the following format:

Symbol Date Open High Low Close Volume
A 09/08/2008 33.38 33.52 32.57 32.97 21788
A 09/05/2008 32 32.92 31.75 32.79 23016
A 09/04/2008 33.52 33.53 32.14 32.18 26155
A 09/03/2008 34.35 34.5 33.36 33.81 27580
A 09/02/2008 35.09 35.7 34.29 34.49 20576
A 08/29/2008 35.28 35.31 34.62 34.76 16677

I add a Filler before Date and change the date format to dd/MM/yyyy per the
webpage referenced in the "Formats Help..." section: http://msdn.microsoft.com/en-us/library/8kb3ddd4(VS.71).aspx

I get the following error after clicking "Next->" when specifying the format:

Parse Error
The DateTime represented by the string is not supported in the calendar System.Globalization.GregorianCalendar.
File: ...\A.txt
Line: 5
Field: 08/29/2008
Field Name: Date (or Date with Time)
Field Type: Date

I think it should import this just fine, am I doing something obviously wrong?

Thx in advance

dce
profile picture

Cone

#2
The format of your Date field is MM/dd/yyyy, not dd/MM/yyyy.
profile picture

devans

#3
omg. Maybe I need to pay attention to what I'm actually doing.

Thx cone.

dce