-
Missing ISIN/CUSIP/SEDOL from ld.get_data even though identifiers appear in Workspace (example: VSSL
Hi, I’m using the LSEG Data Library for Python to retrieve instrument identifiers (ISIN, CUSIP, SEDOL, etc.) from RICs as part of a global equity mapping pipeline. For most instruments, this works well. However, for a subset of equities the API does not return all identifiers, even though they are clearly visible in…
-
Symbology: SEDOL → RIC returns null in Python, but Workspace finds a RIC (ETF holdings use SEDOL)
I’m building an ETF holdings pipeline. Provider files list constituents primarily by SEDOL. I need to resolve these SEDOLs to pricing RICs (and also capture ISIN/CUSIP). I’m using the Python Eikon/Workspace API. What works / what doesn’t In Workspace (desktop), if I search by SEDOL I can see the security and its RIC. In…
-
List of RICs for each PDP market code from DACS
Is there a DACS function or API that returns all RICs associated with each PDP market code? I’m currently retrieving entitlement data using functions like getDacsUserEntitlementsBulk and getCurrencyList via Python, and I’d like to enhance my script by including the list of RICs for each PDP.
-
RIC Spec
Hi there, Is there any RIC specification available apart from the one linked below? https://myaccount.lseg.com/en/faqs/2022/06/000212013 I'm also unclear about the meaning of the caret symbol (^) followed by a code in a RIC. For example: GIWWU.OQ^L22 Could you please clarify what this notation represents? Thanks.
-
Messages without Name field in EMA
Hi all, We differentiate messages received from EMA based on the name(RIC) field contained within the message. UpdateMsg streamId="420" domain="MarketPrice Domain" updateTypeNum="0" seqNum="44766" doNotConflate name="CNH=" serviceId="600" serviceName="IDN_RDF" Payload dataType="FieldList" FieldList FieldListNum="0"…
-
Datastream for Office (DFO) request - download data via LEI
Hello, I have seen a post that there is a way to convert LEI numbers to RIC using phyton - and download company data as such, however, I cannot work with phyton and I wonder if there is a way to download company data with DFO Excel table (Datastream) via LEI (not via ISIN) - and what is it?
-
Historical RICs on Mutual fund holdings
Hello everyone, I’m attempting to retrieve historical mutual fund holdings using the following code: However, the table appears as follows: As you can see, the code returns only the RICs from the most recent holdings, not those from earlier dates. I have two questions: How can I retrieve historical RICs for my mutual fund…
-
Function to get RIC from PermID
How can I get the RIC code of a subsidiary's parent organisation by entering subsidiary PermID (API in Python). For example if I make a function, and I enter BlackRock (Ireland) with PermID 12345, return BLK
-
Help with Excel Add-In for RDP Bond Time Series and Static Data (Formulas Not Returning Values)
Hi, I'm trying to retrieve both time-series and static bond data in Excel using the Refinitiv Data Library Add-In. I'm logged into Refinitiv Workspace and the Excel add-in is active. However, the following formulas aren't returning any data, even though the RIC in F4 is valid and the dropdown setup works: Time-series…
-
LSEG Workspace RIC Code
Dear Team, We need the RIC Code in LSEG Workspace for: USD 3M Libor swap curve and EUR 6M Euribor Swap Cuve. Thanks and kind regards, Marika
-
Are contract rics unique?
I expected that rics representing option contracts on futures or indices would be unique. However I found an example "TY131Y5Z" of a contract ric that represents an option on both 3TYZ1 and 3TYH2. My question is: is there a cutoff date after which I can expect contract rics to be unique?
-
How to retrieve the RICs using the bond ISINs?
Hello Team, I hope all is well. I'm seeking for your help, (for example) Apple, Microsoft and Tesla have bonds going 10 years and each of these bonds have a specific ISIN, unfortunately the ISIN doesn’t map directly to the company’s RIC but to the bond’s RIC. My goal is to sort of input an ISIN of a bond and return a…
-
Missing Fields when there is no Quote on a RIC yet?
We have a new java application that accesses the Real-Time data as a Snapshot via the EMA java API. We came across a peculiar behavior, that our business department considers a showstopper for our acceptance test: When receiving an ema.access.RefreshMsg for requesting data for RICs and processing the field list that is…
-
How to pull historic maturities for a RIC
Hi, I would like to use the python refinitiv data library to pull historic maturities for a relative ticker, such as: USDSROIS1Y= Please advise how to do this? As ticker is relative, the maturity changes every day, and the field "MATUR_DATE" does not return anything on an historic basis. Thanks,
-
Why does .DEX , example GOOG.DEX receive no L2Rics OR complexRICs attribute in discovery search api
When I do a POST request hit to 'https://api.refinitiv.com/discovery/search/v1/' with the below payload, I receive a list of venues … { Filter: "BusinessEntity eq 'Quote' and BaseAsset eq '154423041' and not (ExchangeCode in ('NSQ' 'ASQ' 'NYQ' 'XDS' 'DEU' 'TOJ' 'ITE' 'RRC' 'PCQ' 'NAQ' 'NMQ' 'XBO' 'XCA' 'CAQ' 'AUX'…
