Zorro - import diff time zones csv

Gamestudio Links

Zorro Links

loading historical data 1st time
by AndrewAMD. 04/14/23 12:54

Trade at bar open
by juanex. 04/13/23 19:43

Bug in Highpass2 filter
by rki. 04/13/23 09:54

Adding Limit Orders For IB
by scatters. 04/11/23 16:16

FisherN
by rki. 04/11/23 08:38

AUM Magazine

Latest Screens

1 registered members (Grant), 999 guests, and 2 spiders.

Key: Admin, Global Mod, Mod

Newest Members

Print Thread

Rate Thread

Zorro - import diff time zones csv #482554 02/23/21 15:09 02/23/21 15:09
Joined: Aug 2020 Posts: 59 London Neb OP Junior Member
Neb OP Junior Member Joined: Aug 2020 Posts: 59 London	Hi all, If I have csv price history, which is not UTC time zone, but Chicago or Australia server, does Zorro have posibility to convert it, during import ? Thanks, Neb

Re: Zorro - import diff time zones csv [Re: Neb] #482555 02/23/21 17:11 02/23/21 17:11
Joined: May 2015 Posts: 390 Czech Republic G Grat Senior Member
Grat Senior Member G Joined: May 2015 Posts: 390 Czech Republic	I had also this problem. My solution: import CSV into Python/Pandas convert timestamp to UTC/GMT save with new Timezone https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DatetimeIndex.tz_convert.html Code df.index = df.index.tz_localize('GMT') df.index = df.index.tz_convert('America/New_York') Last edited by Grat; 02/23/21 17:13.

Re: Zorro - import diff time zones csv [Re: Neb] #482556 02/23/21 17:52 02/23/21 17:52
Joined: Feb 2017 Posts: 1,634 Chicago AndrewAMD Serious User
AndrewAMD Serious User Joined: Feb 2017 Posts: 1,634 Chicago	What you do is this: 1) Import the CSV to a dataset as you normally would, knowing that the timestamps are in the given timezone. 2) Modify the dataset using dataset functions and time functions, and the Now variable. Detect daylight savings with dst(). https://manual.zorro-project.com/data.htm https://manual.zorro-project.com/month https://zorro-project.com/manual/en/date.htm 3) Save your dataset to a t6 file with dataSave. www.vitaltrades.com - andrew@vitaltrades.com

Re: Zorro - import diff time zones csv [Re: Neb] #482572 02/28/21 12:23 02/28/21 12:23
Joined: Aug 2020 Posts: 59 London Neb OP Junior Member
Neb OP Junior Member Joined: Aug 2020 Posts: 59 London	Hi Grat, AndrewAMD, Thank you both ! Neb

Moderated by Petra