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