So I'm trying to get descriptive historical data of CEOs of listed companies hopefully. I'm imagining a panel between 2007-2024 (or last year available) of those companies, in which I have a column of year, another one for the fullname of the CEO in charge during that year, and several other columns with: 1. Age 2.…
We use this query to get RICs: res=search.Definition( view = search.Views.EQUITY_QUOTES, filter = "AssetState ne 'DC' and RIC eq '*.MX' and ExchangeCode eq 'MEX'", select = 'RIC', order_by = 'RIC asc', top = 10000 ).get_data() It works fine, but the result contains more than 1000 RICs that look like GFN_tcR001.MX,…
I am trying to pull some reference data using refinitiv.data via python code but getting Errors: ValueError: Session is not opened. Can't send any request. Can you please help. Code: import refinitiv.data as rd from refinitiv.data.content import fundamental_and_reference platform_session = rd.session.platform.Definition(…
It seems like I found another bug in get_history(). This is the query for ticks for some time range. The problem is - the more RICs I provide as 'universe' parameter, the more missing ticks are in the response. 2 RICs in the query. All ticks are present. The first tick for ALSEA has Volume = 2675. 4 RICs in the query.…
import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = [ 'IBIT.O', 'SPY', 'BND.O', 'FTLS.K', 'GLD', 'ETHA.O', 'PTLC.K', 'PFF.O', 'VNQ', 'SVOL.K' ], fields = [ 'TR.NETASSETVAL.date(SDate=2024-01-01,EDate=2025-04-11)', 'TR.NETASSETVAL(Frq=D,SDate=2024-01-01,EDate=2025-04-11)',…
I am using the ‘get_history’ function from the lseg.data library in Python to fetch data. Is there any way for me to also retrieve the update time for each data entry along with the data when using ‘get_history’? Below did not work: ``` python with ld.open_session() as session:…
Hello, I'm new to the lseg data library. I'm trying to retrieve information with get_history() but have a hard time finding all possible field values. When I search for input CF_CLOSE which can be found for RIC: "0#.SPX" in the data item browser functionality I get error. When I make query for "TR.PE" field which is not in…
If I run desktop_session = ld.open_session('desktop.workspace') with incorrect key or when LSEG Workspace is down, I see that: desktop_session.open_state == "Closed" How can I get the error code and message of why it couldn't open the session? I can see this data is in the log file. Can I get it from the code?
When I do something that involves timestamps, like : The last line prints this warning: LSEG-data.venv\Lib\site-packages\lseg\data_tools_dataframe.py:177:FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False)…
Client has a list of ISINs in an excel file and would like to get the Bond Rating on Issue Date of each bond. Each bond has different Issue Dates so we have an excel formula for each individual bond as: =@RDP.Data($A3,"TR.GR.RatingDate;TR.GR.RatingSourceDescription;TR.GR.Rating","Frq=NA SDate=#1…
It looks like you're new here. Sign in or register to get started.