-
Accessing DIB fields through python RDP API
What's the procedure for accessing fields from the Data Item Browser app through the Python RDP API? I'm used to the get_fields method from Eikon and I'm having trouble finding the correct endpoint for the RDP platform. I'm wondering if there's an endpoint to query from using RIC and field name as parameters. Thanks! EDIT:…
-
Hello, my team at GS is looking for documentation on how to generate RIC's for a variety of securiti
Hello, my team at GS is looking for documentation on how to generate RIC's for a variety of securities, including but not limited to: ETF options, futures, and futures options. Our objective is to be able to programmatically generate RIC symbols for an entire derivatives surface at a time given input data such as strike…
-
Convert Bonds Issued Amounts in EUR using exchange rate at Issue Date
Hi all, I would like to API request to retrieve a list of bonds, with the outstanding amounts converted to EUR based on the exchange rate as of the issue date. Currently, the GOVSRCH function in Workspace performs conversions using the exchange rate as of the previous close. Can you help me? Best Giacomo
-
How to use CUSIP to get the RIC for equity indices?
I'm using python API. I'm trying to extract RIC for Equity Indices by cusip. As an example, I have Cusip 648815108 for S&P 500 Index and Cusip 12497K100 for CBOE Market Volatility Index. However, when I search with the below query I have an empty dataframe returned. df3 = rd.discovery.search(…
-
WC1 and case delta screening
Hi, I would like to see the differences between the two screenings of a case. I tried this endpoint: POST {{protocol}}{{gateway-host}}{{gateway-url}}cases/{{case-system-id}}/screeningRequest with body { "screeningMode": "DELTA_SYNC", "caseInfo": true} I know that I updated the case, let's say yesterday, with new…
-
Different result between rdp API with workspace app and using config file.
Hi all, We are currently building out an application that is using the Refinitiv RDP API to retrieve information. We have found two ways of connecting to the API : We can just open a session using rd.open_session(), when running code locally with the Refinitiv workspace open We can specify a config file containing our API…
-
SPX and crash observations
I want to recreate the following chart and table. The picture shows drawdowns of the S&P 500 index from 2019 to 2022 that are equal to or greater than five percent. I am unable to locate them because I do not fully understand the methodology used to calculate them. Do you have any suggestions on how to implement this in…
-
RtGet() using lseg.data library
Hi, how would I do a function like =RtGet("SYD1", [@RIC], "COUPN_RATE") in python using the lseg.data library? Thanks
-
Quesstion about RIC code of JGB
I cannnot take bid ask price of JGB by the code attached below. I would appreciate it if you could tell me the reason and solotions to correct this problem. I think this may happen because I cannot take appropriate RIC code of JGB. import lseg.data as ld from lseg.data.content import symbol_conversion ld.open_session()…
-
Question about getting bid ask of Isincodes by Codebook V2
I use the code below to get bid ask by codebook. My code is working but cannnot get the data whose isincode starts from JP. Could you tell me the reason if possible. import pandas as pd import lseg.data as ld from lseg.data.content import symbol_conversion ------------------------ 設定 ------------------------EXCEL_IN =…
-
CBT grains settlement
Please look at the settles for Soybeans SN25 , Corn CN25 and Wheat WN25 . Why is the cirrency USc ? This is messing up our settle capture Thanks Raja 4753957364
-
Linking VBA with the Data Tools functions
Is there a way to link the excel functions with VBA? I want to start my VBA code as soon as i resume updates.
-
"Number of user subscription exceed the limit" error: news-stories-subscriptions endpoint
Hi, I am attempting to connect to the https://api.refinitiv.com/alerts/v1/news-stories-subscriptions via a Python script on my local machine. When doing a POST request to this, I keep hitting the following error: {"error":{"id":"3aa593ff-7498-4dbc-8aca-b3882f556d0a","code":"30016","status":"422","message":"Number of user…
-
Question about parsing exchtime value
Hi, I use below logic to parse exchange time SALTIM_MS / QUOTIM_MS: var time_ms = java.lang.Long.parseLong(str) val nsec: Long = (time_ms % 1000)*1000000 val seconds: Long = time_ms / 1000 % 60 val minutes: Long = time_ms / 60000 % 60 val hours: Long = time_ms / 3600000 % 24 time = LocalTime.of(hours.intValue(),…
-
How do i get the historical adresses of US companies?
I would like to investigate the relocation of corporate headquarters of publicly listed US companies. Therfore i need the old and new headquarter addresses and ideally also the relocation date/announcement of relocation date. How do I find that data? I have access to Refinitiv and Refinitiv Eikon.
