Zorro - import diff time zones csv

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

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

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.

Hi Grat, AndrewAMD,


Thank you both !

Neb