-
I need to pull the broker information for all the RICs I have in one request.
Requirement is – For a given RIC, we want to retrieve all contributing broker quotes in a single bulk call rather than querying one RIC at a time. Is this possible via a bulk snapshot or using some wild char, and what is the recommended approach for ~5,000 RICs. Example RICs : ZARQB3J4Y, ZAR18X21F For the new broker…
-
Identifiers while retrieving issuer curve information using Python
I am interested in retrieving issuer curve information using Python. Currently I have the following working example: df = ld.discovery.search( view = search.Views.FIXED_INCOME_QUOTES, query = "BASF SE", select =…
-
ld.discovery.search for multiple instruments
Is it possible to use `ld.discovery.search` for multiple instruments? When I try: ``` ld.discovery.search( # view="EquityInstruments", query=["PA1436583006", "US5128071082"], select='ExchangeCode') ``` I get: `LDError: Error code 400 | Validation error: json.Query in body must be of type string: "array"` even though ```…
-
Historical search for RIC validity - HTTP request
Hi Team, Can you please help me to whether multiple instruments can used while querying this endpoint URL : https://selectapi.datascope.lseg.com/RestApi/v1/Search/HistoricalSearch…
-
How to search for inactive/matured corporate bonds via Data Library for Python (equivalent to GOVSRC
I'm using the lseg-data Python package (v2.1.1) to retrieve corporate bond data. What works: ld.discovery.search(view=GOV_CORP_INSTRUMENTS, filter="IssuerName eq 'Apple'") returns active bonds (AssetState=AC) ld.get_data(universe=['US03785EPC20'], fields=['TR.FiOriginalYieldMaturity'], parameters={'CH': 'Fd', 'RH':…
-
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?
