-
How to get bond mutual fund's duration in CODEBK
I am looking at this trust case: 14416458 14416458 | Case | Salesforce And the specialist directed the client to the attached coding script. The file is in .ipynb extension and I couldn't attach here, so I have changed the format to .txt file. Used Portfolio ID 35014080, and at this code below, I run into an error:…
-
Is it possible to use cell referencing on Python / codebook?
hello, Is it possible to use cell referencing using Python / Codebook? Please see attached Excel file for reference In addition, how can we display the dates? In added the parameter 'RH': 'Date' but still did not display the dates import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['AAPL.O'], fields…
-
Using companys' proxy with lseg-data package
Hi ! In order to use the lseg-data Python package, I've fiddled in the GitHub standard package to try and open a session. However I am getting an error that obviously says that I need proxy authentication to actually test it properly (the error is quite clear). I am setting the proxy settings in pip.ini for example if I…
-
how to use python and lseg-data module to get out all storyid and story text
Case: 14967300 Hi, I'm trying to figure out how to use python and lseg-data module to get out all storyid and story text that reference a particular stock. Can you help on this please? Above is from client, news team referred me here
-
I started having this issue recently
I started having this issue recently, and I do not know why. price_df = ld.get_data( universe=ric_list, fields=['TR.PriceClose.Date', 'TR.PriceClose'], parameters={ 'SDate': '2010-01-01', 'EDate': '2025-01-01', } ) LDError: 'dict' object has no attribute 'url'. I am also having trouble to start a new session (it normally…
-
How to retrieve Historical Data for Bid-Ask Yield and Bid-Ask Spread forBonds
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 =…
-
Posting on behalf of client - Different result when using 'get_data' and 'get_history' when pulling
Query: Our system gives the API the list of company RICs from the TR-Europe index and asks for the 'TR.ISOriginalAnnouncementDate'. And that works, e.g. for 'AAF.L', I get a date of '2025-05-08'. But then when I ask for the whole income-statement/balance-sheet/cash-flow data dump for that company, the most recent data…
-
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…
-
VB/PYTHON CONNECTION TO wORKSPACE
Hi, Is there a possibility to connect via VB or python code directly to the Workspace excel API and retrieve information from it?
-
The refinitiv.dataplatform.eikon is returning no value now. 1 month ago it was
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 =…
-
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,
-
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')…
