-
Obtain list of all equity indices in a country
Hello, I'm working with Datastream and Eikon. I noticed that on the Datastream navigator we can get access to a list of equity indices for individual countries ("markets" as per the Datastream Navigator terminology)--see attached screenshot for reference.Capture.PNG To avoid manual work, I would like to use Python and my…
-
Unmatched financial statements reference dates with date index and EPS Report Date?
I am analysing Apple financial statements and noticed that the displayed date does not match with the reference date, the stock's fiscal year ends in September. aapl = ds.get_data(tickers = 'US0378331005', fields = ['WC01001A', "WC05901", "WC05902", "WC05903", "WC05904", 'W05350A'], start = '2020-12-31', kind=1, freq =…
-
DSWS REST API
I'm attaching a screenshot but also here's the full details of the issue as well: We're using the DSWS REST API. While trying to troubleshoot in case it was some of our code causing the issue, we tried multiple alternatives. We tried the Python package https://github.com/datastreamapi/DatastreamPy as mentioned on…
-
Failed return when pass the parameters to get_data
Hello, I'm new to the TR API and have been using Python to perform API queries. My script has been running smoothly for about two years. However, when I attempted to run it this week, I encountered various errors. After reviewing the code in my backup (codebk), it appears that the function get_data([list], 'Instrument')…
-
Datastream API - how to get all codes under main code, Example - ITDM
For main code(chain ITDM) on data stream, i need to get the list of all codes under this. how can i check . i dont see options on https://product.datastream.com/DswsClient/Docs/TestRestV1.aspx ITDM has below codes and i need to retrieve via data stream API for automation…
-
importing end of the month date vs 1989-01-15 in python
ds.get_data(tickers ='USCNFBUSQ', start = '1989-01-31', freq = 'M') does not pull in end of the month date. it pulls in 1989-01-15. How do I make it to import end of the month date?
-
How to use organisation perm_id to find their co2 emission equivalents total on excel?
Dear Sir/Madam, I have a list of organisation perm_id (about 3000companies), is it possible to use them to find their co2 equivalents emission data on excel Datastream? If it is possible, could you please provide some guidance for showing how to do it as i have tried lots of time it always shows error on my worksheet. Many…
-
Import csv list of DSCodes in DSWS API
Hi, I'm trying to run DSWS request using a list of dscodes from a csv vile, but the code I'm using adds "[]" before and after the list, it's returning error. Here's my code instruments= [] with open('DSCD list1.csv') as csvDataFile: csvReader = csv.reader(csvDataFile) for row in csvReader: for ticker in row:…
-
How to check if ISIN exists in Datastream database?
Hi can I check if there exists a function that checks whether an ISIN is not available in Datastream API? Currently I am just requesting for these ISINs and checking if the $$ER: E100,INVALID CODE OR EXPRESSION ENTERED is given in the Value column. Thanks. df = ds.get_data( tickers='US606822CR31', fields=['CMPB', 'CMPA'],…
-
I am trying to run code on codebook . I have correct App Key but getting this error- EikonError(1, '
I am trying to work on API , but not able to run app key code . I have tried to use authenticated app key but it says wrong api
-
US Treasury Issued Amounts over time
Trying to get a time series (monthly issuance) of US Treasury instruments e.g. US2YT=RR. Issued Amount - Time series great but always null Amount Outstanding - Can get a value back for Amount Outstanding (but its not time series) Face Outstanding - again not time series What field can be used for treasury tickers. Prefer…
-
Datastream Web Service Python: TypeError: DataClient.post_user_request() takes from 2 to 7 positiona
OS: Ubuntu Python version: 3.10.12 DatastreamPy version: 2.0.25 I am trying to switch to DatastreamPY from DatastreamDSWS. However, when I run codes by using DatastreamPy, error messages always show up as follows: [Code] import os import pandas as pd import DatastreamPy as dsweb uid = os.getenv('LSEG_DS_USERID') pwd =…
-
Get Name of Instrument and get name DataType ??
Hello I'm using the Python API (DatastreamPy), but I can't find how to request the Instrument name and the DataType name. This is my code import pandas as pd import DatastreamPy as dsweb ds = dsweb.DataClient(None, '', '') history = ds.get_data(tickers = 'TOTMKDV', fields = ['DWNM'], kind = 1, start = '-1Y', req = 'M', )…
-
module 'DatastreamPy' has no attribute 'Datastream'
I am trying to run the same code as in codebk, on my mac it says "module 'DatastreamPy' has no attribute 'Datastream'"
-
Datastream: 500 Server Error: Internal Server Error for url:
Hi, Datastream was working fine, but then I started getting this error. Nothing has have changed on my side. Exception has occurred: HTTPError 500 Server Error: Internal Server Error for url: https://product.datastream.com/DSWSClient/V1/DSService.svc/rest/GetDataBundle
-
How do we scale the RIC code/currency while requesting from SFTP method?
Dear Team, We are getting the output of below Instrument as 0.2806,0.2802 where it should be 0.002806,0.002802. We are trying to apply the scaling of 100 to this specific RIC code. Is there any guide to apply this scaling on this specific RIC code? Please support. <Instrument> <IdentifierType>RIC</IdentifierType>…
-
Searching by RIC code datastream python api
Hi everyone. I'm trying to use the python Datastream API (with the DatastreamPy package) to search for market data for derivatives. I'm doing this using the ds.get_data() function. I have the RIC code of a futures contract i want to get information on. I would like to get price and volume time series info on this contract.…
-
CODEBOOK for Datastream
Hello Team, I have a client with a query as below. I am trying to use the CODEBOOK app (CODEBK) - a development environment for financial coders with a fully hosted cloud-based kernel for Python computations, closely integrated with Refinitiv. I am currently attempting to extract Scope 1 and Scope 2 emissions based on a…
-
Issue to consume streaming price on DesktopSession mode using Refinitiv Data under C#.Net
Dear Developer community i share with an issue i'am facing since last week. Indeed when opening a Desktop session it tooks a very long time that usual, to finally a state response 'Opened'. But every request to stream data return 0 data. at log level, i got these warning messages: 2024-03-01…
-
Querying DatastreamDSWS2R with RICs
Hi, Is it possible to query DSWS via R using package DatastreamDSWS2R with RICs instead of DS codes as identifiers? I tried the following but it won't work because it requires DS code @AAPL instead of AAPL.OQ. If this is not possible, can you suggest a workaround to get the DS codes from a list of RICs? cheers…
-
Datastream API is intermittently giving a Read Timed Out error
We have a number of jobs that use the Datastream API at the same time. They will each pull data (sometimes the same data) to calculate different models. We will intermittently get a "Read Timed Out" error: ``` requests.exceptions.ReadTimeout: HTTPSConnectionPool(host='product.datastream.com', port=443): Read timed out.…
-
adjusted closign price: eikon and yahoo finance is difference
i notice that the TR.PriceClose data is different from yahoo finance's adjusted close price. code is df, err = ek.get_data( instruments = ['MSFT.O'] fields = [ 'TR.PriceClose.date', 'TR.PriceClose' ], parameters = { 'SDate' ... For example for microsoft on 2021-02-12, eikon TR.PriceClose gives 244.990, and for yahoo…
-
data download
hi what would be the code to download. several symbols/instrument, for daily timer series ratios such as price to book, price to earnings, marketcap, dividend yield, dividend
-
instrument tickers
Hi, how can i quickly transform yfinance ticker symbols to that of refinitiv? For example AAPL, and some other symbols. I notice that not all of your instruments end with ".O" which makes it difficult for me to just write a function to convert yfinance symbols to that of refinitiv
-
Data for Delisting companies
Hi everybody! I am currently engaged in a project that involves analyzing companies in the United States that have been delisted or are on the verge of delisting. The objective is to compute the "delisting return," which necessitates understanding the specific reasons behind each company's delisting. To identify these…
-
Why I can't get the whole RIC history when I make a multirequest, but I only get last 30 periods?
I am using this python code to get power and gas hist prices Basically I created 3 dictionaries with all the RICs for Power DE, Power Fr and TTF price for all the monthly and quarterly and cal products. I create a simple function that for each key of the dict, download the price series. Then I change the column names with…
-
DSGRID and DataStream request differences
I'm currently working on a python model that extracts and processes company data that is largely based on a pre-existing model in excel I received from a colleague. One part of this model uses a function: @Thomson.Reuters.AFOSpreadSheetFormulas.DSGRID(...) To my understanding this translates to a Datastream call using DSWS…
-
Error - installation of DSWS
Hi, I got an error as below when I tried to install DSWS library via Anaconda admin prompt. Would you advice on this issue?
-
VAConsumer ETA CSharp Not Streaming Data
Hi, I was using VAConsumer app to access the streaming data for USFOMC=ECI Yesterday at 11:30 UTC. The data released at expected time but it didn't got updated in the CMD under the field it supposed to (ECON_ACT). The data was updated on Eikon terminal though. Can you please help me with what I might be doing wrong. I've…
-
Using PYDSWS to fetch time series data.
Hi, I am trying to fetch the field EPS1UP (which is available as time series) for a list of Indian Stocks (for eg, RELI.NS, HDBK.NS, RLXO.NS etc.) from 2001-2023. How do I fetch this using the datastream API (Im currently using PYDSWS) in python? Also, can I use RICs as the ticker symbol in PyDSWS.get_data() ?
-
DSWS Python API not working
The following code has worked without issue for a long time but as of yesterday quit working: import DatastreamDSWS as DSWS ds = DSWS.Datastream(username = "XXXXX", password = "XXXXX") I'm using Jupyter Notebook and have not made any changes to Python or associated packages. The Eikon API and all other packages are working…
-
Datastream DSWS Time out Error
Thank you for your hard work. I'm currently using the Python API for Datastream DSWS, and I'm experiencing a timeout error when calling the Datastream object. I'm posting this question to inquire about the possible causes.
-
DatastreamDSWS Invaliad Token Error
Hello, Today I tried ds.get_data() from DatastreamDSWS package and got the following error: ds.get_data(tickers='VOD', fields='P', kind=0) get_data : Exception Occured (<class 'Exception'>, Exception('Invalid Token Value'), <traceback object at 0x7fd834d87fc0>) None Traceback (most recent call last): File…
-
Receive status message for un known subscription id 192
When trying to use the standard Python's Eikon API, I get the following error code: 2023-10-02 08:55:48,082 P[4884] [WebSocket 0 4120] Receive message for login 192 : {'ID': 192, 'State': {'Code': 'ConnectionError', 'Data': 'Suspect', 'Stream': 'Closed', 'Text': 'Cannot establish connection to the platform'}, 'Type':…
-
Datastream DSWS Rest API -- Request all datatypes for a mnemonic
Hi, is there some simple method of requesting all available data types for a given mnemonic in the REST API for Datastream? I've looked through the documentation, and I'm not seeing one. I'd like to be able to programmatically refine my search if possible.
-
Python API Error: Microsoft Visual C++ Runtime Library ---- Assertion Failed
It shows Microsoft Visual C++ Runtime Library ---- Assertion Failed when I am trying to run a search function with Admin right. Is it because my Microsoft Visual C++ setting has some issues? Thank you. After click Abort:
-
Datastream Web Services API Bug
I have a weird problem happening with Datastream Web Services. If I call ds.get_data for one DSCD, it comes back with data for all fields, but if I call with more than one DS Code, it comes back with nothing. In the below screenshots, the first one returns the correct data for DSCD 130037, but when I include a second DSCD…
-
Workspace API -> Docker Container Application
Hi, We are a Workspace user and have developed a series of dashboards using Python / Streamlit library. When trying to containerize our app with docker we face issues as the docker image is unable to detect that Workspace is open and running. 1. What would be the best practice of consuming the real-time streaming data with…
-
Historical 52 Week High from DS Worldscope
I was looking to get 52 Week highs for stocks at the end of every month. On the datastream python API i used ds.get_data(tickers=ticker_list, fields=['WC05091'], start=s_date, end = e_date, freq='M') This is however giving me the same 52week high price value for all months. Can you advise what the correct way to call the…
-
100% Moneyness ID, for example for RIC "GE", 100 Moneyness ID is GE1$MONEY100
Hi, Is there any way to pull 100 Moneyness IDs using stock RIC (or some other id) from DataStream API in Python? For example for RIC "GE", we have moneyness ID is "GE1$MONEY100". Below is the screenshot from DFO Navigator just for reference. I am looking for a way using Datasteam API in Python.