-
Python API to retrieve historical data of economic events
I am using the python api to retrieve historical data of Economic Events using the get_history() method but i cant find the fields which it will take to retrieve different columns such as Prior , Actual , Revised etc.. Any reference material will be very helpful.
-
How to retrieve the historical list of all listed stocks at a specific past date?
Hello, I am working on an academic project and need to backtest a custom ESG equity index from 2010 to today. For this, I need to retrieve: The full list of stocks that were active at each monthly rebalancing date (e.g., January 2010, February 2010, etc.). (we can also limit this by geography saying only stocks in Europe)…
-
How to reference a list of instruments stored in Excel and how to display financial period in CH?
How to edit the syntax so that it will reference an Excel file containing up to 250 RICs? How to edit the syntax so that it will display the financial period in the columns (e.g. FY2018Q1, FQ2018Q2, and so on). Tried adding 'CH': 'Fd,Fperiod' but it did not work. This is what I am currently working on: import…
-
Why I try to get 1 minute data by using get_history, but returned data is missing ?
Hi, I am trying to get 1 minute ice brent oil price from workspace python api. I am using get_history function like this: (I live in EAST-8) df = ld.get_history(universe='LCOcv1',start="2025-04-23",end="2025-04-24",interval="1min",count=2000000) What I get is: Latest data is 2024-04-23 21:59:00, seems to be UTC time, so it…
-
Historical Federal Funds Futures Data via Eikon API
Hey, I want to access historical Federal Funds Futures data for every month from 2025 to 2000 as tick data via the eikon API in Python. I don't know why, but every RICs Code I have tried does not seem to work. I also can't find historical data on Workspace itself which seems to be somewhat consistent in its RICs Codes and…
-
Error retrieving historical data from Refinitiv Workspace: timed out
This is question about the historical_pricing endpoint using Refinitiv Workspace. I am making this call through the Python library refinitiv.data.content and using the historical_pricing object. response = historical_pricing.events.Definition(universe=tickers,start=start_datetime,end=end_datetime).get_data() When I pass…
-
How to pull historic maturities for a RIC
Hi, I would like to use the python refinitiv data library to pull historic maturities for a relative ticker, such as: USDSROIS1Y= Please advise how to do this? As ticker is relative, the maturity changes every day, and the field "MATUR_DATE" does not return anything on an historic basis. Thanks,
-
How do i get the historical adresses of US companies?
I would like to investigate the relocation of corporate headquarters of publicly listed US companies. Therfore i need the old and new headquarter addresses and ideally also the relocation date/announcement of relocation date. How do I find that data? I have access to Refinitiv and Refinitiv Eikon.
-
Pulling FX NonDeliverable Forward Curve
Hi, I am currently using the Workspace Excel function to pull in data for a list of BRL FX Forwards with the formula =@RHistory(H7,".Close","TIMEZONE:LON INTERVAL:1D NBROWS:1 END:"&24-Apr-25 21:00) I want to do the same through Eikon Data API and have all the forwards pulled for a specific date and time (in London) into a…
-
How could I collect the historical series of the closing price of shares adjusted for stock splits,
-
What is the rate limit of events api of historical pricing in LSEG Data Library?
I am using the LSEG Data Library for Python to extract price data via Workspace. I divided the ric list into a few groups, and each group contains 25 rics. Then I tried to retrieve the data in a loop. It worked for a few minutes and finally threw out 429 error. I noticed there is rate limit for RDP API, but not sure if it…
-
Historical ask data
Hello! I am a student at the University of Ghent and for an assignment, we need to follow an option. We choose the option AIR12920F5.p, but we need to find the historical ask price. How can I do this? I already tried different approaches, but nothing works. For example: I cannot open the tab price - historical price,…
-
Eikon Python Data API migration to lseg-data. get_history() request empty result
Hello, The second problem with get_history(): sometimes, for some requests the function returns nothing. Empty DataFrame. There is no way to get any details on what happened. The behavior is not consistent. Right now I see an empty DataFrame for this request: dataFrame = ld.get_history( universe= ["INDJ25"],…
-
Duplicate Timestamps for historical_pricing results
Hello Friends, I got an issue which needs your kind help to address. To Keep in line the difference in timestamp from ld and ek library, I'm trying to summaryTimestampLabel parameter to retrieve FX hourly data, as referenced in this discussion. However, when I'm using summaryTimestampLabel in historical_pricing , the…
-
Refinitiv.Data .NET library passes DateTime in incorrect format to interday-summaries endpoint
This is referring to my recent report: Erratic response for interday history request (start date sometimes not included) - LSEG Developer Community I got an answer from the Historical Pricing API Support Team: After investigating the issue, we found that the problem arises because the request you are submitting is using an…