-
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…
-
end-to-end Mutual TLS (mTLS) for authenticating DSS API consumers
I am writing to discuss an important security related matter to our integration with DSS APIs. Previously, We have been informed that DSS is not currently using end-to-end Mutual TLS (mTLS) for authenticating API consumers. While we understand the operational considerations, our security team has raised this as a…
-
How to get domestic/international revenue of listed companies
I met a problem when I used the Python API to obtain data in the LSEG Workspace. For listed company, for example, TSLA.O (TESLA), I want to get the fields in the LSEG Workspace which can obtain the ratio of international/overseas revenue or non-local revenue to local revenue of listed companies. Since there are hundreds of…
-
Get the history changes of RIC
Hello! I am using python library lseg-data. My question is how can I get the history changes of RICs and its previous names, so that my prices are correct? For example Facebook was FB.O but after rebranding it became META.O, I used symbology but did not get the expected result.
-
pricing/snapshots Market Cap field
Hi, How can I get the Market Cap of a stock using the pricing/snapshots service? https://api.refinitiv.com/data/pricing/snapshots/v1/?universe=/{RIC}Error or is there any other service that I can get the updated market data that should be change during trading time according to the stock price. Thanks!
-
How to get earlier time series data of Crypto
I am trying to get time series data of Crypto. And I tried serveral RIC like 'LTC=DARN', 'BTC=DARN', 'ETH=DARN'. Similary, the earliest hourly and minute data it gave me was like only one week ago. The screeenshot above is the minute data of BTC. Therefore, I wonder if there is a method to get long-term hourly or minute…
-
Error with fundamental_and_reference.Definition data api
With the code below: df_chunk = fundamental_and_reference.Definition( universe= tickers, fields = ['TR.CLOSEPRICE.date','TR.CLOSEPRICE','TR.Volume'], params = {"SDate": 0, "EDate": -756, "FRQ": "d"}) why is it raising error? Error processing chunk 1: Definition.__init__() got an unexpected keyword argument 'params'
