Gamestudio Links
Zorro Links
Newest Posts
Data from CSV not parsed correctly
by jcl. 04/26/24 11:18
M1 Oversampling
by jcl. 04/26/24 11:12
Why Zorro supports up to 72 cores?
by jcl. 04/26/24 11:09
Eigenwerbung
by jcl. 04/26/24 11:08
MT5 bridge not working on MT5 v. 5 build 4160
by EternallyCurious. 04/25/24 20:49
Trading Journey
by howardR. 04/24/24 20:04
Zorro FIX plugin - Experimental
by flink. 04/21/24 07:12
Scripts not found
by juergen_wue. 04/20/24 18:51
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
5 registered members (howardR, AndrewAMD, EternallyCurious, Petra, 1 invisible), 791 guests, and 4 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 Online
Support
Petra  Online
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