Daily (EOD) date for NZX data is out by one day in Amibroker

The date shown for daily NZX data downloaded via Yahoo in AmiQuote is out by one day in AmiBroker i.e. yesterdays close (19/5) is showing as 18/5.

I found a post with this problem back in 2017 relating to the ASX market, and there was no solution to the problem at the time. With the passing of nearly 10 years, I'm checking whether there a setting that I have not found to correct this, or a workaround?

East coast of Australia and New Zealand time zones differ by 2 hours, so a solution for the ASX should work for the NZX also.

There was solution given in the old thread. Please search the forum. Now all downloaders are customizable and you can subtract any time difference in JavaScript post processing time that AmiQuote performs using user-definable/modifiable code.

If you need more help you need to provide more information:

  • what symbols are you trying
  • what data are you getting (copy paste downloaded file)
  • screenshot from Yahoo web site historical data page showing same symbol (are dates seen there matching)
  • the exact local Time you did the to test
  • did you try on other time (later) and does it affect the download
  • what are your exact time zone settings

Essentially everything required to reproduce your setup.

I didn't find the solution you referred to, but AI gave us a hand for an amendment to the Javascript that adds either +12 or +13hr to the UTC timestamp depending on whether it is daylight saving here or not. The data looks good now. Thanks

You don’t need AI to do such basic thing. Don’t outsource your own thinking!!!!!!!!

Also don’t advertise commercial AI names.

We all have different skill sets Tomasz.

Sure but outsourcing your skills to AI is bad idea. It is even more dangerous for beginners. I can easily spot wrong code produced by AI (and that happens very often) but beginner can’t.

AI is harmful to human brains. It makes you lazy and often gives you just wrong answers.