-
Request for an API code for Municipal Bonds In SDC that reports out for league table
SCREEN(U(IN(DEALS)), IN(TR.MuniSDCDealTypeCategory, "TE") AND relativedate(TR.MuniSaleDate(IncludeNull=False), YTD), TR.MuniIsLeagueTableRankEligible=true, NOT_IN(TR.MuniIssueBidType,"P"), TR.MuniIsPreliminary = false, TR.MuniYearToMaturity>=1.09, NOT_IN(TR.MuniSdcDealNumber,17051766039, 15120840039,…
-
Hi Dev Team, can you please help and assist on the client's query
You may refer to the compressed script in the PDF . We tried replicating but getting the same error as well. Is there a problem with the codebook? It is taking a long time to load the data, and all the variable columns are completely filled with NAs. import pandas as pd import numpy as np import refinitiv.data as rd #…
-
How to retrieve Bond (DCM) Deals from Bond Screener in Python API?
How to retrieve Bond (DCM) Deals from Bond Screener in Python API? Client's query: Is to get "Use of Proceeds: Project Finance" and New Issues Ratings: Moody's Debt/Bank Loan Rating" in Deal Screener app and requested if this is available in Python API. Tried using code: import refinitiv.data as rd rd.open_session() df=…
-
Excel formula to API Script - 16030891
Posting on behalf of client Client wants to get all private companies in API. As per product specialist, this data can pull using below excel formula. Kindly convert below excel formula to API =@TR("SCREEN(U(IN(Equity(private))/*UNV:Private*/), IN(TR.HQCountryCode,""IS""),…
-
Supply chain API fields, score definitions, historical data availability, and metadata coverage.
1. Supply chain field names and missing rows In my pipeline I am querying each company using `TR.SCRelationship`, `TR.SCRelationship.ScorgIDOut`, `TR.SCRelationshipUpdateDate`, `TR.SCRelationshipConfidenceScore`, and `TR.SCRelationshipFreshnessScore`. The problem is that for many large, well-known listed companies I…
-
In Codebook, the screener does not work when the field TR.NAICSNationalIndustryCode is included. For
In Codebook, the screener does not work when the field TR.NAICSNationalIndustryCode is included. For example, the commands screener_output=Screener('U(IN(Equity(active,public,primary))), IN(TR.GICSSectorCode,"45"), IN(TR.NAICSNationalIndustryCode,"513210"), TOP(TR.H.EV(Curn=USD),7,nnumber),Curn=Native')…
-
Does the lseg-data Python library provide any way to download IPO Prospectus data?
We are interested in pulling prospectus data for companies that are about to go public. We found some of the data under Equity New Issues Deals through the Deal Screener app in Workspace. Is there any way to pull this data programmatically through the lseg-data Python library?
-
How to map Screener "Data Item Names" to "Data Item Codes (TR Codes)" via API or Master Dictionary?
I am an academic researcher using the lseg.data Python library to extract historical M&A data (SCREEN). Currently, I use the Workspace Screener to identify the variables I need. However, the Excel export only provides the "Data Item Name" (e.g., Premium Paid - 4 Weeks Prior to Announcement, Target Primary Ticker Symbol),…
-
SQL Query for IPOs
Currently, we are able to access information about upcoming IPOs through Dscreen. Could you please confirm if there is any database table available that we can query directly via SQL to fetch the latest announced upcoming IPOs? Specifically, we’d like to know: If such a table exists in our database The schema or table name…
-
HOW CAN I GET ALL TICKER NAMES FROM CONSOLIDATED EXCHANGES IN US
e.g. AAPL.OQ rather than AAPL.O THIS IS MY CODE. I'M USING CODEBOOK ld.open_session()#US#tickers= list(Screener('U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.ExchangeCountryCode,"US"), IN(TR.GICSSectorCode,"10","15","20","25","30","35","40","45","50","55","60"), DOES_NOT_CONTAIN(TR.ExchangeCode,"PNK"),…
-
MnA Deal Information
Hi, I would like to retrieve additional information about deals via the api, but I can only appear to get deal value. Is there a way to retrieve other target financials also? Sample code: screener <- 'SCREEN(U(IN(DEALS)),IN(TR.MnATRBCActivity,"5020101011"))' fields <- c( "TR.MnASDCDealNumber", "TR.MnAAnnDate",…
-
Private Equity/VC data retrieval through API
Hello, I am trying to download the Private Equity/VC data through the API. import refinitiv.data as rd from refinitiv.data.discovery import Screener rd.open_session(name='platform.rdp', config_name="./refinitiv-data.config.json") screenr = "SCREEN(U(IN(Equity(private))), BETWEEN(TR.PEInvestRoundDate,20251225,20251231),…
-
API code to get PE investments from API
What is the code to get Private Equity/VC data from Screener for custom Investment Date for the Investee Company Nation = United States filter. Here are the fields I need: Company Name, Investee Company TRBC Economic Sector, No. of Deals in Search, No. of Firms in Search, No. of Funds in Search, Sum of Equity Invested in…
-
Ongoing Screening Disabled For Automatic Screening
Hello, I am reaching out for help with understanding the World Check functionality as a not-experienced user of this application. My client uses World-Check Customer Risk Screener. Recently I was notified that automatic rescreening of individual screening cases does not work. Here is what I mean: Once the review of the…
-
Hello, I'm downloading same set of listed companies from screener and codebook, and I retrieve diffe
Hello, I'm downloading same set of listed companies from screener and codebook, and I retrieve different results for some fields, what is the reason for this? in particular, IPO date column is quite missing with API, i compare a sample of companies for Australia. but it also applies in general. I tried downloading…
