Gamestudio Links
Zorro Links
Newest Posts
Trading Journey
by howardR. 04/24/24 20:04
M1 Oversampling
by Petra. 04/24/24 10:34
Zorro FIX plugin - Experimental
by flink. 04/21/24 07:12
Data from CSV not parsed correctly
by EternallyCurious. 04/20/24 21:39
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
2 registered members (howardR, sleakz), 706 guests, and 3 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Mega_Rod, EternallyCurious, howardR, 11honza11, ccorrea
19048 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
CSVtoHistory.c Error 030 #483046
04/26/21 22:51
04/26/21 22:51
Joined: Apr 2021
Posts: 2
M
Mohan Offline OP
Guest
Mohan  Offline OP
Guest
M

Joined: Apr 2021
Posts: 2
I downloaded historical quotes from yahoo finance and ran CSVtoHistory.c to convert into .t6 format file and when I use it in a script , I am getting the following error
Error 030: Wrong date range 2021-04-13 00:00:00 – 1998-12-22 00:00:00
Error 055: no XLK prices

I ran ZHistoryEditor on the converted file and it looked okay. Can anyone help please?

I have attached screen shots

Thanks,

Mohan

Attached Files
Zorror_error_XLK.jpg (50 downloads)
Zhistory_XLK.jpg (51 downloads)
Re: CSVtoHistory.c Error 030 [Re: Mohan] #483053
04/27/21 15:35
04/27/21 15:35
Joined: Apr 2021
Posts: 2
M
Mohan Offline OP
Guest
Mohan  Offline OP
Guest
M

Joined: Apr 2021
Posts: 2
Looks like a pilot error. Yahoo download format is below:
Date,Open,High,Low,Close,Adj Close,Volume
2018-01-02,78.269997,84.099998,76.210999,84.089996,83.483208,1217600
2018-01-03,84.000000,88.808998,83.599998,87.209999,86.580688,1342600
2018-01-04,88.660004,88.660004,82.739998,84.540001,83.929962,1113000
2018-01-05,85.230003,85.348000,81.860001,83.570000,82.966957,921900
2018-01-08,83.830002,83.830002,76.129997,78.400002,77.834267,1870900
2018-01-09,79.349998,85.150002,79.349998,84.379997,83.771111,1485800
2018-01-10,83.099998,88.080002,80.190002,87.800003,87.166451,1255700
2018-01-11,87.650002,89.900002,85.910004,89.300003,88.655624,1051900
2018-01-12,89.589996,91.599998,88.599998,90.709999,90.055428,854400
2018-01-16,91.970001,92.900002,81.599998,82.410004,81.815346,2314200
2018-01-17,86.320000,86.489998,83.013000,85.430000,84.813545,1259600

and the string format
string Format = "+%Y-%m-%d,f3,f1,f2,f4,f5,f6";

Re: CSVtoHistory.c Error 030 [Re: Mohan] #483058
04/29/21 06:11
04/29/21 06:11
Joined: Apr 2008
Posts: 586
Austria
Petra Offline
Support
Petra  Offline
Support

Joined: Apr 2008
Posts: 586
Austria
The error message tells you imported your data in the wrong date order. It should run with most recent date first from 1998 to 2021, not from 2021 to 1998.


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