Gamestudio Links
Zorro Links
Newest Posts
Help with plotting multiple ZigZag
by degenerate_762. 04/30/24 23:23
M1 Oversampling
by 11honza11. 04/30/24 08:16
Trading Journey
by howardR. 04/28/24 09:55
Zorro Trader GPT
by TipmyPip. 04/27/24 13:50
Data from CSV not parsed correctly
by jcl. 04/26/24 11:18
Why Zorro supports up to 72 cores?
by jcl. 04/26/24 11:09
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
2 registered members (howardR, 7th_zorro), 893 guests, and 2 spiders.
Key: Admin, Global Mod, Mod
Newest Members
firatv, wandaluciaia, Mega_Rod, EternallyCurious, howardR
19050 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Import CSV #486264
07/08/22 11:22
07/08/22 11:22
Joined: Jun 2022
Posts: 6
B
BigW Offline OP
Newbie
BigW  Offline OP
Newbie
B

Joined: Jun 2022
Posts: 6
Hi
I am trying to import a csv file in Yahoo format as per the required format in the CSVtoHistory script without success.
CSV attached as well as a snapshot of the history editor.

Whats weird and frustrating is that it appears to read correctly ie the script runs ok but the process overwrites the dates with a single date so the chart does not load and looks like a step function.
Using the Z history editor shows this for the t6 files.

Any idea what I am doing wrong here?
Thank you - maybe a simple error or setting?

Regards
W

Attached Files
KWE_LN2.csv (47 downloads)
csverror.PNG
Re: Import CSV [Re: BigW] #486268
07/09/22 20:28
07/09/22 20:28
Joined: Sep 2003
Posts: 929
Spirit Offline

Moderator
Spirit  Offline

Moderator

Joined: Sep 2003
Posts: 929
I'm no csv conversion specialist but when the dates are wrong I would first check the date format string. If you cannot fix it you can hire the support for this.

Re: Import CSV [Re: BigW] #486270
07/10/22 12:06
07/10/22 12:06
Joined: Jan 2021
Posts: 15
Chennai
M
monarch Offline
Newbie
monarch  Offline
Newbie
M

Joined: Jan 2021
Posts: 15
Chennai
Hi - Use this format string.

string Format = "0%Y-%m-%d,f3,f1,f2,f4,f6";

And leave the rest of the CSVtoHistory script intact. This should do the trick.

We must use zero(0) in the beginning to tell Zorro that there are no headers.


Moderated by  Petra 

Powered by UBB.threads™ PHP Forum Software 7.7.1