Gamestudio Links
Zorro Links
Newest Posts
Zorro FIX plugin - Experimental
by flink. 04/21/24 07:12
Data from CSV not parsed correctly
by EternallyCurious. 04/20/24 21:39
M1 Oversampling
by 11honza11. 04/20/24 20:57
Scripts not found
by juergen_wue. 04/20/24 18:51
zorro 64bit command line support
by 7th_zorro. 04/20/24 10:06
StartWeek not working as it should
by jcl. 04/20/24 08:38
folder management functions
by VoroneTZ. 04/17/24 06:52
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
1 registered members (AndrewAMD), 177 guests, and 2 spiders.
Key: Admin, Global Mod, Mod
Newest Members
EternallyCurious, howardR, 11honza11, ccorrea, sakolin
19047 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
CSVtoHistory script - bad date error #482339
01/28/21 23:59
01/28/21 23:59
Joined: Jan 2021
Posts: 17
J
jari Offline OP
Newbie
jari  Offline OP
Newbie
J

Joined: Jan 2021
Posts: 17
Hi, anybody knows why CSVtoHistory is throwing this error? Thank you!

Code
=> 
Error 058: Bad date for '1990-01-03' in CSV file VIX 19900103 to 20210129.csv
0 lines read
C:\Users\jari\OneDrive\Zorro\History\CSV file VIX 19900103 to 20210129.t6

CSVtoHistory compiling........... ok

1990-01-03,18.190001,18.190001,18.190001,18.190001,18.190001,0

I have uncommented the following to become (for Yahoo as source):
Code
// YAHOO line format "2015-05-29,43.45,43.59,42.81,42.94,10901500,42.94"
//string Format = "%Y-%m-%d,f3,f1,f2,f4,f6,f5"; // unadjusted
string Format = "%Y-%m-%d,f3,f1,f2,f4,f5,f6"; // on 29jan2021, looks like vol is last, so switched the last two

csv content is (Windows CR LF, UFT-8):
Code
1990-01-03,18.190001,18.190001,18.190001,18.190001,18.190001,0
1990-01-04,19.219999,19.219999,19.219999,19.219999,19.219999,0

Last edited by jari; 01/29/21 00:00.
Re: CSVtoHistory script - bad date error [Re: jari] #482340
01/29/21 00:02
01/29/21 00:02
Joined: Jan 2021
Posts: 17
J
jari Offline OP
Newbie
jari  Offline OP
Newbie
J

Joined: Jan 2021
Posts: 17
Nvm... noob lol. By default, the format for MKTS is uncommented. Comment it, and it works perfectly, of course : )-)


Moderated by  Petra 

Gamestudio download | chip programmers | Zorro platform | shop | Data Protection Policy

oP group Germany GmbH | Birkenstr. 25-27 | 63549 Ronneburg / Germany | info (at) opgroup.de

Powered by UBB.threads™ PHP Forum Software 7.7.1