question

Upvotes
Accepted
3 1 1 4

what is the parameter or how we can control the timezone for the data we receive? If we cannot, how do we know what timezone is the data coming inorder to convert to our local time

elektronrefinitiv-realtimeelektron-sdkrrtema-apielektron-message-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
11.5k 16 7 10

Hi @liyarthomas

Could you plea give me the exact RIC names that you get data for AUDUSD, UADCAD and USDCHF currencies? We cannot find those RIC names in Elektron.

If we can have the exact RIC names, we can contact the Data support team to help you verify which Fields are the ASK time and BID time.

Additionally, what is the API that you obtain data in the excel file?


ricname.png (59.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
3 1 1 4

For instance we are receiving very different dates depending on the currency, see at image the date column, and those dates have nothing to do with our current local time (curr_time) column).

How we can control that?

Thanks


ticktime.png (37.9 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
11.5k 16 7 10

Hello @liyarthomas

Please be informed that the data in Elektron is presented in GMT/UTC timezone. The API just receives incoming data from Elektron and sends it to the application "as it is", so the application needs to convert the time/date data to the local time by itself.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
3 1 1 4

Thank you Wasin, but then which is the key to get time in GMT/UTC because we have noticed that for each currency the all the times are different, if they wer on UTC all should be the same.

Thanks in advanced.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Hi @liyarthomas

Could you please give me example currency RICs and time Fields that you are interested? What are the RICs and Fields that shows in the excel file?


Please note that if you compare the API with a desktop application like Eikon, the Eikon may already apply local time in the UI layer for you.

Upvotes
3 1 1 4

I have attached an excel sheet which shows all the variations. in time for the same FIDs but in different currencies. We wanted to know which one is the correct FID for Ask time and Bid Time?

AUDUSD UADCAD USDCHF "ASIA_AH_MS": "3:58:28:805", "ASIA_AH_MS": "22:47:44:125", "ASIA_AH_MS": "22:59:1:540", "ASIA_AL_MS": "22:58:24:778", "ASIA_AL_MS": "3:26:51:487", "ASIA_AL_MS": "3:58:35:966", "ASIA_AO_MS": "22:0:1:783", "ASIA_AO_MS": "22:0:1:305", "ASIA_AO_MS": "22:0:1:778", "ASIA_BH_MS": "3:56:50:181", "ASIA_BH_MS": "22:47:33:538", "ASIA_BH_MS": "22:59:1:540", "ASIA_BL_MS": "22:58:15:28", "ASIA_BL_MS": "3:26:52:991", "ASIA_BL_MS": "3:58:37:196", "ASIA_BO_MS": "22:0:1:623", "ASIA_BO_MS": "22:0:1:208", "ASIA_BO_MS": "22:0:1:214", "ASIA_HI_TM": "3:56:0:0", "ASIA_HI_TM": "22:47:0:0", "ASIA_HI_TM": "22:59:0:0", "ASIA_LW_TM": "22:58:0:0", "ASIA_LW_TM": "3:26:0:0", "ASIA_LW_TM": "3:58:0:0", "ASIA_OP_TM": "22:0:0:0", "ASIA_OP_TM": "22:0:0:0", "ASIA_OP_TM": "22:0:0:0", "ASKHI1_MS": "3:58:28:805", ASKHI1_MS": "22:47:44:125 "ASKHI1_MS": "22:59:1:540", "ASKHI2_MS": "8:34:45:485", "ASKHI2_MS": "1:3:8:953", "ASKHI2_MS": "22:11:58:970", "ASKHI3_MS": "3:29:38:554", "ASKHI3_MS": "1:1:0:955", "ASKHI3_MS": "22:11:48:966", "ASKHI4_MS": "3:25:46:444", "ASKHI4_MS": "22:9:24:959", "ASKHI4_MS": "22:11:22:135", "ASKHI5_MS": "3:17:53:141", "ASKHI5_MS": "22:9:21:453", "ASKHI5_MS": "22:0:1:103", "ASKLO1_MS": "22:58:24:778", "ASKLO1_MS": "3:26:51:487", "ASKLO1_MS": "3:58:35:966", "ASKLO2_MS": "0:26:0:994", "ASKLO2_MS": "8:50:23:528", "ASKLO2_MS": "12:38:56:510", "ASKLO3_MS": "0:20:24:191", "ASKLO3_MS": "8:47:32:438", "ASKLO3_MS": "12:38:52:439", "ASKLO4_MS": "0:17:5:982", "ASKLO4_MS": "8:47:3:452", "ASKLO4_MS": "12:38:51:617", "ASKLO5_MS": "0:4:50:962", "ASKLO5_MS": "6:21:49:883", "ASKLO5_MS": "12:38:48:595", "BIDHI1_MS": "3:56:50:181", "BIDHI1_MS": "22:47:33:538", "BIDHI1_MS": "22:59:1:540", "BIDHI2_MS": "8:34:46:793", "BIDHI2_MS": "1:3:8:406", "BIDHI2_MS": "22:48:20:938", "BIDHI3_MS": "8:32:26:753", "BIDHI3_MS": "1:0:54:255", "BIDHI3_MS": "22:11:58:970", "BIDHI4_MS": "3:25:46:978", "BIDHI4_MS": "1:0:39:380", "BIDHI4_MS": "22:11:48:966", "BIDHI5_MS": "3:24:1:763", "BIDHI5_MS": "22:9:26:251", "BIDHI5_MS": "22:11:2:91", "BIDLO1_MS": "22:58:15:28", "BIDLO1_MS": "3:26:52:991", "BIDLO1_MS": "3:58:37:196", "BIDLO2_MS": "0:49:0:221", "BIDLO2_MS": "8:47:44:377", "BIDLO2_MS": "12:38:53:616", "BIDLO3_MS": "0:20:47:181", "BIDLO3_MS": "8:47:27:799", "BIDLO3_MS": "12:38:51:617", "BIDLO4_MS": "0:17:23:299", "BIDLO4_MS": "8:47:3:452", "BIDLO4_MS": "12:38:48:595", "BIDLO5_MS": "0:5:4:210", "BIDLO5_MS": "6:21:49:883", "BIDLO5_MS": "12:38:43:614", "EURO_AH_MS": "6:25:53:851", "EURO_AH_MS": "7:59:23:850", "EURO_AH_MS": "7:45:55:845", "EURO_AL_MS": "7:54:45:881", "EURO_AL_MS": "6:18:9:451", "EURO_AL_MS": "7:23:42:737", "EURO_AO_MS": "6:0:1:219", "EURO_AO_MS": "6:0:1:231", "EURO_AO_MS": "6:0:1:228", "EURO_BH_MS": "6:25:54:143", "EURO_BH_MS": "7:59:20:33", "EURO_BH_MS": "7:45:54:386", "EURO_BL_MS": "7:54:44:117", "EURO_BL_MS": "6:18:16:89", "EURO_BL_MS": "6:54:29:151", "EURO_BO_MS": "6:0:1:219", "EURO_BO_MS": "6:0:1:231", "EURO_BO_MS": "6:0:1:228", "EURO_HI_TM": "6:25:0:0", "EURO_HI_TM": "7:59:0:0", "EURO_HI_TM": "7:45:0:0", "EURO_LW_TM": "7:54:0:0", "EURO_LW_TM": "6:18:0:0", "EURO_LW_TM": "7:23:0:0", "EURO_OP_TM": "6:0:0:0", "EURO_OP_TM": "6:0:0:0", "EURO_OP_TM": "6:0:0:0", "HIGH_TIME": "3:56:0:0", "HIGH_TIME": "22:47:0:0", "HIGH_TIME": "22:59:0:0", "HIGH_TIME2": "8:34:0:0", "HIGH_TIME2": "1:3:0:0", "HIGH_TIME2": "22:48:0:0", "HIGH_TIME3": "8:32:0:0", "HIGH_TIME3": "1:0:0:0", "HIGH_TIME3": "22:11:0:0", "HIGH_TIME4": "3:25:0:0", "HIGH_TIME4": "1:0:0:0", "HIGH_TIME4": "22:11:0:0", "HIGH_TIME5": "3:24:0:0", "HIGH_TIME5": "22:9:0:0", "HIGH_TIME5": "22:11:0:0", "LOW_TIME": "22:58:0:0", "LOW_TIME": "3:26:0:0", "LOW_TIME": "3:58:0:0", "LOW_TIME2": "0:26:0:0", "LOW_TIME2": "8:50:0:0", "LOW_TIME2": "12:38:0:0", "LOW_TIME3": "0:20:0:0", "LOW_TIME3": "8:47:0:0", "LOW_TIME3": "12:38:0:0", "LOW_TIME4": "0:17:0:0", "LOW_TIME4": "8:47:0:0", "LOW_TIME4": "12:38:0:0", "LOW_TIME5": "0:4:0:0", "LOW_TIME5": "6:21:0:0", "LOW_TIME5": "12:38:0:0", "MIDHI1_MS": "3:58:23:816", "MIDHI1_MS": "22:47:33:538", "MIDHI1_MS": "22:59:1:540", "MIDLO1_MS": "22:58:19:24", "MIDLO1_MS": "3:26:51:487", "MIDLO1_MS": "3:58:37:196", "MID_HTIM": "3:58:23:0", "MID_HTIM": "22:47:33:0", "MID_HTIM": "22:59:1:0", "MID_LTIM": "22:58:19:0", "MID_LTIM": "3:26:51:0", "MID_LTIM": "3:58:37:0", "OPEN_TIME": "22:0:0:0", "OPEN_TIME": "22:0:0:0", "OPEN_TIME": "22:0:0:0", "OPN_BID_MS": "22:0:1:623", "OPN_BID_MS": "22:0:1:209", "OPN_BID_MS": "22:0:1:214", "QUOTIM": "7:59:24:0", "QUOTIM": "7:59:24:0", "QUOTIM": "7:59:22:0", "QUOTIM_2": "12:59:42:0", "QUOTIM_2": "12:59:44:0", "QUOTIM_2": "12:59:41:0", "QUOTIM_3": "12:59:40:0", "QUOTIM_3": "12:59:43:0", "QUOTIM_3": "12:59:40:0", "TIMACT": "7:59:0:0", "TIMACT": "7:59:0:0", "TIMACT": "7:59:0:0", "TIMCOR": "22:58:15:0", "TIMCOR": "3:26:52:0", "TIMCOR": "3:58:37:0", "USBAC_DT": "13 / 2 / 2018", "USBAC_DT": "13 / 2 / 2018", "USBAC_DT": "13 / 2 / 2018", "US_AH_MS": "12:30:27:766", "US_AH_MS": "14:47:24:19", "US_AH_MS": "20:46:1:209", "US_AL_MS": "14:49:26:935", "US_AL_MS": "12:39:2:788", "US_AL_MS": "12:39:2:784", "US_AO_MS": "12:0:1:185", "US_AO_MS": "12:0:1:180", "US_AO_MS": "12:0:1:188", "US_BH_MS": "12:30:17:142", "US_BH_MS": "14:49:43:781", "US_BH_MS": "20:43:58:61", "US_BL_MS": "14:49:26:659", "US_BL_MS": "12:38:56:106", "US_BL_MS": "12:38:55:611", "US_BO_MS": "12:0:1:185", "US_BO_MS": "12:0:1:180", "US_BO_MS": "12:0:1:188", "US_HI_TM": "12:30:0:0", "US_HI_TM": "14:49:0:0", "US_HI_TM": "20:43:0:0", "US_OP_TM": "12:0:0:0", "US_OP_TM": "12:0:0:0", "US_OP_TM": "12:0:0:0", "VALUE_TS1": "7:59:24:0", "VALUE_TS1": "7:59:24:0", "VALUE_TS1": "7:59:22:0", "VALUE_TS2": "7:59:23:0", "VALUE_TS2": "7:59:23:0", "VALUE_TS2": "7:59:20:0", "VALUE_TS3": "7:59:23:0", "VALUE_TS3": "7:59:23:0", "VALUE_TS3": "7:59:20:0",
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
3 1 1 4

currency1.png

I am sending the above excel sheet in 2 screenshot attachments as in case if you are not able to read the above one. I notice that the excel sheet which I send is not properly formatted.


currency1.png (61.0 KiB)
currency2.png (43.9 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea