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:…
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'],…
...rtation. How to download Price to Book Ratio data of 60-100 stocks from Refinitiv Eikon Datastream on my windows laptop? I need this data for my master's dissertation.
Hello colleagues, We are following refinitiv migration [guide](https://developers.lseg.com/en/article-catalog/article/webSocket-api-rto-v2-authentication-migration-guide) and have a trouble to connect to RTO via websockets. Here is code snippet in python: import websockets import json import asyncio PING_TIMEOUT = 40 def…
I would like to analyze portfolios of institutional investors based in a given location (e.g. country) using the built-in formula in excel or by downloading the data from the web. For a list of investors (could exceed 1000 Perm Ids) -> for each investor find all/major equity holdings by firm ID (RIC, ISIN, and or any other…
Hi is there a way to check when does Datastream api update their data (Is there a specific time in the day where they update the data)? Asking this in the context of fixed income and macro data. Thanks!
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…
I am using Refinitiv Eikon Datastream in Excel. I want to extract the ESG scores of several companies I have collected in a sample, I have the ISIN codes belonging to those companies. How can I insert those ISIN codes in Datastream to extract the ESG scores belonging to those companies?
...onal arguments but 8 were given 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 =…
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', )…
It looks like you're new here. Sign in or register to get started.