Importing Intraday Data to Amibroker using TimeShift

AmiBroker
#1

Hi,

I am trying to import intraday data. Below is how my 1 minute data looks from data provider.. So first candle starts from 9:15 AM. So first candle data is actually from 9:15:00 to 9:15:59 and it is labelled as 9:15 currently.

20180606,09:15,1285.10,1286.00,1278.70,1280.65,2401,0
20180606,09:16,1279.25,1280.15,1275.10,1276.85,1783,0
20180606,09:17,1277.25,1278.20,1274.55,1277.00,3903,0
20180606,09:18,1275.75,1278.85,1275.75,1277.30,748,0
…………
……..
……….
20180606,15:25,1315.50,1315.70,1313.00,1314.15,685,0
20180606,15:26,1314.00,1315.80,1313.60,1314.35,579,0
20180606,15:27,1314.85,1314.85,1314.00,1314.00,1102,0
20180606,15:28,1314.00,1314.85,1311.60,1314.85,1605,0
20180606,15:29,1314.40,1315.75,1311.05,1314.85,1015,0

What I want is I want first candle in the chart to be timed as 9:15:59 instead of 9:15:00. Most reputed charts like from Investing.com or Sharekhan use this format. How to achieve that ? I have to shift time to 59 seconds. Please help on how to achieve this. I did try but nothing clicked.. After achieving the shift then my first candle time would be 9:15:59 and last candle would be 9:29:59.

Below is my formatter I am using.. Notice that I am using Timeshift, but that didn't help.. How did I get that value ? I did 1/60 and then the result I got I again divided by 60 then the final result I multiplied by 59, which means shifting time to 59 seconds.

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

Thanks,
Vinay

#2

Hi,

What are your Tools > Preference > Intraday settings?

Untitled

Time compressed bars shows: ◦time of FIRST tick inside bar - when selected the bar gets the time stamp of the very first trade inside given time slot (bar)

◦time of the LAST tick inside bar - when selected the bar gets the time stamp of the very last trade inside given time slot (bar)

◦START time of the interval - when selected the bar is time-stamped with start time of the time slot (bar). Lets say that 30 minute bar covers 9:00:00..9:29:59. When this is selected AmiBroker will display time of this bar as 9:00

◦ END time of the interval - when selected the bar is time-stamped with start time of the time slot (bar). Lets say that 30 minute bar covers 9:00:00..9:29:59. When this is selected AmiBroker will display time of this bar as 9:29:59

2 Likes
TimeStamp problem
#3

Thanks for your quick reply.. That was fast... I changed from START time of interval to END time of interval...