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…
I'm assuming if warrants dont show up on the balance sheet then its likely 0. Is there any quick way to find out a company's total diluted shares outstanding for a FY?
Hi Team,15270394 my DataStream doesn't load up since your update. Generally, that code is really faint in the background, with the platform largely looking empty, Its not excel, It is DataStream on web platform ERROR: Received HTTP error code 429 from…
Do you know if there's a way to pull the % or number of index members trading at a new 52-week high or above their 200-day moving avg either using I/B/E/S global aggregates data in Datastream or otherwise? i need to be able to pull it through your API in order for us to consume it . DataStream API via Python
My request tables on excel all use the refinitiv eikon datastream add-in to retrieve data series. Since the transition to LSEG Workspace, I cannot process tables and wish to know how to solve this. DO I simply have to change add-ins or will I have rebuild request tables all over again?
Request to review the simple query that client wrote & optimize it ds = dsweb.DataClient(username = auth_info['secrets'][1]['key'], password = auth_info['secrets'][1]['value']) # Golbal parameters start_date = '2008-01-01' # Listing of instruments per dataset instruments = { 'energy' : 'ETQC.01,LNGASIA,NATGAS1,LLCC.01',…
how can i determ if 800 different firms are family controlled using refinitiv for excel?
It looks like you're new here. Sign in or register to get started.
