-
Does the API in Python (Jupyter) or Codebook allow to retrieve historical data of CEOs?
So I'm trying to get descriptive historical data of CEOs of listed companies hopefully. I'm imagining a panel between 2007-2024 (or last year available) of those companies, in which I have a column of year, another one for the fullname of the CEO in charge during that year, and several other columns with: 1. Age 2.…
-
How to get a list of all ever-listed companies for a specific time horizon?
Is it possible to get a list of all ever-listed companies (including companies that are no longer listed) for a country/region (US, Europe) and a time horizon (e.g. 2000-2024) using the Python API? Currently, we use the Python API and ld.get_data() to extract several types of data and get the identifiers externally or via…
-
Is 'IssuerOAPermID' the best (unique) identifier on a firm level?
Currently, we use the Python API and ld.get_data() to extract price, fundamental and ESG data of several companies over time. Therefore, we want to know which identifier ('IssuerOAPermID'?) we should use to have a unique identifier on a firm level. Thank you very much in advance!
-
How to load Excel Workspace Addin from python script?
Hello Team, I am trying to open an excel file from the python script, file is opening but when Workspace addin is throwing Exception error "Class not registered". Addin is getting loaded correctly when excel file is directly opened. I am sharing the code here, please help me resolve this issue asap
-
Filing API returns error message "User did not have entitlements to the field".
Hello, when I tried to get filing data with Python Filing API, I only get NAs and above error message. I was able to download full correct data using ADVFIL function on LSEG WORKSPACE desktop app. However, I need to acquire filing data for over 3,000 firms. I cannot download all of it manually. Here is my code:…
-
How to calculate FX settlement date?
Hello friend, I'm using Workspace Settlement Calendar Calculator to calculate FX broken dates start date and end date, like the red box outlined in the screenshot below. I would like to know how to archieve this by Python. Thanks & Regards, Mark
-
High Frequency Historic Future Data RIC
Hi all, I'm trying to get hourly level data for a contract with RIC 'FFH3^2' which is CBoT 30days Fed Fund Rate Future for March 2023. Even though for current future contract 'FFH25' hourly level data is available, the RIC 'FFH3^2' doesnt return any data when I use code: rd.get_history(universe=['FFH3^2'], fields =['BID',…
-
Why am I getting different outputs when using CUSIP vs RIC?
In the code below, the volume data which we get is different, when I use the CUSIP vs when I use the ticker. Can you help me in getting the correct information? I want to use CUSIP, but want to get the information which is returned when I use the Ticker as the universe. import refinitiv.data as rd rd.open_session() df =…
-
Download Earnings Calls Transcripts Using Python from Refinitiv Worspace
Hello! I am using Refinitiv Workspace. I need to download earnings calls transcripts for quite a number of companies for several years. Is this possible via the Python API? I tried to use 'get_data', but I found that there is no 'earnings calls transcripts' option in DIB (Data Item Browser). And I can't find any Refinitiv…
-
Using fundamental_and_reference leads to warning when <NA> values are in the result
I tried to get some data using lseg-data 2.0.1 with "fundamental_and_reference". The result obviously contains some <NA> values. I got the message: "FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To…
-
Using Python API: Check all elements in a list are a valid RIC
My ultimate aim is to be able to do a Ekion Python API query like this df_ric, err = ek.get_data(RIC_List, ['TR.PriceClose','TRDPRC_1'],) Where RIC_List has 1800 elements, 99% of which are RICs in string format and the remaining 1% are not RICs and need to be skipped automatically. (Querying each element using a "try"…
-
Hello, I need help installing lseg python library
You'll find below the error message generated. It seems there is a problem with Numpy dependency. The version of Numpy is 2.1.2 . ---------------------------------------------------- PS C:\Users\VVMD250\OneDrive - LA POSTE GROUPE\PYTHON> pip install lseg-data Requirement already satisfied: lseg-data in…
-
Begging for help - ld.open_session() failed with eikon app_key
Please kindly help😭😭 I failed in both methods: 1.Authentification to LSEG Service ld.open_session(config_name="/content/Configuration/lseg-data.config.json", name="platform.ldp") Loading endlessly 2. ld.session.platform.Definition( app_key = EIKON_APP_KEY, grant = ld.session.platform.GrantPassword( username, password),…
-
Is it possible to retrieve the historical constituents of the ACWI index using Python?
Our main challenge has been downloading the constituents of the MSCI ACWI index, whether current or historical, as both are crucial for our objective. Unfortunately, we have been unsuccessful despite multiple attempts. Below are the details of our efforts: Code Attempt 1: import refinitiv.data as rd from…
-
Historical data for CDS spread for a list of companies
Hi, I would like to retrieve five-year-maturity CDS spread for a list of companies on a specific date historically. Is it possible to do this with Python using API to Workspace application? Could anyone help me with this? Thanks a lot in advance!