Gamestudio Links
Zorro Links
Newest Posts
AlpacaZorroPlugin v1.3.0 Released
by kzhao. 05/20/24 20:05
Free Live Data for Zorro with Paper Trading?
by AbrahamR. 05/18/24 13:28
Change chart colours
by 7th_zorro. 05/11/24 09:25
Data from CSV not parsed correctly
by dr_panther. 05/06/24 18:50
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
2 registered members (VoroneTZ, 7th_zorro), 1,332 guests, and 3 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Hanky27, firatv, wandaluciaia, Mega_Rod, EternallyCurious
19051 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Incorrect date translation by CVStoHistory script #474944
11/14/18 13:56
11/14/18 13:56
Joined: Nov 2018
Posts: 1
Connecticut
A
avgtrader Offline OP
Guest
avgtrader  Offline OP
Guest
A

Joined: Nov 2018
Posts: 1
Connecticut
I downloaded one minute historical data from my broker in CSV format using my own script. I then converted it into .t6 file using CVStoHistory script. To validate the conversion, I then used the CVSfromHistory to convert it back to CSV format. The timestamp in the output file from CVSfromHistory didn't match the file downloaded from my broker.

CVS file input to CVStoHistory
20181108 15:55:00,280.05,280.24,280.05,280.15,1950,612,280.165
20181108 15:56:00,280.16,280.23,280.16,280.18,952,393,280.19
20181108 15:57:00,280.18,280.18,279.95,279.97,1039,479,280.04
20181108 15:58:00,279.98,280.26,279.98,280.24,1419,624,280.155
20181108 15:59:00,280.24,280.44,280.24,280.44,2773,819,280.358

CVS file output from CVSfromHistory
2018-11-08 15:59:00,280.23999,280.44000,280.23999,280.44000
2018-11-08 15:57:00,279.98001,280.26001,279.98001,280.23999
2018-11-08 15:56:58,280.17999,280.17999,279.95001,279.97000
2018-11-08 15:56:57,280.16000,280.23001,280.16000,280.17999
2018-11-08 15:56:55,280.04999,280.23999,280.04999,280.14999

Re: Incorrect date translation by CVStoHistory script [Re: avgtrader] #474948
11/14/18 14:57
11/14/18 14:57
Joined: Sep 2003
Posts: 929
Spirit Offline

Moderator
Spirit  Offline

Moderator

Joined: Sep 2003
Posts: 929
Looks like a wrong time format? Its not even minutes but seconds.


Moderated by  Petra 

Powered by UBB.threads™ PHP Forum Software 7.7.1