Hi, I am having a problem while trying to access to some data through excel. In the Excel file I am getting the error in the line of code: This script has been working for long time until today. The error that I get in excel is this one: While pasting the gateway URL into internet and put my credentials, I get this message…
Hi All, I want to pull closing prices for a RIN ."BAID" based on a column containing historical dates in excel. How could i go about doing this? So far I have only been able to pull the most recent closing price using: =@TR(".BAID","TR.CLOSEPRICE") I have a column with dates written as below and want to pull values…
Hi! I am trying to retrieve FX rates over time. I have used the formula =TR(B4,"CF_CLOSE",,E4) However, it does not allow me to select a specific date for which I want to retrieve the data for CHFDKK=R Is there a formula that allows me to get the FX rate on a specific date in time? Thank you
Hi. I am using the excel add-in to get all my data. Is there a way to get all RICs contained in a chain RIC using the add-in? For example I want to retrieve all RICs for NYMEX Ethylene CFR NE Asia (ICIS) Electronic Energy Futures The chain RIC is 0#NA2A:
I am interested in studying the performance of all the European companies that did an IPO between 2000 and 2020. I have downloaded the list of IPOs but now I don't know how to create a file which includes the historical price data for all the companies in the list. Any help would be really appreciated. Thank you.
Hi, Every month in early days I need to get this “Dirty Price” from the BNDC for the last business day from past month and for several bonds. Today I’m doing one by one in the BNDC, is there a way to access this price through the EIKON API or some way to automatize this job? Thanks in advance, Sylvio Campos Neto
Hello, Eikon C++ COM API, Dex2. Randomly, we receive "Unable to collect data for all requested fields" error as a response. Sometimes it's a legit error when no data exist for all requested RICs. But sometimes it's an incorrect answer. Today we get this error on the following request: Instruments:…
Hi, I am downloading data via Excel VBA. The Power, Gas, Carbon Research and Forecasts Download Manager template serves as a good learning material. I have found out, that I am accessing the data from Eikon database thanks to URLs. For example for 1003-PMT USNW Hydro ECOP STF BR the link is…
I'm using the Usage Example of Eikon .NET APIs (https://developers.refinitiv.com/content/dam/devportal/api-families/eikon/net-apis-for-use-in-custom-applications/downloads/usage-example-time-series-api.zip) to get our local RIC, but the result always missing the last hour of trading. Below is the code to get the last 350…
Hi all, I am having a stability issue in my excel when I use VBA to refresh Eikon formula. I often use one formula for 3000 companies at a time, such as '=TR($B$9:$B$3100,"TR.PriceClose","CH=Fd RH=IN",E8) For Price data, such as TR.PriceClose, using VBA to refresh it is very stable. But for financial statemant data, such…
It looks like you're new here. Sign in or register to get started.