-
Time stamped an hour out of sync
One thing I noticed is the csv files my code is creating are being time stamped an hour out of sync. For example, when I save files at 18:44 my local time they are time stamped as 17:44. I tried to run this to get around it ``` import pandas as pd import pytz from datetime import datetime, timedelta # Adjust the offset…
-
How to change Timestamp
How do i change the "Condition": { "MessageTimeStampIn": "GmtUtc", to UTC+9 , and how do i show the timestamp to be Tokyo/Osaka?
-
timebar persistence
I did ask this question earlier, however the response received did not solve the problem. in the code below, when i use, "TimebarPersistence": "false", i still receive carried over values (i would not expect to see quotes on Saturday and Sunday). note: ticker1 is defined as "JPY="…
-
how can i get exact time data field of economic indicator??
since i have the log below at 2022/08/16 23:57:25.026 (UTC) 2022/08/16 23:57:25.026 ERROR --- [economicIndicatorExecutor3] a.w.d.c.s.EconomicIndicatorService : ric : JPTBL2=ECI, f : FieldEntryDto(ric=JPTBL2=ECI, nbRic=JPTBL2=ECI, fieldMap={SF_NAME=LALERT, CTB_2A_1=23:57:24.913, GN_TXT16_3=16Aug, GN_TXT16_4=-1436.8,…
-
get_timeseries and get_historical_price_summaries DataOutput Timestamps
I am using the functions get_timeseries and get_historical_price_summaries to create a table that contains high, low, open, close, volume (from get_timeseries) and bid and ask (from get_historical_price_summaries) for german stocks. The timestamps indicate (in both tables) that the first trades occur at 08:00 AM. However,…
-
Timestamp of real time updates for RICs using EMA Java API
Hi, I'm working on java solution using EMA API that subscribes for real time updates for a list of RICs. I need to know the timestamp of each update that originates at the ADS server. Any custom field can configured on the ADS ? The timestamp doesn't have to from the exchanges. I see the challenges using the timestamps for…
-
EkionDataApi Gold And Silver Time Stamp Issue
I sent this question yesterday to customersupport@refinitiv.com and they directed me to ask this question here. I state this so that the dates returned at the bottom make sense (they were pulled yesterday). I'm trying to understand why the latest timestamps being returned differ between GCc1 and SIc1. For GCc1 I get a…
-
How to edit the date and time data retrieved by the Eikon API
Hi, I have retrieved news data. Can you please tell me how to change the date and time displayed to the second? In the figure, I want to delete the red line.
-
How to get Asia or Europe close price via python get_timeseries or get_data function
Similar function to that in excel: =@RHistory("BRTCALAMc1","TRADE PRICE EUROPE.Timestamp;TRADE PRICE EUROPE.Close","START:"2021-04-01" END:"2021-04-20" INTERVAL:1D",,"TSREPEAT:NO SORT:ASC CH:Fd",B6) using either the get_timeseries or get_data function in python.
-
Eikon API usage from Python: Getting a DF with both dates and values?
i start with this formula = 'TR.ACCRUEDINTEREST(SDate=0,EDate=-19,Frq=C).date' df, e = ek.get_data(instruments='XS1572326145', fields=formula) print(df) and it gives the dates; to get values, we would change: formula = 'TR.ACCRUEDINTEREST(SDate=0,EDate=-19,Frq=C).value' however, i don't understand how to get a DF…
-
Retrieve Item V3 timestamp of bid
I am currently using the Retrieve Item V3 method to bring down futures prices for grain commodities. I use the BID value from the given XML for the futures price for a given month, but I do not see any field that represents when that bid is from. A separate user has given me a screenshot of the Time & Sales screen which…
-
Timestamps of deletions in TRTH market by price data
In market BY price data (level 2) we can use fields LV_TIM_MS or LV_TIM_NS to get the timestamp of updates. However if an update consist of just DELETE updates, these fields are not set and the only time related fields left to use are TIMACT_MS or TIMACT_NS. However sometimes TIMACT get substantially behind LV_TIM and is…