what is the parameter or how we can control the timezone for the data we receive? If we cannot, how
Best Answer
-
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?
0
Answers
-
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
0 -
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.
0 -
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.
0 -
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.0 -
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",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.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛