Using Amibroker Plus Quote Trader with NSE feed but facing timing issue...help

#1
Hello Friends,

I am using Amibroker + Quote Tracker (with NSE data feed) but it seems QT is extracting NSE data in USA ET time zone in 10.5 hrs behind timeframe...now Amibroker has only integer time offset shift so even if I set it to 10 hrs...this results in inaccurate time desplay in Amibroker window...

For 1H bar I am unable to see 9:55-10:00, 10:00-11:00 and so on bars...

Has anyone faced this issue and can help with this please?

Thanks and rgds, Nisha
 
#2
Hello Friends,

I am using Amibroker + Quote Tracker (with NSE data feed) but it seems QT is extracting NSE data in USA ET time zone in 10.5 hrs behind timeframe...now Amibroker has only integer time offset shift so even if I set it to 10 hrs...this results in inaccurate time desplay in Amibroker window...

For 1H bar I am unable to see 9:55-10:00, 10:00-11:00 and so on bars...

Has anyone faced this issue and can help with this please?

Thanks and rgds, Nisha
Hello,

I am not a user of Quote Tracker but from a quick look, I can suggest following.

In QT menu, go to Options>>Edit Preferences>>Timing Chart. Select the time zone as (ET + 10.5) India. You can optionally synchronise your system time with Eastern Time (the zone in which QT operates) by pressing "Sync Time" button in same menu. You can then click on "Multiday Chart Timing Settings" which opens pre-defined time-frames for various markets. Since you are interested in NSE, select "Indian Equities" from Time-frames text-area. You will see that market timing is correctly pre-configured in the space below. Now select the check box "Use as Global Default" and click ok. You can then check if this solves your problem while importing data and let us know.

Best regards,

AmiBroker-India
 
#3
Hello,

I am not a user of Quote Tracker but from a quick look, I can suggest following.

In QT menu, go to Options>>Edit Preferences>>Timing Chart. Select the time zone as (ET + 10.5) India. You can optionally synchronise your system time with Eastern Time (the zone in which QT operates) by pressing "Sync Time" button in same menu. You can then click on "Multiday Chart Timing Settings" which opens pre-defined time-frames for various markets. Since you are interested in NSE, select "Indian Equities" from Time-frames text-area. You will see that market timing is correctly pre-configured in the space below. Now select the check box "Use as Global Default" and click ok. You can then check if this solves your problem while importing data and let us know.

Best regards,

AmiBroker-India
Hi Amibroker india

pl, give Afl for export intraday day in txt format from amibroker.
 
#4
Hello,

I am not a user of Quote Tracker but from a quick look, I can suggest following.

In QT menu, go to Options>>Edit Preferences>>Timing Chart. Select the time zone as (ET + 10.5) India. You can optionally synchronise your system time with Eastern Time (the zone in which QT operates) by pressing "Sync Time" button in same menu. You can then click on "Multiday Chart Timing Settings" which opens pre-defined time-frames for various markets. Since you are interested in NSE, select "Indian Equities" from Time-frames text-area. You will see that market timing is correctly pre-configured in the space below. Now select the check box "Use as Global Default" and click ok. You can then check if this solves your problem while importing data and let us know.

Best regards,

AmiBroker-India
Thanks AmiBroker-India,

Done that - but the problem is QT is fetching data in US ET time zone (even after above setup) - now at the same time Amibroker is unable to translate it to Indian Time zone after fetching it as it can only offset it by either 10 hrs or 11 hrs and not 10.5 hrs...so data displayed is out of 9:55-3:30 window....

PS: Above QT setup is only effective for data display in QT screen - the fetching process is internal and it sticks to US ET time zone only..for some reason it is neglecting NSE tick times and over riding by US ET times internally...

so in theory for Amibroker to be used effectively with QT for NSE either of this would need to be addressed...

1) QT fetching data in IST and not in US ET
2) Amibroker allowing non-integer 10.5 hrs offset (currrently it support only intergers)

Thanks in advance...

Rgds, Nisha
 
#5
Thanks AmiBroker-India,

Done that - but the problem is QT is fetching data in US ET time zone (even after above setup) - now at the same time Amibroker is unable to translate it to Indian Time zone after fetching it as it can only offset it by either 10 hrs or 11 hrs and not 10.5 hrs...so data displayed is out of 9:55-3:30 window....

PS: Above QT setup is only effective for data display in QT screen - the fetching process is internal and it sticks to US ET time zone only..for some reason it is neglecting NSE tick times and over riding by US ET times internally...

so in theory for Amibroker to be used effectively with QT for NSE either of this would need to be addressed...

1) QT fetching data in IST and not in US ET
2) Amibroker allowing non-integer 10.5 hrs offset (currrently it support only intergers)

Thanks in advance...

Rgds, Nisha
Hello,

I got your point. Let me work with QT, try and explore it. I will come back to you asap.

Regards,

AmiBroker-India
 
#6
Hi Amibroker india

pl, give Afl for export intraday day in txt format from amibroker.
Hello,

You cannot export intraday data for all scrips directly from AmiBroker, you will have to work one scrip at a time. Select the scrip that you want, go to Quote Editor (Symbol>>Quote Editor), copy and paste all data into Excel and save as CSV or tab delimited text in Excel. I know this is not a straight forward solution but a work-around. Since AmiBroker is built to display and analyse charts, it has all the functions to import data but not vice versa.


Regards,

AmiBroker-India
 
#7
Hello,

You cannot export intraday data for all scrips directly from AmiBroker, you will have to work one scrip at a time. Select the scrip that you want, go to Quote Editor (Symbol>>Quote Editor), copy and paste all data into Excel and save as CSV or tab delimited text in Excel. I know this is not a straight forward solution but a work-around. Since AmiBroker is built to display and analyse charts, it has all the functions to import data but not vice versa.


Regards,

AmiBroker-India
Hi amibroker india

Thanks for your help. But problem is that export data in exl format no time header , time come under date header, so pl help in this regard.
 
#9
Hi amibroker india

Thanks for your help. But problem is that export data in exl format no time header , time come under date header, so pl help in this regard.
Hello,

This is relatively simple to do in Excel. Just create new column next to date/time header and copy the date/time data into that column. Now select first date time column, right click and go to "Format Cells", select date as category and the matching format. Once this is done, click OK and the column will be formatted with only date, trimming time data. Now, repeat this procedure again for next column and this time, select time from from format category.

I hope this helps.

Regards,

Ami-Broker India