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 amibroker@yahoogroups.com, Keith McCombs <kmcco...@...> wrote: > > dubi -- > There is a free utility available at: > 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 amibroker@yahoogroups.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/> > > > > > > > >