-
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…
-
Query regarding "refinitiv.data" function get_history(). How to get month end dates data?
I am working with Python API and the library refinitiv.data in it. There is the function refinitiv.data.get_history get_history( universe: Union[str, Iterable[str]], fields: Union[str, Iterable[str], None] = None, interval: Optional[str] = None, start: "OptDateTime" = None, end: "OptDateTime" = None, adjustments:…
-
TR.FreeFloat call timing out
I'm trying to query data for about 500 RICs, but here are the first 5: 'A.N', 'AABA.OQ^J19', 'AAL.OQ', 'AAP.N', 'AAPL.OQ' if i use this formula: ld.get_history( universe=ok_tickers, fields=['TR.FreeFloat'], start=s, end=e, interval="1D" ), the query times out as it takes too long to queryhence i am trying to look for an…
-
Bond Python Data Issue
I have a question regarding you Python API. I am trying to pull data for ISIN FR001400CKA4. However, I get the following error:refinitiv.data._errors.RDError: Error code 1 | No data to return, please check errors: ERROR: No successful response.(TS.Intraday.UserNotPermission.92000, User has no permission)This code works for…
-
How to retrieve Historical Data for Bid-Ask Yield and Bid-Ask Spread forBonds
I want to download the Bid-Ask Yield spread. But I am not sure which field I need to use. Below is my python code to download the bid, ask,mid yields. I hope you can help me to find an appropriate field for bid-ask spread. Currently using below fields = ['B_YLD_1', 'A_YLD_1', 'MID_YLD_1', 'YLDTOMAT'] fields_length =…
-
historical estimated EPS for multiple periods
Hello everyone I require the historical mean estimate earnings per share from analysts for a company for multiple time periods forward. For example, the forecasts made in 2017 for the following five years 2017-2021, the forecasts made in 2016 for the years 2018-2021 and so on. I've seen that the reifinitiv eikon terminal…
-
How to get spot currency historical_data from Refinitiv Workspace
this is my code: def get_historical_data(rics: list, start_datetime: str, end_datetime: str): """ Retrieve historical pricing data for a given ticker and time range. Args: rics (list): The list of RICs (e.g., ['AAPL.O', 'GOOG.O']) start_datetime (str): Start datetime in ISO format (e.g., '2023-04-07T15:14:25.165')…
-
Historical Pricing with more than one underlying in excel vba
Hi, We used excel vba code with the old "RHistoryAPI.dll" to query the prices for several stock underlyings. In the new "LSEG COM Library for Workspace" I also looked at the example file for historical pricing from the website "https://developers.lseg.com/en/api-catalog/workspace-sdk/lseg-com-library-for-workspace".…
-
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.
-
Hi can I ask how do i get the mid price and YTM for bonds via the python API for historical pricing
how do i get the mid price and YTM for bonds via the python API for historical pricing
-
Pulling historical data for a specific ric in Python versus Excel.
Der Team, I have a client asking the following: Good morning Charlotte, I hope you are doing well. I am reaching out as there appears to be an issue pulling historical data for a specific ric in Python versus Excel. I am currently able to pull via python historical barge freight. When I try the same for CIF NOLA Corn, it…
-
Retrieve historical Ultimate Parent given a LEI
I am creating a historical database to track track the relationships between fund managers and the ultimate parent of a fund. To do this, I am using the LSEG Python API. I have been testing this procedure using the rd.get_data() function. This allows me to retrieve the name and PermID of the ultimate parent for a list of…
-
How to properly use Python to extract data from LSEG workspace
Government bonds, for example RIC = 'GB10YT=RR', which is the 10 Year Government Bonds of the UK. I am trying to grab its daily data. At first, I am using fields=['TR.OpenPrice.date','TR.OpenPrice','TR.HighPrice','TR.LowPrice','TR.ClosePrice'] in my code. But The close price showed nothing. Then, I changed the fields to…
-
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…
