| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/31/2004
Posts: 163
|
Hi Craig,
I need to export data from Telechart. The date format is MM/DD/YYYY or YYYYMMDD. I am trying to load the data into another software package the only understands date format of DDMMYYYY.
My output layout is:
Symbol,Stock Name,Date,Open,High,Low,Close,Volume
Do you know if anyone has a program that will read the file output from Telechart in the above format and change the date from YYYYMMDD to DDMMYYYY and output all fields with the new date format?
Jeremy at support@worden.com suggested the Telechart Developer's Kit. I haven't used it so I don't know much about it.
Bill
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Do you have Excel? I can't actually provide support on how to use a third party product, but you should be able to use the Import Wizard to bring the exported data into Excel. You can then change the Column format and use Save As to get a CSV file with the desired date format.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/31/2004
Posts: 163
|
Hey Bruce,
I think I was able to change the format using the 'custon' format.
What I did was selected the column, then Format Cells (I loaded these cells as MDY format - this is important because you won't be allowed to change a General cell format to a Date format), then I entered a new format ddmmyyyy.
AND Excel changed the dates!
I loaded the file into the new program and the chart looked great.
Bill
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I'm happy to read you were able to figure it out.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |