I want to download the Bid-Ask Yield spread. But I am not sure which field I need to use. Below is my python code to download the bid, ask,mid yields. I hope you can help me to find an appropriate field for bid-ask spread. Currently using below fields = ['B_YLD_1', 'A_YLD_1', 'MID_YLD_1', 'YLDTOMAT'] fields_length =…
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…
Hi, Is there a possibility to connect via VB or python code directly to the Workspace excel API and retrieve information from it?
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 is it returning <NA>? This code worked fine 1 month ago import refinitiv.dataplatform.eikon as ek ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY') df_standard, err = ek.get_data( instruments = ['SBFG3.SA'], fields =…
using different ISIN code as input, to download if the company have this PN17 pdf file. which api shall i use to get the pdf file. and also before what credentials i need to provide and if so where do i get the credentials from?
I met a problem when I used the Python API to obtain data in the LSEG Workspace. For listed company, for example, TSLA.O (TESLA), I want to get the fields in the LSEG Workspace which can obtain the ratio of international/overseas revenue or non-local revenue to local revenue of listed companies. Since there are hundreds of…
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 =…
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:…
It looks like you're new here. Sign in or register to get started.
