-
Error 429 and AttributeError when downloading the data through APP key in python
Hi Dev team good morning. May I ask for your assistance. Error 429 and AttributeError import asyncio import tkinter import pandas as pd import lseg.data as ld from lseg.data.content import fundamental_and_reference bonds = pd.read_csv('isin_list.csv')['ISIN'].to_list() tkinter.Tk().withdraw() print('Enter your Refinitiv…
-
LSEG Data Library: retrieve date values from get_history function output in Matlab
Hi! I am using the LSEG Data Library for Python (function get_history) to retrieve market data. The function output (Python DataFrame "df") is then further processed in Matlab. I manage to get the field names and values (see below example: Close Price, Volume) applying the following commands:…
-
DSWS layout
hi, the default layout of 'get_data' mothod for a list of instruments with a set of data items in DSWS is not good. e.g below, if all three instruments have data it shows three columns but for some data items it only shows 2 as only 2 provides the data. is there a way to clean the layout? thanks cheers, Ginger
-
Saved in the codebook/kernel even after restarting the whole LSEG Workspace
Is there a way to use the variables that were saved in the codebook/kernel even after restarting the whole LSEG Workspace. So I can use them the next day/week without retrieving the data again?
-
the variables that were saved in the codebook/kernel even after restarting
Hi, Is there a way to use the variables that were saved in the codebook/kernel even after restarting the whole lseg workspace. So I can use them the next day/week without retrieving the data again?
-
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…
