-
Im having trouble the get aligned data with dates for some instruments
Im having trouble with the API. As you can see below, the resultant dataframe comes with null values on the last dates, and values on the first dates. The problem is that the "MATD3.SA" didnt exist before 2021. On excel, with same parameters, the dataframe comes alright, with null values up to 2014. So why is this…
-
Unable to resolve all requested fields in ['TR.SHARETYPE'].
To return to my previous problem, I realized that only part of the query worked. I can successfully extract the "GICS Sector" and the "GICS Industry Sector" from an ISIN using the fields "TR.GICSSector" and "TR.GICSIndustryGroup". However, I can’t extract the "Instrument Type" using the field you provided me:…
-
Pricing basis for Physical Commodities
I want to get FX broken dates calculator to hedge basis price contracts for commodities e.g. Cotton. Sample code as below: df = ld.get_history('JCI-CTN-ANHUI','TRDPRC_1',start='01-Jan-2025',end='26-Jun-2025') #This is spot price for China Anhui cotton. df2 =…
-
Why am I receiving "a 'dict' object has no attribute 'url' in my API code?
Client is receiving "a 'dict' object has no attribute 'url" error message when trying this code on his end: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = [ 'US0378331005', 'US02079K3059', 'GB00BH4HKS39', ], fields =…
-
How to get spot currency historical_data from Refinitiv Workspace
this is my code: def get_historical_data(rics: list, start_datetime: str, end_datetime: str): """ Retrieve historical pricing data for a given ticker and time range. Args: rics (list): The list of RICs (e.g., ['AAPL.O', 'GOOG.O']) start_datetime (str): Start datetime in ISO format (e.g., '2023-04-07T15:14:25.165')…
-
Enums and ms timestamp fields in Workspace Realtime API
Hi— we had been debugging the new lseg.data library realtime APIs on a system that had been running Eikon. When running eikon Eikon, fields with enums (like IMB_TYPE) and fields with timestamps (like IMB_TIM_MS and QUOTIM_MS) were all coming back as integers using the lseg.data streaming APIs, for example using the…
-
ld.open_session() failling with workspace open
Hi i am working in vscode and when simply running this: import lseg.data as ld ld.open_session() I get this error: An error occurred while requesting URL('http://localhost:9005/api/status').ReadTimeout('timed out')An error occurred while requesting URL('http://localhost:9000/api/status').ReadTimeout('timed out')An error…
-
Accessing Upcoming Sovereign Rating Review Calendar via Eikon API
Hello, I would like to access upcoming sovereign credit rating review dates for certain countries (e.g., "Germany – Fitch – Review scheduled for July 11, 2025") via the Eikon Data API (refinitiv.dataplatform.eikon), if possible. Could you help me with it? Thank you for your support. Best regards,
-
Error in the codebook: ScopeError: Insufficient scope
for key=/data/ownership/v1/views/fund/holdings, method=GET. Required scopes: {'trapi.data.ownership.adv'} OR {'trapi.demo-access'} Available scopes: {'trapi.alerts.publication.crud', 'trapi.frtb.sentimarization', 'trapi.search.metadata.read', 'trapi.graphql.subscriber.access', 'trapi.user-framework.recently-used.crud',…
-
Eikon messenger API
I am currently working on a project that requires extracting discussions from different group chats in Eikon Messenger using Python. To proceed, I need the following information and credentials: Eikon Data API AppKey Messenger Bot API credentials (bot_username, bot_password, messenger_appkey) Additionally, I would…
-
rate limit when requesting history via the LSEG Data Library
I gather that when requesting historical pricing, every stock is being requested individually, even when requesting one date, is that correct? E.g. if I just ask for Russell 3000 stocks since the start of June, I'm making 3,000 separate requests? That at least seems to be what is happening from debug logs. I ask partly…
-
Daily extraction large scale
I have a script that extracts daily time series data and static data for the individual constituents of the ETF IEAC.L over a 10-year period. Currently, I’m fetching the data day by day for each of roughly 3500 constituents, which makes the process very slow — a test for a single day already took about 1 hour. So I'm…
-
How to Optimize Large-Scale Daily Time Series Extraction
I have a script that extracts daily time series data and static data for the individual constituents of the ETF IEAC.L over a 10-year period. Currently, I’m fetching the data day by day for each of roughly 4000 constituents, which makes the process very slow — a test for a single day already took about 1 hour. My current…
-
Get the history changes of RIC
Hello! I am using python library lseg-data. My question is how can I get the history changes of RICs and its previous names, so that my prices are correct? For example Facebook was FB.O but after rebranding it became META.O, I used symbology but did not get the expected result.
-
How can I open a new python project
How can I open a new python project Unexpected error while saving file: Examples/07. Portfolio Analytics/untitled.py [Errno 30] Read-only file system: '/home/jovyan/Examples/07. Portfolio Analytics/untitled.py When I try to open a new python project, this prompt message shows up Raised on behalf of external client