-
Eikon Reinitive Com Addin Powerpoint And Excel
I was hoping someone could provide Com API Documentation for the Refinitiv Objects Hosted in Excel/Powerpoint. I have found com api documentation on this site - however it does not cover the scenarios I need - see below. We have some ds charts in a power point presentation and a table in an Excel workboook. The process to…
-
Unable to get Daily Palladium data as of 14 Jul 2021
Hi - as of yesterday, I am unable to get Palladium Time series data using the Time Series API. The following code has worked perfectly for many years, but as of yesterday, throws an error 'NoSuchInterval' thrown in the 'StatusUpdate' method; (It works perfectly for every other commodity and worked for PAU1 up until 14 Jul…
-
How to start each Eikon Excel spreadsheet in separate incidence from batch ?
We have been using the following command line to start up each Excel. "C:\Program Files (x86)\Thomson Reuters\Eikon\Eikon.exe" -officeexcel -a "D:\filename" Since Eikon upgrade to 4.53, all spreadsheet uses the same Excel incidence (same parent Excel task in Task Manager, with each spreadsheet as child) The switch “-a”, is…
-
Downloading ownership data for several firms on Eikon
Good morning Sirs, I would like to receive your help in order to download ownership data for a series of european listed firms. I am using screener but the data on the number of shareholders are not available for the majority of firms. However, as I check a single firm and I view its ownership report, the number of…
-
VBA / Refresh Eikon Formulas
Hello, I am using a VBA in file A to update prices. Those prices are found with Reuters formulas located in file B. I open the file B as read only, refresh the formulas with the below instructions, but nothing happens and the prices dont get updated. It seems that if I open file B manually and refresh, the prices update…
-
How to get all RICS associated for each ISIN via API
For example I have this ISIN: IE00BF92LR56 I would like to know all the RICS which are having the same ISIN. For example if I type this ISIN in the search bar in the UI, I can see: 5HED.L, 5HED.DE, 5HED.F, 5HEP.L, LP68492428, 5HED.D ....e.t.c I'd like return via API the list of these RICs for each ISIN what I have
-
How to get Total Accrued Interest Amount over a period
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…
-
How to get Gross Dividend Amount over a period in a Single value
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…
-
How to create a list of German Companies with historical data?
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…
-
EIKON COM API going legacy, which .net API would be equivalent ?
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…
