-
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…
-
CodeBook Crontab or something similar for scheduling Python scripts
Hi everyone, could you please let me know if there is a way in CodeBook or anywhere else in Workspace to configure a task that would run a Python script at a specific time every day? Currently, I download the data manually by running the code, but I would like this process to be automated and executed daily at the same…
-
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…
-
Time out error when downloading bonds from the govsrch
Dear community, I am trying to download bonds information data from the govsrch using the following code: # Define the start and end dates start_date = '2025-01-01' end_date = '2025-06-30' # Generate a list of dates between the start and end dates date_range = pd.date_range(start=start_date, end=end_date) # Convert to a…
-
Is there a more efficient method to identify the necessary RIC Code to get Dividend Forecast
The initial Query is; Salesforce Case: 14975215 The following securities have Projected Dividends listed on the front end of the Workspace, however, they are not present in the Refinitiv API when we request them Instruments ADSGnDIVCF.F TURUDIVCF.L BASFnDIVCF.F BAYGnDIVCF.F BRKbDIVCF.U DTGGeDIVCF.F DTEGnDIVCF.F FREGDIVCF.F…
-
Retrieving annual reports using LSEG API
For a research project, I would like to download the annual reports for a large set of European firms over the period 2010-2023 (following a similar approach as in this article: Global Evolution of Environmental and Social Disclosure in Annual Reports - Lin - 2024 - Journal of Accounting Research - Wiley Online Library).…
-
DSS Rest API - Triggered extraction
Hi team, Would it be possible to do an API extraction and utilise the feature in the GUI to trigger the extraction when the data is available? see the screenshot below. Ali
-
Im having trouble the get aligned data with dates for some instruments
Im having trouble with the API. As you can see below, the resultant dataframe comes with null values on the last dates, and values on the first dates. The problem is that the "MATD3.SA" didnt exist before 2021. On excel, with same parameters, the dataframe comes alright, with null values up to 2014. So why is this…
-
API Rate Limit Issues
We're noticing weird behaviour on the response headers when calling PermID API using our token. Before we were receiving the following headers X-RateLimit-Limit-day X-RateLimit-Remaining-day which we use in order to manage our requests, but now the response seems to have changed, and we're not getting those headers…
-
Pricing basis for Physical Commodities
I want to get FX broken dates calculator to hedge basis price contracts for commodities e.g. Cotton. Sample code as below: df = ld.get_history('JCI-CTN-ANHUI','TRDPRC_1',start='01-Jan-2025',end='26-Jun-2025') #This is spot price for China Anhui cotton. df2 =…
-
Why am I receiving "a 'dict' object has no attribute 'url' in my API code?
Client is receiving "a 'dict' object has no attribute 'url" error message when trying this code on his end: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = [ 'US0378331005', 'US02079K3059', 'GB00BH4HKS39', ], fields =…
-
Usage of Screener in Python
I need to know how to properly work with the API so I can use all data and be able to filter through it as in the Screener. Therefor I use python. I need help with binding the API and accessing the necessary Data. Example: average ROE of the consumer Discretionary Sector
-
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 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…
-
Download 10-K filings and time of receipt with Filings API
Hi, I had a question on using the Filings API (described here: https://developers.lseg.com/en/article-catalog/article/introduction-to-filings---python) : Is it possible to download both the document and its metadata at the same time? I need to download the 10-K filings for multiple companies and also need the exact time…