We have an Excel file called the Macro Weekly Calendar which is used weekly by our team at Frais Capital. The file pulls live data directly through Refinitiv Workspace Lite via the Excel add-in. The file contains four types of live data: Economic indicators for Australia, United States and China — including macro data such…
When we attempted to retrieve data using the Python API (DatastreamDSWS), we encountered the error shown below and were unable to obtain the data. Would you happen to know the possible cause of this issue? We apologize for the inconvenience, but if you have any idea what might be causing this error, we would greatly…
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…
It looks like you're new here. Sign in or register to get started.
