-
Why is the fperiod not properly aligned with the values?
I'm having problem when downloading financial income data. For this example in the code below, the "Financial Period Absolute" (fperiod) is not properly aligned with the true financial data. We can see that on "TR.F.OperProflnOpCASR | XEBT", there are 2 values on FY2024Q4, but it should be one value for FY2024Q4 and…
-
How to get RIC for a specific market using SEDOL in API
Using the API, I would like to return the RIC for a specific market given a SEDOL. For instance, if I look up BP6MXD8, it returns SHEL.L, but I am looking for SHELl.BS. rdp.get_data(['BP6MXD8','0989529','0144403','0540528','B10RZP7'], ["TR.ExchangeMarketIdCode",'TR.RICCode'])
-
Python 3 restarting (but never restarts)
Im having trouble to load any code now. the python on CODEBOOK is not initializing…
-
Im having trouble with missingquarter data for several American companies, including AAPL.
data retrieved with: df_standard, err = ek.get_data( instruments = ['AAPL.O'], fields = ['TR.F.IncomeStatement.fieldname','TR.F.IncomeStatement','TR.F.IncomeStatement.date','TR.F.IncomeStatement.FCC'], parameters = {'Scale': 6, 'SDate': 0, 'EDate': -30,'Period':'FQ0', 'FRQ':…
-
How to run a SCREENER formula in Excel to CODEBOOK?
What is wrong with this screening code? df, err = ek.get_data('SCREEN(U(IN(Equity(active,public))/UNV:Public/), IN(TR.InstrumentTypeCode,"ADR","BDR"), IN(TR.ExchangeMarketIdCode,"BVMF","XBSP")',['…
-
What is the longest history data for 1min frequency I can get using get_history()
Hello friends, I'm using the python code below to retrieve 1min historical data, and got error. data1 =ld.get_history( universe=["EUR=","JPY=","AUD=","CAD=","GBP=","CHF=","NZD="], fields=["BID", "ASK","MID_PRICE"], interval="1min", start="2020-01-01", end="2025-01-01" ) I guess it is because the time period is beyond the…
-
when I use the Peers function in codebook, it provides ~50 peers, which is much more than the 7 that
when I use the Peers function in codebook, it provides ~50 peers, which is much more than the 7 that you have said the peers function is supposed to identify. How do I limit this to the most relevant 7 peers? I am concerned that adding a number to the function may just select 7 out of the ~50 peers arbitrarily, rather than…
-
NACE code for Loans
Hi, I am trying to replicate in the codebook a Screener search for all the Loans in EU27+US in 2024 and retrieve the NACE code of the borrower to then aggregate the loan amount at that level. There should be some mistake in my formula, as I fail to retrieve any populated value for the fields 'Use of proceeds' and 'Total…
-
How to set the Period year = [2025,2026] to be dynamic in CODEBK?
how do i make a function like this to work? import refinitiv.data as rd rd.open_session() year = [2025,2026] df = rd.get_data( universe = ['CEAB3.SA'], fields = ['TR.NetProfitMean(Period=year1})', 'TR.NetProfitMean(Period=year2})'], parameters = { 'year1':year[0], 'year2':year[1] } ) display(df) the year list is dynamic.…
-
Waiting for more than 45 minutes for simple Python Codebook query but no results are produced
I am trying to run a simple Python query in Codebook (see attachment) but after waiting for more than 45 minutes no results are produced. This occurs frequently throughout the day and significantly impacts my work. What can be done to remedy this?
-
Historical series of Market Capitalization of market indices
Hello. Could I get a historical series of Market Capitalization of market indices (example: IBOVESPA ".BVSP"; NASDAQ 100 INDEX ".NDX") in the codebook?
-
Bond issuers income statement data download
Hello everyone, I am trying to download financial information regarding bond issuers, starting from a series of bond ISIN codes. The query I am using is the following: rd.get_data( universe = ISIN_list, fields = [ 'TR.RIC','TR.NACEClassification', "TR.DTSubjectName", "TR.FIIssuerName", 'TR.FiOrgID', "TR.F.TotRevenue",…
-
Python command discovery.convert_symbols fails for matured bonds
In Codebook, the Python commands: import refinitiv.data as dl dl.open_session() ISINs=['DE000A11QTD2'] RICs=dl.discovery.convert_symbols(ISINs).loc[:,'RIC'] produce an error when an ISIN of an expired bond (e.g. DE000A11QTD2) is specified. However, it works for not expired bonds. What can be done so that the command works…
-
Workspace Add Analysis>EMA display different numbers than pd.ewm using Python
Using the following snippet as in a former question [Is it possible to pull Exponential Moving Average data using the RD Library?](https://community.developers.refinitiv.com/discussion/112022/is-it-possible-to-pull-exponential-moving-average-data-using-the-rd-library/p1?tab=accepted) for `TSLA.O` will give an EMA endpoint…
-
Workspace Screener in Codebook returns error code 800
When running a screener in Python (Codebook), error code 800 is returned (see screenshot). What can be done to remedy this?
