Hello, I have built this code in python - as a mere example - to open a specific Excel file using the Win32.client where I need to add a specific DSGRID code to fetch some data in Datastream with the COM addin. # # Open an existing workbook # import win32com.client as win32 # Set-up a Connection With Excel excel =…
How is historic beta calculated
Hello, trying to use plotly to plot this simple dataframe (dfplot): index Strat1 237 2022-11-29 -0.159187 238 2022-11-30 3.094787 239 2022-12-01 -0.086763 240 2022-12-02 -0.000000 241 2022-12-05 -0.000000 Using this code: import plotly.express as px fig = px.line(dfplot, x="Date", y="Daily Return", title='Daily Return…
I'm Using Datastream services with Python API(partially customized). I find out some of data in Datastream updated after calendar_date, which is not available at calendar_date actually. However, I need point-in-time info. to know exactly when the data is available. Is there any solution to get effective_date (actual report…
I'm looking at CME futures data and there are two types for S&P500 futures, i.e., EScv1 and ESc1. What is the difference between the two?
How can we find all the contracts that are used to construct the continuous series? Is there a way to automatically generate the tickers for the contracts that are yet to expire? The question is platform and coding language agnostic.
Goodmorning, I'm using DSWS (PyDSWS) through Python in order to get the average rating of an index (es. MLEXPTL) at a specific date with the field code "CRAT". I would like to understand better what type rating is. Is it a second-best rating? Is it a rating calculated by the index provider or by datastream?
I was referred to this forum from the Refinitiv helpdesk. I do face an error with $$ER: E100,ACCESS DENIED for a couple of Refinitiv IDs, which I can access just fine in Excel, but not using GitHub - DatastreamDSWS/Datastream: Python API for DSWS with the same login information. The offending IDs are…
Hi everyone, is there somewhere a complete list of all possible error codes the API can return with an explanation? Examples: $$ER: 0904,NO DATA AVAILABLE or $$ER: E100,INVALID CODE OR EXPRESSION ENTERED Thank you very much for your help!
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()))…
It looks like you're new here. Sign in or register to get started.