-
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…
-
Export Query in advanced Search
To add Return on Investment (ROI) or Earnings Before Interest and Taxes (EBIT) in Advanced Search, follow these steps: 1. Open Advanced Search. 2. Select a universe (e.g., Equities). 3. In the Results panel, click "Add Additional Fields". 4. In the Data Item Library, select a category (e.g., Financials) and choose the…
-
Why does the LSEG Workspace “Company Tree Structure” Excel export fail for some companies?
I am using the “Company Tree Structure” feature within LSEG Workspace to export group hierarchy data into Excel. While the download works as expected for many companies, it consistently fails or gets stuck in a loading state for a subset of both public and private companies. This issue persists regardless of the account…
-
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…
-
Corrupted data retrieved from TR.TotalReturn
Hi, I have retrieved total return data with this script, and there are some rics that has wrong daili returns. For example BLNK.O almost the whole 2020 is wrong, theres a lot of consecutive days that the return is more than 6k, and other several consecutive days as -98 or 500. Could you check this please? Thanks for your…
