-
How to use symbol_conversion.Definition for a specific date?
I'm using the following to convert from ISIN to RIC: ld.open_session() response = symbol_conversion.Definition(symbols = ['TH8319010Z06'], from_symbol_type = symbol_conversion.SymbolTypes.ISIN, to_symbol_types = symbol_conversion.SymbolTypes.RIC, asset_class = symbol_conversion.AssetClass.EQUITIES, ).get_data() eikon_map =…
-
Convert Bonds Issued Amounts in EUR using exchange rate at Issue Date
Hi all, I would like to API request to retrieve a list of bonds, with the outstanding amounts converted to EUR based on the exchange rate as of the issue date. Currently, the GOVSRCH function in Workspace performs conversions using the exchange rate as of the previous close. Can you help me? Best Giacomo
-
Quesstion about RIC code of JGB
I cannnot take bid ask price of JGB by the code attached below. I would appreciate it if you could tell me the reason and solotions to correct this problem. I think this may happen because I cannot take appropriate RIC code of JGB. import lseg.data as ld from lseg.data.content import symbol_conversion ld.open_session()…
-
Question about getting bid ask of Isincodes by Codebook V2
I use the code below to get bid ask by codebook. My code is working but cannnot get the data whose isincode starts from JP. Could you tell me the reason if possible. import pandas as pd import lseg.data as ld from lseg.data.content import symbol_conversion ------------------------ 設定 ------------------------EXCEL_IN =…
-
RSI and Stochastics
Hi Team, I am looking to get python code to run in Code Book to get me historical RSI and Stochastic Values for currencies on a minute by minute basis for the last 2 years. Can you help on this please: Thanks, Leon
-
Is there a codebook for Workspace data?
I am looking for something I can download and reference as I work on M&A and Private Equity data I obtained from the platform.
-
i got a problem wir importing diffenrent libraries in codebook like "textblob" or "transformers". th
case# 14665399 Client facing the below issue . kindly check and assist i got a problem wir importing diffenrent libraries in codebook like "textblob" or "transformers". the error "UnboundLocalError: local variable 'module_or_package' referenced before assignment" is shown after trying to import one of the packages.Are…
-
I need to add a date field to the following code in Codebook
import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = [ 'IBIT.O', 'SPY', 'BND.O', 'FTLS.K', 'GLD', 'ETHA.O', 'PTLC.K', 'PFF.O', 'VNQ', 'SVOL.K' ], fields = [ 'TR.NETASSETVAL.date(SDate=2024-01-01,EDate=2025-04-11)', 'TR.NETASSETVAL(Frq=D,SDate=2024-01-01,EDate=2025-04-11)',…
-
Sentiment analysis on historical news for a portfolio
Dear all, I am an early-stage user of the API environment, please excuse me for apparently redundant questions. My aim is to gather management pay-related news from the last 365 days for every company in my portfolio (fewer than 550 RICs) at each fiscal year-end over the past 20 years, and perform sentiment analysis on…
-
How to Retrieve All Listed Companies by Exchange Country in CodeBook
Hi, I'm currently working with CodeBook and ran into a problem that I'd like to get some help with. Previously, I used the “Country of Exchange” filter in Screener to select all companies listed on a specific country’s exchange. I’m wondering how I can replicate the same filtering in CodeBook using code. Here’s the code…
-
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")',['…
