Importing ASCII Intraday data with AM / PM

AFL Programming
#1

I am trying to import intraday data that has the AM or PM designation. When the data imports and is plotted, when the time changes from 12:57 PM to 1:00 PM, the 1PM bar is identified as 1AM. How do I format it in the Import Wizard to correctly read it as PM or switch to military time?

Thank you,

Mike

image

#2

Format it in Excel then import.

#3

Thanks but I think there must be a way to format it directly within Amibroker. As a failsafe Excel is a solution.

Thanks,

Mike

#4

Format it using afl and check out batch.
https://www.amibroker.com/guide/h_batch.html

#5

If you use AM/PM your range must be

00:00:00 to 11:59:59

12:01:00 == 00:01:00 PM

#6

The intraday day data is generated by Esignal's Export feature and cannot be changed and is a CSV I am trying to import. I see on various posts the Import Wizard will accept multiple formats, "$Format Time_" . Is there a way to format the time so that when the Import Wizard imports it, it will interpret or change the times from AM/PM to 24-hour time? If the Import Wizard cannot do this I will look to the above posts.

Thanks,

Mike