Correct format to express '00:00:00' for Import ASCII?

AmiBroker
#1

I've tried to Import ASCII for a hourly intraday market data,
my data format as follows:
// Ticker, Date, Time, O, H, L, C, V
AAA,20191231,220000,1198,1201,1196,1200,120
AAA,20191231,230000,1200,1201,1199,1199,552
AAA,20200101,000000,1199,1200,1198,1199,314
AAA,20200101,010000,1199,1200,1199,1200,151

My problem is :

  1. Symbol -> Quote Editor:
    Every 'Date' column value for Time '000000' becomes only 'Date' and no 'Time'.
    for example:

    'Date' column for data row "AAA,20191231,230000,1200,1201,1199,1199,552"
    becomes 2019/12/31 23:00:00 (every thing is perfect).

    'Date' column for data row "AAA,20200101,000000,1199,1200,1198,1199,314"
    becomes 2019/01/01 (there is no time expression).

  2. Chart window:
    When I click a bar before '22:30:00', every thing is normal.
    but after I hit a [right arrow key] from the bar with time '22:30:00',
    then the vertical line jumped to '00:30:00' of the next day.

I guess, Import ASCII does not accept time '000000' as '00:00:00'.
Q) Does any one know
what is the correct format to express '00:00:00' for Import ASCII?

Thank you very much :slight_smile: !

#2

My format file for 'Import ASCII' as below:

$FORMAT Ticker, Date_YMD, Time, Open, High, Low, Close, Volume, Skip
$SKIPLINES 1
$SEPARATOR ,
$AUTOADD 1
$CONT 1
$DEBUG 1
#3

Is your database set to intraday interval ?

#4

I've set 'Base time interval' as 'Hourly' :smiley:!
image

image

Strange actions when 'Base time interval' is 'Hourly'?
#5

Found no problem importing 00:00:00
ASCII file

AAA,20191231,220000,1198,1201,1196,1200,120
AAA,20191231,230000,1200,1201,1199,1199,552
AAA,20200101,000000,1199,1200,1198,1199,314
AAA,20200101,010000,1199,1200,1199,1200,151
AAA,20200101,020000,1199,1200,1199,1200,151
AAA,20200101,030000,1199,1200,1199,1200,151
AAA,20200101,040000,1199,1200,1199,1200,151
AAA,20200101,050000,1199,1200,1199,1200,151
AAA,20200101,060000,1199,1200,1199,1200,151
AAA,20200101,070000,1199,1200,1199,1200,151
AAA,20200101,080000,1199,1200,1199,1200,151
AAA,20200101,090000,1199,1200,1199,1200,151
AAA,20200101,100000,1199,1200,1199,1200,151
AAA,20200101,110000,1199,1200,1199,1200,151
AAA,20200101,120000,1199,1200,1199,1200,151
AAA,20200101,130000,1199,1200,1199,1200,151
AAA,20200101,140000,1199,1200,1199,1200,151
AAA,20200101,150000,1199,1200,1199,1200,151
AAA,20200101,160000,1199,1200,1199,1200,151
AAA,20200101,170000,1199,1200,1199,1200,151
AAA,20200101,180000,1199,1200,1199,1200,151
AAA,20200101,190000,1199,1200,1199,1200,151
AAA,20200101,200000,1199,1200,1199,1200,151
AAA,20200101,210000,1199,1200,1199,1200,151
AAA,20200101,220000,1199,1200,1199,1200,151
AAA,20200101,230000,1199,1200,1199,1200,151
AAA,20200102,000000,1199,1200,1198,1199,314
AAA,20200102,010000,1199,1200,1199,1200,151
AAA,20200102,020000,1199,1200,1199,1200,151
AAA,20200102,030000,1199,1200,1199,1200,151
AAA,20200102,040000,1199,1200,1199,1200,151
AAA,20200102,050000,1199,1200,1199,1200,151
AAA,20200102,060000,1199,1200,1199,1200,151
AAA,20200102,070000,1199,1200,1199,1200,151
AAA,20200102,080000,1199,1200,1199,1200,151
AAA,20200102,090000,1199,1200,1199,1200,151
AAA,20200102,100000,1199,1200,1199,1200,151
AAA,20200102,110000,1199,1200,1199,1200,151
AAA,20200102,120000,1199,1200,1199,1200,151
AAA,20200102,130000,1199,1200,1199,1200,151
AAA,20200102,140000,1199,1200,1199,1200,151
AAA,20200102,150000,1199,1200,1199,1200,151
AAA,20200102,160000,1199,1200,1199,1200,151
AAA,20200102,170000,1199,1200,1199,1200,151
AAA,20200102,180000,1199,1200,1199,1200,151
AAA,20200102,190000,1199,1200,1199,1200,151
AAA,20200102,200000,1199,1200,1199,1200,151
AAA,20200102,210000,1199,1200,1199,1200,151
AAA,20200102,220000,1199,1200,1199,1200,151
AAA,20200102,230000,1199,1200,1199,1200,151
AAA,20200103,000000,1199,1200,1198,1199,314
AAA,20200103,010000,1199,1200,1199,1200,151

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Date_YMD, Time, Open, High, Low, Close
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1

import

1 Like
#6

If there is no 00:00:00 after the date in Quotations Editor, then it may be interpreted as an EOD quote (end of day).

Check the EOD column to see if EOD is on that quote line.

Also turn on the 'check' setting in File/Database settings.../Intraday settings/Allow mixed EOD/Intraday data and see what happens.

Lou

1 Like