Stack Overflow
Stack Overflow

Questions tagged [thomson-reuters-eikon]

A service providing financial news and market data.

20 questions
5
votes
2 answers

R connect to Thomson Reuters Eikon

I search through the Web and did not find out a package connecting to Thomson Reuters Eikon. It's a financial datasource, more or less similar to Bloomberg. Bloomberg is supported through R with this package:…
Colonel Beauvel
  • 30,423
  • 11
  • 47
  • 87
2
votes
1 answer

pywintypes.error: (5, 'SetFileSecurity', 'Access denied') when trying to run jupyter notebook Kernel via Anaconda prompt

Jupyter Notebook is running and I can open a python3 notebook. But I receive this kernel error. It seems to be a permission issue. But im not sure where to start looking. Any tips how to proceed? Traceback (most recent call last): File…
user12297342
  • 23
  • 4
2
votes
1 answer

Merge CRSP and Eikon through the Eikon api

I am trying to merge CRSP and IBES through the Eikon API. I have extracted CUSIP codes from CRSP and wants to convert those to RIC codes in order to extract analyst estimates. When I do the following in python it returns an error (Payload Too…
Chris
  • 433
  • 4
  • 17
1
vote
1 answer

How to fix .Evaluate rounding result

I am using Evaluate in order to execute this formula : x = Application.Evaluate("AdInterp(" & cells(2,"C").value & "," & "'" & ThisWorkbook.Worksheets("Fonction DCF ").Range("U8:U31").Parent.Name & "'!" & ThisWorkbook.Worksheets("Fonction DCF…
TourEiffel
  • 4,034
  • 2
  • 16
  • 45
1
vote
0 answers

Thomson Reuters EIKON -> Refresh Workbook how to call

I would like to know if there was a way refresh EIKON data thanks to VBA : EIKON- > Refresh Workbook NOTE Application.Calculate isn't the answer excepted. https://stackoverflow.com/questions/61814900/bloomberg-refresh-workbook-how-to-call(Quite…
TourEiffel
  • 4,034
  • 2
  • 16
  • 45
1
vote
2 answers

How to retrieve all associated company RICs for a specified exchange RIC using the Refinitiv Eikon API?

Using the Refinitiv (formerly known as Thomson Reuters ) Eikon Data API, does anyone know how to quickly return all associated company RICs for exchanges such as Oslo Stock Exchange? The RIC for Oslo Stock Exchange seems to be .OSEBX And…
vestland
  • 55,229
  • 37
  • 187
  • 305
1
vote
1 answer

Using VBA to execute COM add-in specific formula

I am trying to use a VBA macro to execute formulas in an excel sheet, which were added by an add-in. Specifically, the add-in is Thomson Reuter's Eikon and it provides functions starting with "=TR(....)". My add-in works as follows: It puts together…
Andreas K
  • 63
  • 6
0
votes
0 answers

What's the simplest way to execute scripts on two computers on the same network?

I have two PCs in my office, one with Reuters Eikon and one with Bloomberg. I have a program that use both of their APIs for downloading financial data (Bloomberg has some additional fields I need and Eikon gives unlimited data), but I've been…
lobuteing
  • 21
  • 2
0
votes
1 answer

R retreive information from Eikon cloud

I am trying to get data from Eikon Elektron cloud platform. I ran following codes from https://github.com/Refinitiv/websocket-api/blob/master/Applications/Examples/R/market_price_authentication.R: library(curl) > content = paste("grant_type=",…
John Mayer
  • 103
  • 7
0
votes
1 answer

Thomson Reuters EIKON is not updating/calculating with my VBA macro. What line of code would be able to help mine below?

I have gotten this code below, it has worked in excel and I have had someone go through it to ensure it works but just not enough time for EIKON to calculate all the values (stocks) that are in A270:A371. This program is suppose to enter values from…
AND AND AND
  • 3
  • 4
0
votes
0 answers

Reuters Eikon/Datastream - obtain issue date of structured products

I want to download the isse date (or the date were the first price was set up) of 1,000 bonus certificates of different issuers. To do so, I converted Wertpapierkennummern (WKN, identifier at German exchanges) into RICs. With those RICs I could…
StableSong
  • 79
  • 11
0
votes
1 answer

How to make Thomson Reuters datastream requests in R via RDatastream::ds? Possible miss-specification of 'user' argument

Note: This problem can only be replicated if one has a Thomson Reuters Datastream login I am attempting to request data from Thomson Reuters Datastream using RDatastream::ds but cannot successfully request data. It seems that the problem has got to…
Eshan
  • 43
  • 1
  • 9
0
votes
1 answer

How to add a new column to multiple pandas dataframes based on a condition?

I have 17 data frames to which I wish to add a new column using for loop based on certain conditions. Any suggestions on how this can be done? I have a list called custom_region = [] and 17 dataframes again stored in a list called CGdfs. CGdfs =…
user3021495
  • 97
  • 10
0
votes
2 answers

I am trying to convert an object type column to float. Not working

TSRdfr["Return"] = pd.to_numeric(TSRdfr.Return, errors='coerce') This is not converting the data type of Return from Object to float64. I tried removing errors ='coerce' to see what's happening. I am getting an error saying: Unable to parse NaN…
user3021495
  • 97
  • 10
0
votes
0 answers

Implementing a Time-Out function in VBA in case code gets stuck

I'm currently using VBA to automate pulling of large data-sets. However, it often happens that either the sub simply gets stuck and does not update any more/connection breaks (application is still responsive) or the application becomes totally…
rajomato
  • 1,167
  • 2
  • 10
  • 25
1
2