Hi there, I'm trying to compute the P/L value of a portfolio. I would need the "total accrued amount" for a fixed income security over a specific period. For example, XS1700429480 (ISIN) has paid accrued interest of $0.00325 over the period of Apr 1 to May 11, 2021. Is there a way to fetch this number? The formula I'm…
Hi there, I'm trying to compute the P/L value of a portfolio. I would need the "total dividend paid amount" for a security over a specific period. For example, AAPL.O has paid dividends twice in 2021: $0.22/share and $0.205/share, so I will need the value "0.425" as an output. So far I could only get the values in an array…
Hello, I am wiriting my Master's thesis and I have not worked with Thomson Reuters before. I need a list of German Companies with historical data about the last four years. I need German Companies without Financial sector wich have a number of employees greather than 1,000. I also need the dept/equity index, revenue and…
Considering that the .COM API is not maintained anymore, which API should we use as a replacement, knowing that : * we develop with .NET language * we search the following data :* RIC * debt instruments (bonds, loans) with full related informations * historical data : yields, issuance information, credit rating information…
I need historical P/E on annual basis 1990-2020 for my master thesis. On Eikon.com i only find actual P/E and P/E from 26/4 to 11/5 2021:…
Hi, Is there a way to pull commodities tradeflow data using codebook?
Hello, Started a couple of hours ago, RSearch request times out. We always use 10 seconds as a timeout. This is the first time I see this kind of problem. Tried 2 minutes - no response. Trying 10 mins. Could you check if this is a known issue? Thanks
Hello, im trying to create a column in the Eikon monitor app, which will check for a higher high compared to an earlier time frame and return yes/no. I can compare the dailies, but how do I compare for other time references (e.g., monthly, weekly, 60 minutes, 15 minutes, etc)? thank you
Hey there, I am using the Formula Builder and want to download Ownership variables (“ TR.InvestorFullName;TR.InvestorAddrCity;TR.InvestorRegion;TR.InvestorType;TR.PctOfSharesOutHeld;TR.SharesHeld;TR.HoldingsDate"). However my request runs forever without a result. I used this formula:…
Hi there, I was wondering what the formula would be in the Excel function of Refinitiv Eikon to extract all the ESG ratings (also separate for each component) for the U.S. listed companies over the maximum period for each year including CIUSP codes. Is there anyone able to be helping me with the formula? Thanks in advance!
It looks like you're new here. Sign in or register to get started.