Gamestudio Links
Zorro Links
Newest Posts
Newbie Questions
by fairtrader. 12/05/23 14:22
Zorro Trader GPT
by TipmyPip. 12/04/23 11:34
Square root rule
by Smallz. 12/02/23 09:15
RTest not found error
by TipmyPip. 12/01/23 21:43
neural function for Python to [Train]
by TipmyPip. 12/01/23 14:47
Xor Memory Problem.
by TipmyPip. 11/28/23 14:23
Training with command line parameters
by TipmyPip. 11/26/23 08:42
Combine USD & BTC Pairs In Asset Loop
by TipmyPip. 11/26/23 08:30
AUM Magazine
Latest Screens
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Tactics of World War I
Who's Online Now
3 registered members (Martin_HH, steyr, alibaba), 509 guests, and 4 spiders.
Key: Admin, Global Mod, Mod
Newest Members
fairtrader, hus, Vurtis, Harry5, KelvinC
19019 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
need help to modify CSVtoT6.c #463169
11/19/16 15:57
11/19/16 15:57
Joined: Nov 2016
Posts: 4
Karnataka
R
roopa Offline OP
Guest
roopa  Offline OP
Guest
R

Joined: Nov 2016
Posts: 4
Karnataka
hi ! looking for help to modify CSVtoT6.c to be able to import csv into T6 format for

11/18/2016 3:29:00 PM,447.65,448.45,447,447.95,23400

thanks!

Attached Files
ZEEL16NOVFUT.csv (39 downloads)
Re: need help to modify CSVtoT6.c [Re: roopa] #463383
12/01/16 09:25
12/01/16 09:25
Joined: Nov 2016
Posts: 4
Karnataka
R
roopa Offline OP
Guest
roopa  Offline OP
Guest
R

Joined: Nov 2016
Posts: 4
Karnataka
Hi, I managed to convert using autohotkey, pasted the script for those who might have a need for this, thanks!

convert(path_in,symbol_in)
{
FileDelete, %path_in%zorro%symbol_in%.csv

FileRead, contents, %path_in%%symbol_in%-EQ.csv
Loop, parse, contents, `n, `r
{

if ( A_Index > 1 )
{
if (StrLen(A_LoopField) > 20)
{
;msgbox, %A_LoopField%

TZ :=
TY :=
TM :=
TD :=
TH :=
TI :=
TS :=
open :=
high :=
low :=
close :=
volume :=
TZ :=

;StringSplit, lot_array, A_LoopReadLine, `,, . ; Omits periods
StringSplit, lot_array, A_LoopField, `,, . ; Omits periods

timestamp := lot_array1
open := lot_array2
high := lot_array3
low := lot_array4
close := lot_array5
volume := lot_array6

Haystack1a := substr(timestamp,1,3)
Needle1 = /
StringGetPos, pos1a, Haystack1a, %Needle1%
pos1a := pos1a + 1

Haystack1b := substr(timestamp,pos1a+2,2)
StringGetPos, pos1b, Haystack1b, %Needle1%
pos1b := pos1a + pos1b + 2

TM := substr(timestamp,1,pos1a-1)
TM := SubStr("00" . TM,-1)

TD := substr(timestamp,pos1a+1,pos1b-pos1a-1)
TD := SubStr("00" . TD,-1)

TY := SubStr(timestamp, pos1b+1 , 4)

;msgbox %timestamp% %pos1a% %pos1b% %TM% %TD% %TY%

Haystack2 = timestamp
Needle2 = :
StringGetPos, pos2, %Haystack2%, %Needle2%
vTH := SubStr(timestamp,pos2-1,2)

TH := vTH

If vTH = 1
TH = 13
If vTH = 2
TH = 14
If vTH = 3
TH = 15
If vTH = 6
TH = 18
If vTH = 7
TH = 19
If vTH = 9
TH = 09

TI := SubStr(timestamp, pos2+2, 2)
TS := SubStr(timestamp, pos2+5 , 2)

TZ := TY . TM . TD . " " . TH . TI . TS . "," . open . "," . high . "," . low . "," . close . "," . volume . "`n"
TZm := A_Index . " " . timestamp . " " . TZ

TZZ := TZZ . TZ
}
}

}

FileAppend,%TZZ%,%path_in%zorro%symbol_in%.csv
}


Moderated by  Petra 

Powered by UBB.threads™ PHP Forum Software 7.7.1