-
How to pull data from VCHAINS app via Python API ?
One of our users needs value chain customer data for approximately 538 listed companies. In the Workspace interface, she can easily view this data for individual companies via the VCHAINS app and export it to Excel. However, manually exporting data for all 538 companies one by one is not practical. She tried to retrieve…
-
Get media data
I would like to download media data (please see screenshot) in LESG workplace with both titles and actual articles, but couldn't find where to download. The Save button here seems to only save the search. Manually copying and pasting is not realistic for the case since we need a large amount of data for analysis later. Is…
-
Accessing data from the excel add-in 'Download Manager' via python instead of excel?
The excel addin contains something called 'download manager' that contains useful power/carbon data. Currently I have to manually pull this in by clicking through excel. Is there any mechanism I can use to access this data via python api?
-
SDC platinum and Deal screener
I am currently using LSEG Workspace to collect data for my research, and I have a few questions regarding access permissions and ethical data usage Initially, when I searched for the "SDC" database directly, I received a prompt stating that I do not have permission for the SDC add-on (please see attached Screenshot 1).…
-
Ratings fields from Workspace API
Hi, I have a developer thats trying to get values for the below fields from the API: "TR.IR.RatingDate" "TR.OrganizationName" "TR.IssuerRating” “TR.GR.Rating” ”TR.GR.RatingDate” Can you please let me know what is the correct endpoint to receive values for these? And if possible maybe provide an example Python code. Thanks.
-
Regarding update and subsequent messages in DIRECT_FEED subscription from RFA 8.2 for C++
Hello, We are subscribed to multiple currencies using direct feed and we ask rate, bid rate and contributor name for same. When first time data is received for currency all the fields are received and updated fields in subsequent update messages for the same currency(We are using streaming way of getting feed using RSSL…
-
REST-API to retrieve data
Hello, i'm new on this topic, i hope i can explain myself. We have access to different symbols (RICs?) via web, but we would like to automate data extraction, that is done manually 2-3 times a day by employees. We need following symbols at specific Date and Time (most intra-day at a certain time (8:30 and 9:00, 13:30 and…
-
Is it possible to import Bloomberg data into TREP-RT and if so, how?
Is it possible to import Bloomberg data into TREP-RT and if so, how?
-
Requesting access to trapi.data.research.read / trapi.alerts.research.crud scope for Research API
Hello, I am a student at the University of Toronto. I am trying to access Aftermarket Research reports via the Refinitiv Data Platform API. Currently, my account can generate tokens, but the access token does not include the required scopes (trapi.data.research.read and trapi.alerts.research.crud). As a result, I receive…
-
get_data with frq
ld.get_data(universe=spx_list, fields=["TRNOVR_UNS", "TRBC_INDUSTRY", "TRBC_ACTIVITY"],parameters={'SDate': '-20D', 'EDate': '0D','Frq':'D'}) attempt to a list of RIC info with relative start date and end date with Frq . the return result is not in wanted frequency let say i want a 20 day data with daily or minutely frq,…
-
How to pull historical price data for multiple companies in Excel using Workspace?
Hi everyone, I'm building a database in Excel with about 100 listed companies and indices. I want to pull historical closing price data for each of them—ideally with the dates in the first column, and each company's closing price in separate columns. I've used the formula builder tool in Excel to get the latest share price…
-
Getting delayed data from ADS Host
We've been having some issues with live data from RDMS. Basically, we look at refinitiv as close to 7:30 PM UK time as possible to estimate the settlement price for brent. For example for Dec brent (LCOZ5) - we were expecting the settlement price of 70.38 and the value we got back was 70.18. The price we got appeared to be…
-
Loop mutual funds holdings
Hi everyone, I am trying to download mutual fund holdings data using the following code in codebook: import refinitiv.data as rd from refinitiv.data.errors import RDError import pandas as pd import time LP=[ 'LP40215045', 'LP40212543', 'LP40235060', 'LP40209239', 'LP40209247', 'LP40215141', 'LP40212555', 'LP40209256',…
-
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…
-
How can I use API to authomatically download funds' holdings informations?
Hi everyone, I am a researcher at the Catholic University of Milan, currently working on a project that involves historical holdings data for U.S. actively managed mutual funds. Specifically, I require the full holdings information (not just the top 3 holdings) for all such mutual funds, on a quarterly basis over the past…
