-
API for Eikon vs Workspace Data
Client is currently testing the API for Eikon vs Workspace and the output are different for some fields related to Deals. Attached is a screenshot for your reference. Can you please check if this is normal and what is the reason behind this? Do we have the correct way of getting the data? (Attached screenshot from API) I…
-
Provide Shipping Flows Python Script
Looking for someone to help put together a script to pull shipping data for clean products (gasoline, gasoline component, naphtha, Gasoline / Gasoline Component) as imports/exports out of all US PADDS.
-
inconsistency with get_history lseg api endpoint
I'm currently migrating a workflow from the legacy Eikon Python API to the new LSEG Data (RD) API, and I’ve encountered a couple of points that require clarification. In the Eikon API, I was using the get_timeseries() function with fields='CLOSE' to retrieve historical Euribor data for the following instruments:…
-
LSEG api get_history doesnt have CLOSE
I’m migrating from eikon to lseg. I’ve been advised to migrate eikons get_timeseries to lseg get_history. With eikon I can get the CLOSE values (see below in a.). Lseg doesn’t have CLOSE or anything similar. (see below in b.) This is using your own codebook. Please advise. a. Refinitiv.Eikon df_hist_ek = ek.get_timeseries(…
-
Why is the fperiod not properly aligned with the values?
I'm having problem when downloading financial income data. For this example in the code below, the "Financial Period Absolute" (fperiod) is not properly aligned with the true financial data. We can see that on "TR.F.OperProflnOpCASR | XEBT", there are 2 values on FY2024Q4, but it should be one value for FY2024Q4 and…
-
Historical exchange data extraction
Hello, For a project I would like to extract monthly data. What I need is for each month historically to extract which stocks were in a specific exchange. For example: the names of all the stocks that where in the euronext Paris exchange in the month of march 2008. (all those that were active at that time, also those that…
-
Multiple values returned from get_data
Hi, I've inherited some Python code that downloads debt seniority data. I'm running a test on a single security: df_pull_isin, error = ek.get_data(instruments = 'US404280EN53', fields = [ 'TR.NISeniorSubordinatedDebtIndicator.date','TR.NISeniorSubordinatedDebtIndicator.value']) returns output of the form 4414 US404280EN53…
-
Historical price-to-book ratio
Hi, I'm using the following code to import historical data for a stock in Python: ld.get_data(universe = "ABBN.S", fields = ['TR.CLOSEPRICE.DATE', 'TR.CompanyMarketCapitalization'], parameters = {'SDate': Start_Date, 'EDate': End_Date, 'Frq': 'D'}) Now I would like to import the price-to-book ratio. What is the best way to…
-
Hi, is there a way in Python to retrieve the list of RIC change for all listed companies on Hong Kon
Hi, is there a way in Python to retrieve the list of RIC change for all listed companies on Hong Kong exchange (HKEX) between 2021-01-01 and today?
-
Does LSEG apply timestamps to real-time data when received and if so, what is the FID?
I'm aware of the exchange timestamp in the nanasecond field. Refering to US Equities.
-
DMD - on the FID Search tool
Hi Team, on the FID Search tool, do you have the asset class codes for options and futures? Regards, Piotr
-
RSI Calculation
Hi, I would like to know the RSI calculation used on all standard reuters charts. My issue is that I have tried the pandas_ta.rsi function as well as the talib RSI function for the ric 'LCOc1' and others. These values are completely differnt to the ones I see on the chart. please see below my code and output:…
-
PYTHON API Extraction Not Yielding Results
Hi Team, Hoping for your help in checking the code of the client below, for some reason, they are not receiving any results when querying for MarketDepth: Code: def ExtractRaw(token, json_payload): try: outputfilepath = str(_outputFilePath + _outputFileName + str(os.getpid()) + '.csv.gz') if os.path.exists(outputfilepath):…
-
How to Download ESG News from All S&P 500 Companies Using API
Hello, I am looking for a way to download ESG news for all S&P 500 companies using the Refinitiv Data Platform (RDP) API or the Eikon API. My goal is to retrieve articles, headlines, and any relevant information related to sustainability, governance, and ESG criteria for the companies in the index. Specific Questions:…
-
Excel Integration: How to retrieve full monthly historical data for a CUSIP (similar to Workspace)
I need functionality where I can input a CUSIP into Excel and automatically retrieve the full monthly historical data for that CUSIP. The output should look exactly like the monthly historical view available in Workspace under "Trade Check" (see attached screenshot for reference). Please let me know how I can achieve this…
