Fix opening bar oddity when downloading google data

#1
I’ve been downloading data from google. I download 5 minute bar data using AmiQuote. Win7 64 Amibroker 5.80.3 AmiQuote 3.04

The odd thing is that a small horizontal bar represents the opening price, but it does not join the opening candle and stands alone. The first 5 minute bar is somehow created (I don’t know how) without the opening price. Sometimes this changes the type of candle. It also offsets the time of the entire day. So, the end of each day is 4:04:59.

I have attached an image to make it clear as to what I'm referring to.

Downloading the data in 1 minute bar intervals fixes the data, but it does not fix old data that is no longer available for download.

The data is broken in this manner. When I download the data from google, the first five minute data contains just the opening price. Like so:

2014-09-12,09:30,99.57,99.57,99.57,99.57,32347
2014-09-12,09:35,99.4025,99.96,99.4,99.54,10505

As you can see, the first dataset at 9:30 shows only the opening price of 99.57, instead of the correct OHLC data (which is contained in the dataset at 9:35).

So, as per the above data, Amibroker displays the first bar of the day ending at 9:40:59. Which is incorrect.

Ok, if anyone is still with me they deserve a medal.:D

My question is, has anyone created a script or some fix for old data that has this issue?

Thanks.
 

Attachments

Last edited:

Similar threads