-
Discovery Symbology API-Datsatream macro economic identifiers
One of user is asking, The Discovery Symbology API (image below) is designed precisely to map between different identifiers (RIC, ISIN, CUSIP, PermID, etc.) and supports an internal identifier called DatastreamId among the “LSEG specific and heritage identifiers.” So this works for Equities / ETF and similar. Please…
-
DSS - How can I get a full list of equities in selected stock exchanges?
Hi, I hope this is the right place to raise this question. We have been unable to get a satisfactory answer from Customer Support, so I wanted to reach out here directly. We are trying to retrieve all instruments (both active and inactive) per stock exchange (e.g., XOSL - Oslo Stock Exchange) in DSS (Datascope Select).…
-
Symbol conversion function without best match parameters
hi i'm wondering why new methods exposed under Lseg library (content 'symbol_convesrtion' and discovery side 'convert_symbols') there is no best_match option as were proposed by eikon function (get_symbology).
-
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':…
