I would like to ask the following question. I am downloading data for the last 10 years for all companies that have ESG data. Using Eikon's "Build Formula" function, I have been able to download the ESG data and part of the economic-financial data. This download shows me the data as shown in the first image. I would like…
I want to extract historical constituents of index in DATASTREAM, I read somewhere in the forums that it is possible to append List with MMYY information to obtain the list for that month. LHKHCOLC - Current constituent list of Hang Seng Large Cap index. LHKHCOLC0419 - Latest constituent list of Hang Seng Large Cap index…
I was looking to get 52 Week highs for stocks at the end of every month. On the datastream python API i used ds.get_data(tickers=ticker_list, fields=['WC05091'], start=s_date, end = e_date, freq='M') This is however giving me the same 52week high price value for all months. Can you advise what the correct way to call the…
I want to get historical volatility surface data for KOSPI200 options. I found above data with 'KS200VOLSURF' but I just can check real-time data. I want historical volatility surface data like above format(for example, 1year daily data each have above format).
Hi, Is there any way to pull 100 Moneyness IDs using stock RIC (or some other id) from DataStream API in Python? For example for RIC "GE", we have moneyness ID is "GE1$MONEY100". Below is the screenshot from DFO Navigator just for reference. I am looking for a way using Datasteam API in Python.
Hi team, may I know how to let dsws show the names of datatypes? Thanks in advance!
Hi team, I've got a question regarding dsws. If retrieving single filed and startdate = -0D, then the result will not showing the actual date of the data. e.g. df = ds.get_data(tickers = '@:CNM1E1', fields = ['A12FE'], start = '-0D') the result will be showing index, instrument, datatype, value and currency However, if…
As the title and screenshot of the process, I'm getting some fields latest data (related to price, dividend, splits) on numbers of tickers (symbol list is d dataframe with datastream_id, and tickers, containing about 6000 symbols). I'm using get_bundle_data in DatastreamPy, also using ProcessPoolExecutor to get data…
Hi, I would like to extract M&A deals for a list of firms for which I have the security permid. It doesn’t seem to be possible to extract deal information using the security permid though. Is there a way to link the security permid to the company permid? For example: Amazon security permid: 8590928320 -> Company PermID:…
Hi, When I try to get data for the instrument <DOLc1> it is returning data for non-trading days. I tried using Python Datastream module: ds.get_data(tickers='<DOLc1>', fields=['PS'], freq='D', start='2021-01-01") This will return, e.g., data for 2021-01-25, which was a holiday in Sao Paulo and the exchange was closed. My…
It looks like you're new here. Sign in or register to get started.