-
Different execution result between codebook and python API
Good morning, I'm using the refintiv.data api to query some bond data. In the codebook I'm running rd.discovery.search( filter = f"RIC eq '458140BP4=RRPS'", select = "MaturityDate" ) this runs without issues and gives me the maturity date. However when i copy paste the same thing in my code editor, i get ValueError…
-
Obtain Closing Price of stock on set series of dates and return NULL if there is not data for that d
Hi All, How can I obtain the daily closing price for a stock for specified dates, returning NULL on any specific dates that do not have data? I'd like to obtain the daily price of several stocks over a set period of time. Ideally my output will look like this: Where a day that the latest closing price is not available…
-
How to Efficiently Retrieve TR.PrimaryInstrument for Delisted Equities?
Hello everyone, I'm currently working on a project where I retrieve RICs and PrimaryRICs for a set of ordinary shares from various global markets using the Refinitiv Research API (EQUITY_QUOTES) through codebook. Then I use the PrimaryRICs to gather fundamental data for these companies. However, I've encountered a problem…
-
Run multiple scripts in Codebook
Is there a way to run other scripts in Codebook. For example, with open('Other Code.py', 'r') as file: code = file.read() exec(code) I have six scripts I'd like to run inside of a new script.
-
ALL App keys shown as incorrect App keys
I'm a new user to Eikon data API. When I try to use the api keys I got from App Key generator. I get an error saying The output is the same irrespective of using Codebook or Jupyter, If I use my colleague's app key it works without issues
-
PORTS data pulled in API
I am trying to compile a list of all vessels that have left a list of ports. I have checked the 'PORTS' app. This works well but doesn't have origin port or commodity as columns in the result. I would like to pull this in Python too if that's easier. I have a list of 17 berths. I am trying to figure out how to generate a…
-
Client wanted to get the TREE Structure for Multiple Companies via Codebook
Already provided import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['HSBA.L'], fields = [ 'TR.RelatedOrgId', 'TR.RelatedOrgName', 'TR.RelatedOrgType' ] ) display(df) However its only for single companies, not really sure how to do this on Codebook then, appreciate your help in advance.
-
What are correct parameters to fetch historical data for provided fields?
Hi, I want to fetch the historical data for below fields. What is the correct way to fetch the historical data for a specified Date from history? Please find below the fields and code to replicate the results- fields =…
-
Code to print the list of tickers from an ETF called XBI
can you give me the code to print the list of tickers from an ETF called XBI
-
Mistake in the example
Hello everyone I noticed something in the examples in the CodeBook. Namely in the example "Discounted_Cash_Flow_Analsis". In the section "Discounted Cash Flow" the function .npv() from NumPy is used. According to the documentation, the discount rate does not have to be given as a percentage, but as a decimal number (0.05…
-
How to link screener list with codebook to search a specific keyword?
Hi I have created a list of US banks for my research purpose using Refinitiv Screener, however, I am required to create a column for 'digital scoring', is it possible to use Refinitiv CODEBOOK to generate this column by searching for specific keywords like 'online banking', 'financial technology', 'digital banking'..etc in…
-
Can you please assist on modifying the formula to get historical?
import refinitiv.data as rd from refinitiv.data.discovery import Chain import datetime from IPython.display import display, clear_output rd.open_session() dic_parametros = { 'SDate': '0', 'EDate': '-25', # 'Frq': 'D', 'Curn': 'BRL', # "CH": "calcdate", # "RH": "IN", "scale": "6" } rd.get_data( universe = 'CEEBB2=ANBI',…
-
BID ASK Jumps
Please find below an example of pulling BID ASK Data: fields = ["TR.CUSIP", "TR.CLOSEPRICE", "TR.BIDPRICE", "BID", "TR.ASKPRICE", "ASK", "NAVALUE"] fund_data = rd.get_history(universe="VOE", fields=fields, interval="1D", start='2006-10-01', end='2006-11-01') I am seeing huge jumps in the BID-ASK spread (I have observed…
-
Optimizing Eikon API Calls for Retrieving Fundamental Data
Hey everyone, I'm working on a project on a codebook workspace where I need to pull a lot of fundamental data(322 fields) for various companies using their RICs via the Refinitiv Eikon API. The problem I'm facing is that the process is taking way too long, and I'm frequently running into gateway timeouts (Error code 2504).…
-
“AttributeError: module 'refinitiv.dataplatform.content.search' has no attribute 'Definition'”
Error : response = search.Definition(view=asset_view, top=max, filter=filter_str, select=select_str).get_data(). It says that “AttributeError: module 'refinitiv.dataplatform.content.search' has no attribute 'Definition'” Code was based on Examples-> Commodities-> Shipping and Shipping assets and utilities shipping.ipynb.…
-
Can we pull up the consolidated RIC for Warrants using their CUSIP in API Codebook?
Hello team, I'm using Python API. I use the below query to retrieve Consolidated RIC for Equities by their CUSIP. I need to retrieve consolidated RIC for other security types (Warrants, Bonds, Options). When I tried to use the same query for Warrants it did not work. Looks like Warrants do not have "ExchangeType" field…
-
Use Autosuggest capabilities to resolve a list of companies with rd library
Hi guys, Hope you are doing well. With Codebook, I'm trying by using RD library to build a python script which will resolve a list of companies. Broadly speaking, the script will parse a list of company name and will return the corresponding RIC or ISIN or Parent ID Example: with the list below:…
-
Workspace codebook transfer results to Excel
Hi there - I am extremely new to this. Within the Workspace Codebook I was able to receive an output (see attached). How do I move these results into Excel for further analysis? Thank you for your help!
-
Download filings data via CODEBK
Client has access to CODEBK (and he uses that for accessing financial data). However, he does not to seem to have access to filings data via Codebook. This is strange, given that he does have access to filings data via Advanced Filing Search (ADVFIL). He does already have the code in CodeBook, but do not get any output…
-
Ho to get daily total returns
Hello everyone I am trying to get the daily total return for a stock. The code I am using is: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['NESN.S'], fields = ['TR.DAILYTOTALRETURN'], parameters = { 'SDate': '2023-12-31', 'EDate': '-1D', 'Frq': 'D', 'Curn': 'CHF' } ) display(df) This should…
-
API Pagination in Python Using Refinitiv Data API
Hello, I'm working on a Python project using the Refinitiv Data API to retrieve large sets of equity quote data. I need to fetch data in chunks of 10,000 records due to API limitations, but I'm struggling with implementing effective pagination to avoid overlapping data without missing any records. The API doesn't seem to…
-
How can I pull "Private Equity/VC" data from the SCREENER app using the Eikon API?
I would like to pull data from the SCREENER App on Private Equity/VC using the Eikon API. In WorkSpace I do this by opening the SCREENER app, setting "Universe" to "Private Equity/VC" and then setting any other filters I need. Based off this documentation of how to use the API to pull data from the SCREENER App, it appears…
-
Bond calculator - cash flow
How is it possible to create the "norm factor" and "residual amount usd" column in bond calculator cash flow section using Eikon API or codebook? If so, is it possible to have these columns for multiple bond ISINs?
-
rd.get_history and rd.get_data comparison
Greetings, I am in the process of developing an algorithm designed to extract specific dates and associated closing prices related to delistings, bankruptcies, or private transitions of publicly traded entities. Currently, I am encountering difficulties with the functionalities of rd.get_history and rd.get_data. Below, I…
-
Refinitiv.data proper fields names
Greetings, I am currently involved in a project aimed at retrieving the closing price for companies that have been delisted due to bankruptcy, specifically the day following their bankruptcy announcement. The primary methodology I employ involves checking whether 'TR.MnAHasBankruptcy' is true. If this condition is met, we…
-
"TR.PPBankruptcyFilingDate" data field.
Greetings, I am currently involved in a project that necessitates the retrieval of data pertinent to delistings. For this purpose, I am utilizing the 'TR.MnAHasBankruptcy' and 'TR.PPBankruptcyFilingDate' fields to ascertain whether a company has filed for bankruptcy. However, I have encountered an issue wherein the…
-
Is it possible to pull up a capital change event (Buyback, Stock Split, etc) in Python with the Even
We have a user who is trying to pull all the Buyback and Stock Split events for RIC 7203.T but it appears that the script is just outright pulling the data from 2000-latest for each field. For instance, a Buyback event with event ID <73016304666 > is returning values for TR.CATermsNewShares and TR.CATermsOldShares which…
-
CODEBOOK for Datastream
Hello Team, I have a client with a query as below. I am trying to use the CODEBOOK app (CODEBK) - a development environment for financial coders with a fully hosted cloud-based kernel for Python computations, closely integrated with Refinitiv. I am currently attempting to extract Scope 1 and Scope 2 emissions based on a…
-
How can I run this API endpoint on CodeBook?
How can I run this API endpoint on CodeBook? I'm trying to run the following function, but the output is the following problem "error 0 {'id': '62dc1e15-2ef8-4d91-b0bb-83e4739233d2/6...",how could this be converted to get currency forward data? Full script: response = ipa.curve.Curves().get_curve(…
-
When i pull the data into Python there is an extra row 2 labeled date. The first col should just be
-
How to retrieve Top Analysts for the security as well as Analyst ratings in codebook
I have created below formula import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['META.O'], fields = [ 'TR.TPEstValue.brokername', 'TR.OverallAnalystEstimateRating' ] ) display(df) Can the team confirm if this is the best way to get the data required? Kindly advise. Thanks.
-
Analyze the data using advanced algorithms.
Greeting everyone! I am currently engaged in the development of algorithms tailored for advanced data analysis and require your expert guidance on a couple of technical challenges I am encountering. Firstly, I am seeking a method to accurately extract the closing price on the day following the Bankruptcy Announcement,…
-
Company Delisting Study
Output.csv.zip Greetings! I am writing to seek your expertise in enhancing a sophisticated codebase designed to extract Reference Instrument Codes (RICs) from the three principal U.S. exchange markets: NASDAQ, NYSE, and NYSE American. This code efficiently retrieves both historical and current data, focusing on detailed…
-
NAs at the beginning of this query
I get a bunch of NAs at the beginning of this query rics=[SMCI.O,HRMS.PA,TREX.K, 0700.HK] data=ek.get_timeseries(rics,start_date='2017-01-01',fields='CLOSE',interval='daily') data.head() Tried to change the formula to below but same error rics=['GE','AAPL.O','.RUT','.MOVE','EUR=','XAU=','DE10YT=RR']…
-
starmine data available in excel but gives strange warning in code book
In Excel when asking for the starmine rank I don't need to supply any additional parameters. In Codebook it ask me to supply fields or functions I don't understand in the first place why I need to supply additional information and second it is not clear to me what I need to supply then. Please help me solve this! See the…
-
DSCREEN Close Price filed
Greetings, I am currently advancing my project focused on companies undergoing delisting. Utilizing the DSCREEN application, I have successfully compiled a comprehensive list of companies that have been delisted, along with detailed information regarding the transactions that led to their delisting. My next objective is to…
-
Research API, combine "Views" selectors.
Hello everyone! I'm currently progressing on a project focused on companies that have been delisted. For this project, I'm utilizing the Refinitiv Search API. I've successfully managed to extract data on US companies that were delisted, including the reasons for their delisting, which are currently limited to two…
-
Research API Metadata
Hi! I am currently utilizing the Refinitiv Research API for a project and have encountered difficulty in retrieving properties by using metadata for certain entities. As of now, I can successfully fetch properties for "GOV_CORP_INSTRUMENTS" and "Organisations." However, when attempting to access properties for other…
-
Search API filter
Hi everybody! I am currently utilizing the Search API for my project, which involves gathering data on delisted companies. I have successfully collected the required data, but I am now facing a challenge in filtering this dataset to include only companies based in the United States. Despite trying various values, I have…
-
PropertyNames for 'filter'
Hi! I was following a previous recommendation to utilize the Search API for my project. The integration has been successful, but I've encountered an obstacle with configuring the filters. Specifically, I am having difficulty identifying the appropriate PropertyNames to use within the "filter" parameter, as these were not…