-
I/B/E/S EPS and LTG forecasts
Dear Community, I have been trying to understand the data content and coverage of I/B/E/S forecasts for General Motors. Using the following code, I am only able to retrieve data starting from 2010, presumably due to the company's restructuring that occurred around that time. However, I’m surprised that LSEG does not…
-
get_history stopped working in API (Visual code studio)
Hi, since few weeks ( not sure but I think after upgrading some python libraries like pandas etc.) I have problems with getting data using refinitive API in Visual code studio. for example I get empty df with this simple code: import pandas as pd import refinitiv.data as rd rd.open_session()…
-
API Pagination in Python Using Refinitiv Data API
Hello, I'm working on a Python project using the Refinitiv Data API to retrieve large sets of equity quote data. I need to fetch data in chunks of 10,000 records due to API limitations, but I'm struggling with implementing effective pagination to avoid overlapping data without missing any records. The API doesn't seem to…
-
Refinitiv.data proper fields names
Greetings, I am currently involved in a project aimed at retrieving the closing price for companies that have been delisted due to bankruptcy, specifically the day following their bankruptcy announcement. The primary methodology I employ involves checking whether 'TR.MnAHasBankruptcy' is true. If this condition is met, we…
-
Extracting analyst estimates data using Not Null filter for period end date
Hi, I am trying to extract the analyst estimates data as mentioned in the code below - df, err = ek.get_data( instruments = ric_lst, fields = ['TR.EPSMean.periodenddate', 'TR.EPSMean', 'TR.EPSMean.date','TR.RevenueMean', 'TR.NetProfitMean'], parameters={'SDate':'2010-01-01','EDate':'2023-12-13','Period':'FQ1'}) The issue I…
-
A 'get_news_story' request into a dataframe
Hi, I am using ek.get_news_headlines to display a dataframe of 5 news articles for a particular company. i.e. df = ek.get_news_headlines('GOOG.O AND Language:LEN', date_from='2021-01-01T09:00:00', date_to='2023-06-30T23:59:59', count = 5) The above works fine at display the last 5 storyId's... but i'd like to use the…
-
Wieso funktioniert die .at() Funktion bei Pandas nicht?
I have the following code in which I access a CSV file with multiple columns containing numbers and want to change a specific column under certain conditions: import csv import pandas final_activities = pandas.read_csv("VPN2/VPN2_Final_Activities.csv", delimiter=';', names=['Timerels', 'ActivityClass_Ankle',…
-
Unpin pandas dependency in refinitiv-data?
Currently refinitiv-data https://pypi.org/project/refinitiv-data/ has a pinned pandas dependency at 1.3.5, which is a few versions old. Would it be possible to unpin that? It's forcing users to downgrade their pandas versions to use the library. Thank you!
-
Filtering Python Dataframe by Minutes
Hi Developer Community! I have filtered my minute time series data frame by specific hours and minutes. The first Loop filters for 11:30 the second for 9:30. Lastly, I concatenated them next to each other. Is there a way to do the same procedure without using an extra (second) loop? I would like to add more time and hour…
-
Future Depreciation pandas : FutureWarning when using get_timeseries with normalize=True
Hi team, When using the method get_timeseries with normalize=True, a waning is raised with the following message : FutureWarning: Could not cast to float64, falling back to object. This behavior is deprecated. In a future version, when a dtype is passed to 'DataFrame', either all columns will be cast to that dtype, or a…
-
Pause/resume and decreasing the frequency of updates coming from an ADS.
Hi, I have an ommConsumer that registers its interests and receives updates from the server. Sometimes the rate of updates is too high and I would like to either pause/resume or decrease the update rate. Is it possible at all? I am using Java and would be useful to see an example/code-snippet in case it would really be…
-
Requesting large data amounts in batches via RDP API
I am trying to download roughly 10 years of daily price data for 3000 firms with rdp.get_get_historical_price When trying it at once, the API times out. What are best practices for requesting data in batches and the combining the outputs to a single pandas dataframe? Currently I am trying to do it in batches by appending…
-
Why do I get Pandas ValueError: invalid literal for int() with base 10: 'undefined' when I try to...
... load a downloaded excel file from GOVSRCH into Python via read_excel? Pandas Version: 1.1.5
-
Python Pandas -remove rows based on given value in cell?
I have following script which removes rows in which date start with 202110 in column DATE OF OPERATION. I understand that space in the name of column is not allowed so script also replace space by _ and then after rows are removed it add back the space. For some reason I couldn't attach csv here so please see example…
-
How to change pandas data type?
How to change pandas data type? Is there a pandas function to type convert form 'pandas.core.series.Series' to 'pandas.core.frame.Pandas' ? Data example: numpy_data = np.array([[1, 2], [3, 4], [1, 1]]) df = pd.DataFrame(data=numpy_data, index=[1,2,3], columns=["column1", "column2"]) Here I get the pandas.core.frame.Pandas…
