-
how to achieve USUM1P=ECI data
how to achieve USUM1P=ECI series data, with prelim publish data and prelim publish date. our economic data's logic is blur, user want to test market reaction when economic data publishes. But either cannot get the Latest data (for example, the latest data is of 13th September with no data), or cannot get the last publish…
-
how to achieve USUM1P=ECI data
As our economic data's logic is blur, I cannot find out via which Ric i could get USUM1P=ECI 's latest published data. the Ric CF_Last not work. And eikon.get_data('USUM1P=ECI', ['ECI_ACT_DT', 'ECON_ACT', 'TR.IndicatorLastObservationDate']) not work either
-
how to get Cross Economic Monitor data using Refinitiv Data API
is it possible to directly get the economic monitor data using APIs instead of manually download as excel?
-
Issues downloading Economic Indicator history and even fields
Hi, i've got an issue downloading historic data for economic indicators. my code is this: df = rd.get_history( universe=['aUSSPDIVY'], interval="monthly", start="1924-03-01" ) print(df) aUSSPDIVY VALUE Date 2022-05-31 1.567599 2022-06-30 1.641982 2022-07-31 1.64768 2022-08-31 1.560287 2022-09-30 1.69635 2022-10-31 1.767346…
-
Economic Monitor data using API
Hi is there any possible way that I can pull the data from the economic monitor using eikon API? Just all the data that is going to be released today. Old methods mentioned in the forum have stopped working.
-
How can I fix this error?
All, I have a problem I dont understand how to pull time series data using the refinitiv API. Does anyone have any idea how to do this? I am after macro data, instead of equity and FX prices, which seem to be in all the online examples. Many thanks Alex
-
Economic indicators from ek.get_data ek.get_timeseries
I am trying to pull historical economic indicator with ek.get_data. While I was able to obtain the time series with ek.get_timeseries, the date returned was in the period which the indicator was responsible for (ie If I'm looking at the CPI released on Oct 12 2023, the data reported was responsible for 2023-09-30. I saw a…
-
Data download structure with Eikon's Build Formula VS Datastream in Excel
I would like to ask the following question. I am downloading data for the last 10 years for all companies that have ESG data. Using Eikon's "Build Formula" function, I have been able to download the ESG data and part of the economic-financial data. This download shows me the data as shown in the first image. I would like…
-
Do you know a RIC for "Net International Investment Position % GDP"?
I need the economic data NIIP % GDP for several countries. Do you know the RIC for it or a possible alternative?
-
Is there an API for get data tables from Ric Search?
Is there an API, library or any function that can be used for get data tables, especially for economic indicators data from Ric Search Tool https://developers.refinitiv.com/en/tools-catalog/ric-search# in Python? If it is, can you give an example code?
-
How do I subscribe all Economic Indicators (=ECI) in /streaming/pricing/v1/ websocket?
Hi. I'm trying to make an Economic calendar using RKD Street Event - Economic Headlines and Streaming API from RDP. But here are some questions. 1. Is it possible to subscribe to the whole Economic Indicators? This means subscribing to every indicator with postfix "=ECI". 2. Is there a way to match the upcoming Economic…
-
Using Thomson Reuters SDK to get all Economic Releases for date range
Hi, How can I get all economic releases, all fields, for a specific date range, using the TR Desktop SDK? thx
-
Database Economic Variables
Hi, I am trying to build a database to then export into excel with economic variables of different countries. I have certain tickers in an excel file in column A, for simplicity, let's assume these: aTWWOGDPR, aCNWOGDPR, aJPWOGDPR. I would like to create a database where I extract the values in Column A, Country in column…
-
How to clean the output of data
Hello, I have the code below. import DatastreamPy as dsws import pandas as pd # set up connection def connection_DSWS(): DSWS_username = open("DSWSUsername.txt","r") DSWS_password = open("DSWSPassword.txt","r") ds = dsws.Datastream(username = str(DSWS_username.read()), password = str(DSWS_password.read()))…
-
Historical and scheduled dates and time of an economic event per Eikon API via Python
I would like to get historical and scheduled dates and time of an economic event per Eikon API via Python. Could you pls advise how to do it? I try like this: fields = ['TR.IndicatorName','TR.IndicatorType','TR.IndicatorSource' , 'GN_TXT16_3', #GMT Date 'VALUE_TS1', #Time 'CTBTR_1LL', #Period 'GN_TXT16_4', #Actual…
-
Daily data being retrieved despite using a quarterly frequency
Hi Team, I have a client who is new to DSWS. He is using the below request and wants just one datapoint for each month. Instead he is retrieving the data at a daily frequency (see code and output below). This is economics data (GDP) which is published quarterly. I have run the same request but I get the data back quarterly…
-
How can I retrieve a RIC like "aUS3M" with Websocket API?
Hi I'm trying to retrieve economic indicator using Websocket API on RTO (using Python) which is working fine for RICs like "USJOB=ECI", but unfortunately not to retrieve RICs like "aUS3M/A". For the latter I get the error message "The record could not be found". The RIC nevertheless can be found in EIKON. How could I get…
-
how can i get exact time data field of economic indicator??
since i have the log below at 2022/08/16 23:57:25.026 (UTC) 2022/08/16 23:57:25.026 ERROR --- [economicIndicatorExecutor3] a.w.d.c.s.EconomicIndicatorService : ric : JPTBL2=ECI, f : FieldEntryDto(ric=JPTBL2=ECI, nbRic=JPTBL2=ECI, fieldMap={SF_NAME=LALERT, CTB_2A_1=23:57:24.913, GN_TXT16_3=16Aug, GN_TXT16_4=-1436.8,…
-
Excel add-in timeseries function not working for economic data
Hi everyone, The Timeseries excel function is suddenly not working anymore for economic data. It was working a few weeks ago. Has somebody experienced the same issue or maybe has a solution for it? Thanks a lot
-
Retrieve Historical Economic Data With Release Date Python API
Hi, I'm trying to replicate the following table using Eikon Python API: When I download it, in addition to reference point time series (first column above), I also get a worksheet with First Release Data (second column): It is very important when performing backtests to avoid look-ahead bias, which is almost always the…
-
Summary of revisions of sell side analysts' and economists' forecasts
I am instructed to post a following question here by Helpdesk. Hope someone can take care of it. I am looking for an efficient way of checking the latest revisions of (1) sell side analysts’ earnings estimates of individual company and (2) economists’ forecasts of macroeconomic variables (such as GDP QoQ). For (1),…
-
Is there a Python function that tests for stationarity for any data-array for several test-statistic
I'd like to perform tests for stationarity for any data-array for several test-statistics; do you have a Python function for that?
-
Hi! I have been trying to pull data on economic indicators directly via the Excel Formula Builder wi
I was able to pull data of monthly German bond yields using the Formula Builder in Excel via the RIC DE10YT=RR and selecting "Data Items: Time Series". When trying to do the same with e.g. unemployment rate of Germany (aDECUNPQ/A), the "Category" and "Fields" boxes remain empty and, as a consequence, I do not receive any…
-
What other options are there please with the Enterprise APIs to retrieve the last published Month an
What other options are there please with the Enterprise APIs to retrieve the last published Month and value for the following economic indicators : Economic Indicators (<aFRCPIXT> <aXZHICPXTUR> <aITCPI> )
-
Is there a way to get Government Debt Auctions data in the Eikon Data API?
Hi all, Is there a way to retrieve Government Debt Auctions data from the Economic Monitor app into the Eikon Data API? I've provided a screenshot:
-
What would be the most efficient way to retrieve multiple historical economic indicators f.e. inflat
What would be the most efficient way to retrieve multiple historical economic indicators f.e. inflation and gdp for multiple countries through Eikon Python API?
-
how to get first release economic data
HI all, Looking into your documentation, I've seen it is possible to retrieve economic point in time data. For example, Using ds.get_data(tickers='CNCONPRCF(DREL1)', fields=['(X)'], start='-2Y', end='0D', freq='M') it is possible to download the first release data for the Canada CPI. I was wondering if it could be possible…
-
How to retrieve the same list of indicators that are available in Economic Monitor with python?
Good morning! I'm building a script in python that listen to events using the get_streaming functionality, and for that I need to know the list of RICs to subscribe to. I already tried some chains, but could'nt find any that gives me the same list of instruments that the EM app provides. Is that a way that I can retrieve…
-
RIC ECI example and code phrase
hi, where i can find example for some RIC ECI events, and source code to phrase the message in cpp, for example USNFAR=ECI
-
I would like to have the GDP growth Y/Y expectation for the year end for several countries
I tried with ek.get_timeseries('aITWOGDPR',start_date='2020-12-31',end_date='2020-12-31',interval='yearly') and it worked for a while but then I tried again and I got this message 'EikonError: Error code -1 | aITWOGDPR: TimeSeries request failed |'. What does this error mean? Do I have just to wait Reuters fix the problem?
-
Low Latency API C#
Morning, Could you tell me what API I can use for low latency access to live economic releases and where I don't need to have my reuters open. I am developing in C#.
-
Getting Economic releases via API
Hi, I have the api up and running for quotes, I would like to get Live economic releases, can some one help me with this. This is an example of what I am looking to get:
-
Time series of economic events using Python API
I would like to retrieve a time series of economic events using Python. The following works for getting the most recent values. fields= ['TR.IndicatorName', 'TR.IndicatorType', 'TR.IndicatorSource', "ACT_STA_DT","ACT_END_DT","ECI_ACT_DT","ACT_VAL_NS","RELEVANCE","RTR_POLL",…
-
Data from economic monitor
I am looking to set up an API for a way to pull in the data from the economic monitor when it is released. Stuff like economic releases and commodity figures so that I can get quicker access to them and be able to transfer them to a more suitable display, just not sure where to begin with the API, any help would be…
-
Is there a way to obtain the hour of publication of an economic indicator
I would like to know if theres a way to obtain the exact date and time an economic indicator was published .. like COCPI=ECI, COPCPIY=ECI, COCBIR=ECI
-
Is it available to retrieve H RIC (Economic Timeseries) via TREP?
Dear all, Could you give me guide how to retrieve H RIC (Economic Timeseries, for example- aARCGDPYD/A) via TREP? is it possible using TS1 API? Thanks in advance.
-
How to pull historical Economic Indicator?
I'm trying to get historical data for `CNGYDY=ECI`. I'd like to find a way to use the Eikon API that pull the equivalent of =RHistory("CNGYDY=ECI","ECONOMIC.Timestamp;ECONOMIC.Value"," START:29-Jun-2018 END:30-Mar-2020 INTERVAL:1Q",,"TSREPEAT:NO") I have tried a few ways such as ek.get_data('CNGYDY=ECI',…
-
Retrieving India inflation data using python API
I am trying to get India CPI data by using the following API call: data = ek.get_timeseries(["INCPIY=ECI"], ["ECONOMIC.Value"], start_date="2004-01-01", end_date="2019-12-31", interval="monthly") This returns all NaNs. Same issue with RIC:"aINCCPIYF". Can someone help with errors in the above or help with another method of…
-
How to get economic indicators?
There was the similar question previously and want to know if this built-in function enabling is updated now. https://community.developers.refinitiv.com/questions/25324/how-to-get-real-time-data-on-economic-indicators.html If not built yet, I want to know the request path of where data is stored. Thanks!
-
How to get Economic Calendar from Eikon Data API
I try to use Eikon Data API to get Economic Calendar, such as: 20:30 2019/11/01 USD Change in Non-farm Payrolls (OCT) 20:30 2019/11/01 USD Unemployment Rate (OCT) Does anyone know how to do it? thanks. Code example is better.