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…
Hi, =@DSGRID ($A$1:$A$1007,RI,P,PO,PB,PA,VO,IBNOSH,04/01/2025,,Daily,RowHeader=true;ColHeader=true;Heading=true;Transpose=true;Code=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false;MonthlyTSFormat=true;AutoRefresh=false) is what I used to pull the historical data for some stocks in the excel…
I am attempting to use the Datastream API in R (through the VS Code IDE). I already did so successfully in the past and already initialised my Datastream personal username & password. Now I am trying to run code on a new project (the code was written by someone else). I ran the code: mydsws <- dsws$new() But received an…
HI Devportal, Good morning. I’ve got a spreadsheet with three DSGRID calls, which are refreshed by vba calling application.run “WorkspaceRefreshSelection”,True. The screenshot below shows an example where the RI values for all the stocks is the sam on the 31/3/2003 as it was on the 28/2/2003. This is not a general issue on…
I'm trying to query volume for datastream_id=887742 it works if I only query 2025, but fails if I'm querying 2011-2025 I'm using datastream with the following code: ds.get_data(tickers='887742', fields=['X(VP)'], kind=1, start='2011-01-01', end='2025-12-22', freq='D')
It looks like you're new here. Sign in or register to get started.
