Zorro - import diff time zones csv

Gamestudio Links

Zorro Links

Data from CSV not parsed correctly
by EternallyCurious. 04/18/24 10:45

folder management functions
by VoroneTZ. 04/17/24 06:52

lookback setting performance issue
by 7th_zorro. 04/16/24 03:08

zorro 64bit command line support
by 7th_zorro. 04/15/24 09:36

AUM Magazine

Latest Screens

6 registered members (EternallyCurious, AndrewAMD, ricky_k, 7th_zorro, 2 invisible), 478 guests, and 3 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,725 Chicago AndrewAMD Serious User
AndrewAMD Serious User Joined: Feb 2017 Posts: 1,725 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