Register
Log In
Forums
Starting with Zorro
Zorro - import diff time zones csv
Forums
Calendar
Active Threads
Search
Forum Help
Gamestudio Links
► Features
► Download
► Online Manual
► Online Tutorial
► Free Resources
► F.A.Q.
Zorro Links
► Download
► Online Manual
► Online Tutorial
► Blog
► Support
► What's New?
Newest Posts
How to Get Free Live Data for Zorro Futures Paper Trading?
by AbrahamR. 05/18/24 20:31
Free Live Data for Zorro with Paper Trading?
by AbrahamR. 05/18/24 13:28
Zorro Calculate Commission and Spread Even Setting Is Off
by Zheka. 05/16/24 10:41
Change chart colours
by 7th_zorro. 05/11/24 09:25
Texture/Sprite animation tool. Someone interested in ?
by NeoDumont. 05/10/24 19:36
Seeking Advice: Trading Two Algorithms for SPX500 / US Treasury
by AndrewAMD. 05/07/24 00:56
Data from CSV not parsed correctly
by dr_panther. 05/06/24 18:50
Zorro Mistakenly Changes Another Assets Parameter in Loop
by dr_panther. 05/06/24 18:24
AUM Magazine
Latest Screens
Who's Online Now
1 registered members (
AbrahamR
), 717 guests, and 4 spiders.
Key:
Admin
,
Global Mod
,
Mod
Newest Members
Hanky27
,
firatv
,
wandaluciaia
,
Mega_Rod
,
EternallyCurious
19051 Registered Users
Previous Thread
Next Thread
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,730
Chicago
AndrewAMD
Serious User
AndrewAMD
Serious User
Joined:
Feb 2017
Posts: 1,730
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
Hop To
Gamestudio ------
Starting with Gamestudio
Atari lite-C
Editors & Templates
A8 Engine
Shaders
Third Party Tools
Acknex Users Magazine
The Past
The Future
Zorro ------
Starting with Zorro
Educational
Automated Trading
Zorro Scripts
The Z Systems
Zorro and the Brokers
Zorro Future
Feedback ------
Bug Hunt
Blame the Manual
Ask the Developers
Updates & Announcements
Rants
Game Creation ------
Game Design & Business
Jobs Wanted
Jobs Offered
User Resources
Projects
Showcase
Beyond Games & Money ------
Hilbert's Hotel
Morbius' Virtual Answering Machine
Print Thread
Switch to Threaded Mode
5
Excellent
4
Good
3
Average
2
Bad
1
Terrible
View Profile
Send Private Message
Follow User
Show Forum Posts
View Profile
Send Private Message
Follow User
Show Forum Posts
View Profile
Send Private Message
View Homepage
Follow User
Show Forum Posts
View Profile
Send Private Message
Follow User
Show Forum Posts
Default Style
gamestudio
UBBT77
UBBT77 - Dark2
Forum Rules
·
Mark All Read
·
Powered by UBB.threads™ PHP Forum Software 7.7.1