-
Python code for 3K ISIN
What I want is to download the data for 3K ISINs. That can be done using Python.if I use python I don't get auto-imputed data. Below is the Python code client is refering import refinitiv.data as rdfrom tqdm import tqdmfor isin in tqdm(isins):try:response =…
-
Were there recent changes to "TR.IndexJLConstituentRIC.date" and "TR.IndexJLConstituentRIC.change"?
I used to get index changes in the SPX using the following code: index_changes = rd.get_data(universe = index_ric,fields = ["TR.IndexJLConstituentRIC.date", "TR.IndexJLConstituentRIC","TR.IndexJLConstituentName", "TR.IndexJLConstituentRIC.change"],parameters={"SDATE": init_date,"EDATE": end_date, 'IC':'B'}) As of…
-
Please can you explain why there is a lag on receiving EIA stats data via a script i have written?
Hi team, I am posting on behalf of an external client for the query below, please help and prioritize: Please can you explain why there is a lag on receiving EIA stats data via a script i have written using the appkey? from lseg.data.content import historical_pricing as hp from datetime import date import os 1. Correct RIC…
-
Can I get content I am seeing on LSEG Workspace available in a systematic feed or product
Specifically, I am interested 3 views, listed below with screenshots: The “Economic Monitor” screen (Accessed by "Macro -> Economic Monitor") The "Interest Rate Probabilities" screen (Accessed by "Macro → Interest Rate Probability) The "Probability Distribution" screen (Accessed by "Macro → Interest Rate Probability" page,…
-
how to filter news article by its source, language through Python?
-
Retrieve weekly eia inventory data to update my csv directly
This is my first part of script that should retrieve the latest data? cell 1 import lseg.data as ldld.open_session(app_key="app-key").open() cell 2 from lseg.data.content import historical_pricing as hp from datetime import date import os 1. Correct RIC for total commercial crude stockscrude_rics = ["C-STK-T-EIA"] 2. Date…
-
Dual-listed stocks/ Dual listings
I am wondering whether it is possible to identify dual-listed stocks from Refinitiv. I am interested in dual listings (different to cross listings) where two entities enter into an equalization agreement and become dual-listed. There are two main types: Combined entities and separate entities. Combined entities refer to…
-
Difference between 'Date' and 'Calcdate'
Hello everyone, I have a quick question regarding ESG-related data items and the dates they refer to. Let’s say I request ESG data (e.g. CO₂ emissions) for a company on 15 April 2024, and I receive a value in return. I would like to understand whether the reported value actually refers to that calculation date (15 April…
-
Current sales, Net margin and wages or labour costs' and need to add to the field TRDPRC_1 with the
Current sales, Net margin and wages or labour costs' and need to add to the field TRDPRC_1 with the correct RIC I would like to download the 'current sales' , 'net margin' and eventually 'wages' or 'labor costs' and need to add to the field TRDPRC_1 with the correct RIC, wchich i do not find in the DIB ... can you and your…
-
HOLIDAY LIST using Eikon API in Python Dataframe
I tried to get the Holiday List using Eikon API in Python but no help, can we get in Python pandas dataframe so that we can use it and play with it ? Please see attached my query in python script.
-
Need API code to extract 'total sales', current and 12m forward, Net Margin, profits forward 12m, of
Hello, Need API code to extract 'total sales', current and 12m forward, Net Margin, profits forward 12m, of SP500 and STOXX600, and Total Labor cost, ideally for the two equity indexes, if not at country level?". I started the way below but does not work. May be you can correct it pls, takes probably a few seconds for you…
-
Mapping of a company and related bonds in refinitiv data api
Hi Team, Could you provide the details of where we can find a mapping of a company's ISIN to all its bonds' ISINs in the Refinitiv data API? For example, we would like to have a mapping of Mercedes-Benz (DE007100000) with all its related 36 bonds (see screenshot). Thank you.
-
Codebook App 30 min time frame
i have a question regarding LSEG Workspace as specially the Code Book App. I want to get historic data of an instrument e.g. LSEG.L for the fields BID, ASK and VOLUME on an 30 min time frame. In Excel it is possible to get the data via the Workspace Add-In. But in the Workspace Codebook App I don’t get the VOLUME data. How…
-
Importing Deal Screener
Hi! I am trying to access M&A data via a Python App but I'm getting an error importing the Deals Screener. This is my attempt: import refinitiv.data as rd from refinitiv.data.discovery import search from refinitiv.data.content import deals import pandas as pd rd.open_session(app_key="APP KEU") screener = deals.Screener()…
-
Python DSS API extraction is giving be below error as malformed
Code def get_rics(token): url=f"{BASE_URL}/Extractions/ExtractWithNotes" headers={"Content-Type":"application/json","Authorization":f"Token{token}" } payload = {"ExtractionRequest":{ "@odata .type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentsListExtractionRequest", "ContentFieldNames":…