what is the parameter or how we can control the timezone for the data we receive? If we cannot, h...

liyarthomas

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

wasin.w

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?

liyarthomas

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

wasin.w

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.

liyarthomas

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.

wasin.w

https://community.developers.refinitiv.com/discussion/comment/24162#Comment_24162

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.

liyarthomas

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",

liyarthomas

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.