Hi there, I am working on creating a process that relies on data returned via DSGRID formulas. I am trying to build a macro that I can run using a python script that refreshes the formulas and returns/confirms when the data has actually been retrieved. Looking at other posts, I've been able to find that the below line will…
Initially client was asking for How can I preserve the values while "erasing" the formula in Cell BB7 in DataStream? So I have provided the below steps: To preserve the values while removing the formula, use the "Save as Values" feature: 1. Open your file (ensure data is updated) 2. Right-click on cell BB7 (or select the…
I’m trying to retrieve multiple mapped DS mnemonic codes using multiple ISIN codes, but I’m getting an error as shown below. What is the correct code?
Hi, I found two Python packages on PyPI — DatastreamUCS and DatastreamNavigator — that appear to be related to the Datastream Web Service. The PyPI author field lists "London Stock Exchange", and the packages seem to provide features not available in DatastreamPy, such as Navigator search integration and economic filter…
I have lost access to ICE indices in Datastream - is there anyway I can have this added back on
Hi, I would like to replicate the below excel formula using the python api. The goal is to get the total return of an Isin for a given period in a specific currency. In this case EUR. As we wish to do this for a considerable amount of Isins over multiple time periods, we wish to move from excel to Python to achieve this.…
I'm using Excel with Workspace and Datastream. I have many files that I want to update via the excel addin. I want to write a code (VBA or Python) to open these files and "click" "Refresh Worksheet" button, wait for the update, and then save and close the excel files. Could you assist me with a short code snippet that…
I would like to pull historical data for price, dividend yield, ROIC, short interest, average daily volume, and others using DatastreamPy in Python for all index constituents (RICs: .BVSP, .MLCX, .SMLL) over the last 6 months. Since some stocks were delisted and others were added during this period, the request should…
Hi, in Excel I can create a volatility surface over delta / moneyness and maturity using @DSGRID. How can I do this in Python using DSWS. How do I for example pull the implied vols for different maturities for INCEDELTA10C. Using getdata and the Mnemonic returns values, but it is unclear for which maturity, and how to…
It looks like you're new here. Sign in or register to get started.
