-
Retrieving Stock Split Data using the Eikon Data API (get_data)
I am using the Eikon Data API (Python) to retrieve various time series data (prices, volume, etc.) using the get_data function. Did anyone already successfully obtain explicit information in stock splits (effective date, ratio) using that function? if yes, which fieldnames were used?
-
Failing to pull some data from API, every time a different dataframe returned is empty
Hi, Am trying to pull some data from API using following code ##################### import eikon as ek df_NWE_Ethylene_Spot = ek.get_timeseries([ 'PHAJD00' ],fields='CLOSE' , start_date='2015-01-01',interval='daily') df_NWE_Ethylene_Spot = df_NWE_Ethylene_Spot.reset_index() df_NWE_Ethylene_Spot =…
-
Circumventing Search API request limits
Hi, I am working on a larger project where I am integrating job listings with firm-level (parent company data). I need to link firm names with their parent companies (to get the publicly listed entities for subsidiaries) which I am doing via the Search API in LSEG Workspace. The entire dataset contains about 200,000 firms…
-
How to get Bloomber ticker and address of any fund?
What's the Eikon formula (TR.) to get Bloomber ticker/id and address of any fund?
-
Pricing a bond with a modified yield curve
Hello, I have downloaded the yield curve of a bond benchmark using the following import refinitiv.data.eikon as ek curve = ek.get_data('0#ITXZ=R',['MATUR_DATE','PRIMACT_1']) Then I modify the yield curve by applying a parallel shift of 25bp via: curve['Shifted_Rate'] = curve['PRIMACT_1ì] + 0.25 Now I want to reprice a bond…
-
[REST API] Vessel Physical Assets
Hello all, I am trying to select new columns for the new data available for the vessels voyages: Last trade flow information: Charterer, Commodity, Cargo Size, Rate, Load Port, Load Date, Discharge Port, Discharge Data, Status, Previous Port and Previous Port Duration. However, when we tried to insert on the select part…
-
Error code 403 - a padding to disable MSIE and Chrome friendly error page
Hi, I’m currently having a problem retrieving data via Python using the EIKON API. I’m getting the following error message when running the Python script: eikon.eikonError.EikonError: Error code 403 | Client Error: <html> <head><title>403 Forbidden</title></head> <body> <center><h1>403 Forbidden</h1></center> </body>…
-
Unable to run the code provided in Github by Refinitiv.
The file can be found here : https://github.com/LSEG-API-Samples/Article.EikonAPI.Python.GatheringAggregatedESGDataOnCompanies/blob/master/README.md The error I am getting is: ESG UN SDG part 2_CB_007.ipynb
-
Unable to obtain latest information on marketcap.
Hello Support Team, Until recently, my nightly batch job was able to retrieve the same-day market capitalization. (Command example) test_df, e = ek.get_data('9984.T', ['TR.IssueMarketCap.date', 'TR.IssueMarketCap', 'DSPLY_NAME']) For example, when I ran this in the evening Japan time, it used to return the market cap for…
-
I'm using the screener from Python. Is there a way to filter for instruments where TR.TRBCEconomicSe
import eikon as ek import pandas as pd Set your App Keyek.set_app_key("...") expr = ( 'SCREEN(' 'U(IN(Equity(active,public,primary))) AND TR.IsPrimaryQuote = 1 AND TR.IsDelistedQuote = false, IN(TR.TRBCEconomicSector,""), ' 'TOP(TR.CompanyMarketCap, 25, nnumber), ' 'CURN=USD' ')' ) fields = [ "TR.OrganizationID",…
