-
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…
