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')
Hi, I had an LSEG helpchat which instructed me to post my question here (Ticket#15530419). I am usually using the Refinitiv GUI dashboard, but am trying to set up my Python API calls to fetch hourly FX and interest rate datasets. I am following the Python Juypter Notebook provided by LESG here:…
.
Am I able to get this data quarterly from 2009-2025? and am I able to do it through the excel extension?
https://us.v-cdn.net/6038239/uploads/CACNVV9PE3ZC/lseg-series-281-29.xlsx I have a data series for 'iBoxx EUR Banks Senior United Kingdom - Optional Adj Sprd - iBoxx EUR Banks Senior United Kingdom - Optional Adj Sprd' which I currently pull through into a spreadsheet with the IBEBSUK ticker. Would you have some sort of…
It looks like you're new here. Sign in or register to get started.
