-
Is there a way to pull summary page details via DSS Rest API for ORG ID -13109?
The client built an API query to do a search on a holding entity and look up/extract the underlying bonds. This info is showing correctly in DSS GUI and in Workspace, but when the client wants to replicate the same via API it not working. Could you please help us with API call?
-
How to get the RICs for all stocks listed on the Shanghai Stock Exchange
Hello！ I'm trying to get the RICs for all stocks listed on the Shanghai Stock Exchange, but it seems to keep returning an empty table. Does it support SQL queries? Or where can I verify this myself ？ like which place in the workspace to check if it's written correctly? tks. df = rd.discovery.search(…
-
GOVSRCH saved template via Refinitv Python code
I have saved quite a few screens on GOVSRCH. The question is how this can be automated so that I get the same output as saved search. I looked into the below code mentioned earlier. However, I have 2 questions: How will it identify which saved search I am calling? Getting this error "No default session created yet. Please…
-
Bank Ric history
Hi, I would like to get all OTP Bank RICs existed after 2010, in pyhton. The following query only results in the currently existing bonds, how to get all the history, including the already matured ones? import refinitiv.data as rd rd.open_session() rics_df = rd.discovery.search( view =…
-
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"),…
-
Is there an option within the Futures & Options search function in DSS API with Exchange filter?
Our client has been searching futures and options data within the Futures and Options search function in DSS. They have the challenge where the business teams provide the payment team with about 10 securities a month that don't have RICs or ISINs. The payment team is happy with the data retrieved through the GUI search…
-
Is it possible to access to the RIC using the company name?
-
How to get unique delisted stocks using RDP search?
I am trying to get the delisted stock's details using RDP search. But there are multiple entries of the same stock(different share class, different listing location, etc.). Here is the code that I am using to pull the data: df = rdp.search(view = rdp.SearchViews.EquityQuotes, top = 10000, filter = f'''…
-
Hi, I’m trying to retrieve the Equity RIC of a company in the Codebook. Is it possible to do this us
import refinitiv.data as rd import pandas as pd rd.open_session() # List of company names to search for company_names = [ "TAKEDA PHARMACEUTICAL CO LTD", "EURONEXT NV", "BAXTER INTERNATIONAL INC", "EMERSON ELECTRIC CO", "FIDELITY NATIONAL INFORMATION SERVICES INC", "FISERV INC", "INTERNATIONAL BUSINESS MACHINES CORP",…
-
Is it possible to retrieve all existing government bonds data ?
Hello everyone. I would like to retrieve all existing bonds by country. For example, I would like to obtain the ISINs, RICs, maturities, and issue dates for France.
-
Get all related RICs given an ISIN using LSEG module
I need to get all available RICs possible for a certain ISIN through python via lseg-data library as I need to get all contributors available. Before, I can do this using Eikon library as shown below. data = ek.get_symbology("GB00BFWFPP71", to_symbol_type='RIC', best_match=False) Tried, using symbology and…
-
Download10-K filings by using workspace.
Hi! I’ve been working on a Python script to download some 10-K filings by using workspace, but this error message appeared: [DiscoverySearch] Sending body_parameters: {'json': {'View': 'equityQuote', 'Query': 'AAPL.OQ', 'Top': 3}} [DiscoverySearch] Library recorded body_parameters: {'json': {'View': 'equityQuote', 'Query':…
-
GovCorp Search showing limited data
One major client is doing a GovCorp search via API and the response from the API is limited compared to the results in the GUI (I am able to reproduce it). They are specially interested in getting if the bond is a corporate or government bond. Fields responded by the API with GovCorpSearch: {'Identifier': 'XS3102778191',…
-
Can you please confirm how to add filter to screen the funds via API on Workspace?
Can you please confirm how to add filter to screen the funds via API on Workspace? How to build the screening parts into the filter? For example IA sector = North America using the script below : import refinitiv.data as rd import pandas as pd rd.open_session() df_universe = rd.discovery.search(…
-
ESG Bonds and RCSFIClassificationCodes
Hi! I am looking at ESG bonds issued by firms. I am trying to understand the RCSFIClassificationCodes variable, which for each ESG bond outputs one or more lists the following structures:{'Code': String, 'CodeDescription': String, 'CodePermID': String, 'IsESGStandard': Boolean, 'Type': String, 'TypeDescription': String,…
