-
Why is the fperiod not properly aligned with the values?
I'm having problem when downloading financial income data. For this example in the code below, the "Financial Period Absolute" (fperiod) is not properly aligned with the true financial data. We can see that on "TR.F.OperProflnOpCASR | XEBT", there are 2 values on FY2024Q4, but it should be one value for FY2024Q4 and…
-
What is the syntax to use Percent changes on Estimate/Fundamental Data Items
Hi, We have an excel syntax for percent changes. Example: =@RDP.Data("AAPL.O","PERCENT_CHG(TR.FCFMean(Frq=FY SDate=0 EDate=4),wsize=-3)","Frq=FY SDate=0 EDate=4 Period=FY1 CH=Fd RH=IN",H35) How do we code this in Phyton? Regards, Dan Gabriel
-
Using Getdata function to Get CUSIP based on RIC
Hello! When I was using Getdata function in Refinitiv Workspace API, I used RIC to get CUSIP (and I set the parameter: 'SDate' and 'EDate', I tried to make they are the same day to get the certain day's data). However, most of the transfer is right, some of the CUSIP I got is totally wrong. And I mannually double-checked…
-
inconsistency with get_history lseg api endpoint
I'm currently migrating a workflow from the legacy Eikon Python API to the new LSEG Data (RD) API, and I’ve encountered a couple of points that require clarification. In the Eikon API, I was using the get_timeseries() function with fields='CLOSE' to retrieve historical Euribor data for the following instruments:…
-
LSEG api get_history doesnt have CLOSE
I’m migrating from eikon to lseg. I’ve been advised to migrate eikons get_timeseries to lseg get_history. With eikon I can get the CLOSE values (see below in a.). Lseg doesn’t have CLOSE or anything similar. (see below in b.) This is using your own codebook. Please advise. a. Refinitiv.Eikon df_hist_ek = ek.get_timeseries(…
-
API for Eikon vs Workspace Data
Client is currently testing the API for Eikon vs Workspace and the output are different for some fields related to Deals. Attached is a screenshot for your reference. Can you please check if this is normal and what is the reason behind this? Do we have the correct way of getting the data? (Attached screenshot from API) I…
-
Shipping API Question
Is there an API script to see clean products (gasoline, naptha) as imports/exports out of US PADDS zones?
-
Provide Shipping Flows Python Script
Looking for someone to help put together a script to pull shipping data for clean products (gasoline, gasoline component, naphtha, Gasoline / Gasoline Component) as imports/exports out of all US PADDS.
-
I can not generate an API key in App key generator app in WORKSPACE
Any idea how to fix this? Not sure if WORKSPACE SDK.
-
Getting latest data for continuous futures contracts
Using the lseg.data library, I would like to download the latest traded price TRDPRC_1 and settle price if available. I have access to historical data using ld.get_history() but mostly empty data sets using ld.get_data(). Can you confirm python script that should work for Cc1 and Sc1 and/or a way to see if our subscription…
-
Multiple values returned from get_data
Hi, I've inherited some Python code that downloads debt seniority data. I'm running a test on a single security: df_pull_isin, error = ek.get_data(instruments = 'US404280EN53', fields = [ 'TR.NISeniorSubordinatedDebtIndicator.date','TR.NISeniorSubordinatedDebtIndicator.value']) returns output of the form 4414 US404280EN53…
-
What is the API description of these reuters:// code
Client raised a question. I have a question, I built a C# tool that was able to Open the refinitiv eikon quote window, if i supplied it a RIC. See code below. I now was switched to Workspace. What would be the equivalent in here to "reuters://REALTIME/verb=Chart/ric=AAPL.OQ" ? What would be the equivalent to open a chart…
-
How to Download ESG News from All S&P 500 Companies Using API
Hello, I am looking for a way to download ESG news for all S&P 500 companies using the Refinitiv Data Platform (RDP) API or the Eikon API. My goal is to retrieve articles, headlines, and any relevant information related to sustainability, governance, and ESG criteria for the companies in the index. Specific Questions:…
-
Excel Integration: How to retrieve full monthly historical data for a CUSIP (similar to Workspace)
I need functionality where I can input a CUSIP into Excel and automatically retrieve the full monthly historical data for that CUSIP. The output should look exactly like the monthly historical view available in Workspace under "Trade Check" (see attached screenshot for reference). Please let me know how I can achieve this…
-
Technical indicators
Hi, is there a way to directly pull technical indicators for non-expired contracts for a RIC list/ RIC chain for EoD data? Ideally I would like to pull for example RSI/CCI/moving average values directly everyday to view which contracts are oversold/ overbought on a daily basis as a pose to pulling ohlc prices and…
