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 =…
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…
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:…
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 =…
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')…
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…
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…
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…
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…
It looks like you're new here. Sign in or register to get started.
