-
Accessing Equity Deals from DSCREEN
I'm able to pull in M&A transactions from DSCREEN using the below API call: df, err = ek.get_data('SCREEN(U(IN(DEALS)), BETWEEN(TR.MnAAnnDate,19991031,20001031), CURN=USD)', fields=['TR.MnASDCDealNumber', 'TR.MnAAnnDate', 'TR.MnARankDate', 'TR.MnARankValueIncNetDebt(Curn=USD,Scale=6)', 'TR.MnATarget,TR.MnATargetPermId',…
-
How to get only recent few days data?
Hi am using the python API to query recent data with ek.get_data function. Using the following method to get RIC data, it takes a lot of time and processing to obtain and write in to VBA. So, are there any ways to setup the get_data time for few days?…
-
Retrieve Equity Index Info via fuzzy search on RDP
Hi Team, Hi Nick nick.zincone is there any reason why the below query gives results on Advanced Search Tool of EIKON, but not in RDP? Also, how can I get the constituents (and weights thereof) of whatever Equity Index that comes out of the query below? import refinitiv.dataplatform as rdp rd.open_session() sFilter = "(…
-
How can i download Tobins q ?
I want to do a esg performance analye and i want to measure the performance with tobins q, but i cant find it by refinitiv eikon
-
Where can i find the date of Forward price?
Hi, I am struggling with finding dates of Forward Price in Eikon. i want a list of the name of Forward price month. eg) Nov, Dec, Jan ... please kindly let me know ;)
-
monthly data is wrong
on 'Price History' page with this RIC named 'CMZN0' I searched with the interval as 'Daily' and 'Monthly' Base on Daily data below, the average of Oct-2023 has to be '2449.20' but in the other picture, It provides 2432.50 for Oct-2023. how to get precise 'monthly data'?
-
DSCREEN Query API Error
Getting errors trying to pull in deal data, any idea why?
-
How to convert the ticker to RIC and then retrieve the market cap?
Hi, I encountered a problem as mentioned in the title. Currently, I have two ways: 1. rdp.convert_symbols(), where rdp is refinitiv.dataplatform 2. ek.symbology(). Take ['AAPL' , 'MSFT'] as an example. I found method 1 always requires a login and requires to open a session. Is that possible to avoid this issue. I mean only…
-
Python - querying Company Name, Exchange and RIC using PermID
I have a list of PermID's in a dataframe for a large number of companies. I'd like to enrich this list with Company Name, Country (i.e. United Kingdom), RIC, ticker, Exchange its listed on (i.e. FTSE), business summary etc etc. I can find plenty of articles about using various methods of using company name, but not the…
-
Get the issuer(or parent)'s RIC from the Bond
Good day experts, I'm having a bunch of bonds that need to dig out the issuer's RICs (or the parent and nearest ancestor of the issuer that has the RIC), e.g., XS1732152589 XS1861178322 XS2051121387 XS2099768207 I tried to use the ticker field, but looks like the tickers are not the NYSE standard, no I'm stuck there. Some…