Hi Keith,
thanks for the link. But if I have US, European and e.g. Australian
Futures data and I want to update them real time and at the same time,
how should this work with this tool?
Regards, dubi
--- In [email protected] <mailto:amibroker%40yahoogroups.com>,
Keith McCombs <kmcco...@...> wrote:
>
> dubi --
> There is a free utility available at:
> http://www.karenware.com/powertools/ptzone.asp
<http://www.karenware.com/powertools/ptzone.asp>
>
> That ought to do the trick.
> -- Keith
>
>
> On 3/24/2010 18:48, dubi1974 wrote:
> >
> > I bring this topic up again, as I do have this issues with Europe and
> > US right now. At the moment I use the TWS IB data. Normaly the time
> > shift between CET und NY Time is 6 hours. Right now it is 5 hours. So
> > this confuses the database. The US markets opens at 14:30 and closes
> > at 21:15. And if I want to filter for day session only I see my US
> > data between 15:30 and 22:15. Is there no better way to handle this
> > time problem in Amibroker when US and Europe are changing to
> > summer/winter time on different weekends? Any solutions?
> >
> > Kind regards, dubi
> >
> > --- In [email protected]
<mailto:amibroker%40yahoogroups.com>
<mailto:amibroker%40yahoogroups.com>,
> > "Graham" <gkavanagh@> wrote:
> > >
> > > I have created a small routine to make the appropriate changes
for the
> > > upcoming summer time changes in US and Australian eastern states
(no
> > time
> > > changes where I live, but the ASX market is in east states). I
> > believe the
> > > US and Aust change on the same date again so the changes only
need to be
> > > done once. I use quotetracker for intraday data and this arrives as
> > US EST
> > > (ESST) so in my summer the time shift is +16 hours and in winter
+14
> > hours.
> > > Previously I used to export the data to excel and change the
times there
> > > which was laborious and boring. Now the improvements in AB make
this
> > simple
> > > and easy.
> > > Btw if you do not make the mods to the historical intraday data the
> > times
> > > will not be consistent throughout your data.
> > > Here is the instructions and code, hope this helps someone
> > >
> > >
> > >
> > > /*
> > >
> > > CHANGING ALL DATA FOR SUMMER TIME CHANGES
> > >
> > > Datafeed through QT is in US EST which changes with the seasons
daylight
> > > saving. About the same time (if lucky on same weekend) Australian
> > eastern
> > > states change summer time (in reverse). So we have in Aust summer
> > time shift
> > > +16 hours AND in winter +14 hours
> > >
> > > To change the times for summer timezone changes US & Australian
for the
> > > historical saved data in Amibroker I use the following:-
> > >
> > > For Export:
> > >
> > > Databse Settings - Intraday Settings -
> > >
> > > In March - change the time shift to +2 hrs to adjust for winter time
> > >
> > > In November - change the time shift to -2 hrs to adjust for
summer time
> > > (Nov)
> > >
> > > Export intraday and EOD data to TXT files
> > >
> > > One file for each stock
> > >
> > > In the first line insert the directory you want to save them to,
> > make sure
> > > the directory exists
> > >
> > > Select your charts to export with the "Apply to" filter in AA window
> > >
> > > Select the timeframe period you want to save as using the AA
"Settings"
> > >
> > > Press Scan button
> > >
> > > The data is now saved to txt files with US times adjusted for
the next
> > > timezone season.
> > >
> > > To Create the new database for new season
> > >
> > > Remove all data from the existing database (or create new one)
> > >
> > > Make the time shift in Database Settings - Intraday Settings to
0 (zero)
> > >
> > > Import the adjusted data with the import wizard.
> > >
> > > Now ready to rock and roll
> > >
> > > Oh sometimes the US and Aust do not change summer time on same
> > weekend and
> > > this needs to be done twice with 1 hour adjustment each time :(
> > >
> > > by Graham Kavanagh 05 Mar 2004
> > >
> > > */
> > >
> > > fh = fopen( "c:\\SaveData\\"+Name()+".txt", "w");
> > >
> > > if( fh )
> > >
> > > {
> > >
> > > fputs( "Ticker,Date,Time,Open,High,Low,Close,Volume \n", fh );
> > >
> > > y = Year();
> > >
> > > m = Month();
> > >
> > > d = Day();
> > >
> > > r = Hour();
> > >
> > > e = Minute();
> > >
> > > n = Second();
> > >
> > > for( i = 0; i < BarCount; i++ )
> > >
> > > {
> > >
> > > fputs( Name() + "," , fh );
> > >
> > > ds = StrFormat("%02.0f-%02.0f-%02.0f,",
> > >
> > > y[ i ], m[ i ], d[ i ] );
> > >
> > > fputs( ds, fh );
> > >
> > > ts = StrFormat("%02.0f:%02.0f:%02.0f,",
> > >
> > > r[ i ],e[ i ],n[ i ] );
> > >
> > > fputs( ts, fh );
> > >
> > > qs = StrFormat("%.4f,%.4f,%.4f,%.4f,%.0f\n",
> > >
> > > O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] );
> > >
> > > fputs( qs, fh );
> > >
> > > }
> > >
> > > fclose( fh );
> > >
> > > }
> > >
> > > Buy = 0;
> > >
> > >
> > >
> > >
> > > Cheers,
> > > Graham
> > > http://e-wire.net.au/~eb_kavan/
<http://e-wire.net.au/%7Eeb_kavan/> <http://e-wire.net.au/%7Eeb_kavan/
<http://e-wire.net.au/%7Eeb_kavan/>>
> > >
> >
> >
>
