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…
I have this working code to identify when is the first period that the constituent lists has data. It correctly states that the oldest constituent list avaialble for S&P 500 (list code LS&PCOMP+MMYY) is 0989 or September 1989. How do I apply this code to multiple constituent codes for around 90 indices? from datetime…
Hi all, I want to analyze historical (quarterly) earnings per share forecasts from the management. How and where do I find them in the workspace or in Datastream? Thanks in advance and best!
hi, the default layout of 'get_data' mothod for a list of instruments with a set of data items in DSWS is not good. e.g below, if all three instruments have data it shows three columns but for some data items it only shows 2 as only 2 provides the data. is there a way to clean the layout? thanks cheers, Ginger
Hi, I need EUR sovereign, ratings based curves history and I found the following, for example for 2Y tenor: EUSOVAAAEUR2Y,EUSOVAEUR2Y, EUSOVBBEUR2Y,EUSOVBEUR2Y. How reliable are these curves? What data cleaning steps do you recommend? I will calculate their VaR so to winsor the percentiles wont work. My another question…
It looks like you're new here. Sign in or register to get started.
