Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M
Just to confirm the system settings, The Regional Settings date format is DMY ie 17 March 2013.
NB : May be this is also one of the idiosyncrasies of Microsoft that Excel will only parse correctly if the date format is English US ie MYD. Let us see in April how to get over it.
What is your system date setting
Is it MYD or MDY? Google gives Last Traded Time as "March 15 10:45AM. Excel converts this to 15/03/2013 10:45. It is doing goof up somewhere in parsing date. My date setting is DMY. I am not able to replicate this error. Please remind in April.
Meanwhile, open sheet "Google" and erase entire contents. It will warn you that query will be deleted. Do not worry.
Is it MYD or MDY? Google gives Last Traded Time as "March 15 10:45AM. Excel converts this to 15/03/2013 10:45. It is doing goof up somewhere in parsing date. My date setting is DMY. I am not able to replicate this error. Please remind in April.
Meanwhile, open sheet "Google" and erase entire contents. It will warn you that query will be deleted. Do not worry.
NB : May be this is also one of the idiosyncrasies of Microsoft that Excel will only parse correctly if the date format is English US ie MYD. Let us see in April how to get over it.