-
Extracting Flows Data in Python
is there a way to pull this information through Python or Excel? import lseg.data as ld import pandas as pd ld.open_session() ld.get_data(universe=['C}KV7309950155'],…
-
Using Getdata function to Get CUSIP based on RIC
Hello! When I was using Getdata function in Refinitiv Workspace API, I used RIC to get CUSIP (and I set the parameter: 'SDate' and 'EDate', I tried to make they are the same day to get the certain day's data). However, most of the transfer is right, some of the CUSIP I got is totally wrong. And I mannually double-checked…
-
Historical lookback of FX impact from economic data.
Was wondering if someone was able to guide me in being able to create an FX impact monitor from economic data. What I mean is say…. pulling the last years worth of non-farm payrolls data alongside the consensus and then working out what the impact was on EUR/USD an hour after the data or four hours after the data. The…
-
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(…
-
Hi, Is it possible to pull live vessel locations via API? and if so is any historical vessel locatio
-
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…
-
we need to use “screen” function in python to find the company, remember the companies are not liste
My understanding is that we need to use “screen” function in python to find the company, remember the companies are not listed, they DO NOT have RIC. I believe we need to similar code as below, but the universe should be set to “Private equity” My question is that I need CODE to produce the same output as I use “DSCREEN”.…
-
Time for updating the trade date in the datascope response.
{ "IdentifierType": "Ric", "Identifier": "AUD=", "RIC": "AUD=", "Asset Type Description": "Money Market", "Security Description": "Australian Dollar/US Dollar FX Spot Rate", "Trade Date": "2025-03-26", "Bid Price": 0.6297, "Ask Price": 0.6301, "Mid Price": 0.6299, "Universal Ask Price": 0.6301, "Universal Bid Ask Date":…
-
I can't find the symbol or identifier required to extract the data using the get_data function
I am currently using the Refinitiv API on python to extract energy commodities fundamental data but I am facing some difficulties. In particular I can't find the symbol or identifier required to extract the data using the get_data function or any other method provided by the documentation. I would like to know how to…
-
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…
-
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.
-
How to retrieve or see expiry dates for the LME 3M contract for trade dates in the past on API
Is there a way to see expiry dates for the LME 3M contract for trade dates in the past via API i.e I'd like to find out what the 3M expiry date was when trading on 21 March
-
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…
