-
I want to get data using python API for multiple fields and RICs for a time period
The output that the get_history function returns is not in the best format. The first column contains dates, the first row contains RICs, and the second row contains fields. I want to have the data in the following format: the first column should contain dates, the second column should contain RICs, and the other columns…
-
Downloading Complete Financial Statements from the Main Market of a given EU stock exchange (prec...
...isley Polish Stock Exchange GPW w Warszawie Main Market PTCs) Hi, I am wondering whether I can and how can I download Annual Complete Basic Financial Statements (Annual: Balance Sheet, P&L/Income Statement , Statement of CF, Changes in Equity, if in refinitive ESG especially G data is available, then I'd like it too,…
-
What does "restated data for last years values where available" mean?
When reading the description of the datatype WC08126 (Inventory Days Held), From Datastream, I saw that they describe it as: I am wondering what "restated data for last year where available" means. From my understanding, e.g., when we calculate the Inventory Days Held (IDH) for a company A at the end of the year 2020, if…
-
Smart Estimates Multiple comes in string format
I would like to create a dcf calculation for all members of the S&P500. I want to calculate the terminal bvalue using the EV/FCF Smart Estimate multiple. The problem is that the values are strings containing spaces between each number that are not visible and cannot be removed. (can’t convert data type) df_Data, err =…
-
How to change pandas data type?
How to change pandas data type? Is there a pandas function to type convert form 'pandas.core.series.Series' to 'pandas.core.frame.Pandas' ? Data example: numpy_data = np.array([[1, 2], [3, 4], [1, 1]]) df = pd.DataFrame(data=numpy_data, index=[1,2,3], columns=["column1", "column2"]) Here I get the pandas.core.frame.Pandas…
-
Why does this DDL request fail validation?
Request {LOGON} (REMOVED) {FORMAT} {EXTRACTION} X1 {TRIGGER} NOW {FORMAT} SRVRFILEPREFIX=TEST DCDEFLT=Y MERGE=Y TRAN=N MNEMONIC=Y NAME=Y {REQTYPE} S {DATATYPES} DS.NDOR1 {INSTRUMENTS} UKCHAW.. UKCONPRCF Validation Response: DD4VAL Data Download: Validation Summary - (Removed) Date: 08/09/2021…
-
How to get the category of an asset?
When searching an asset using datastream, there is a category column on the left to narrow down the search result. My question is: given a specific asset, how can I get its category? In other words, is there a datastream datatype for "category"? I know there is a "TYPE" datatype but they are still a little bit different.
-
Locating data type(s)
Hi, We use the datastream data loader (FTP) service When using the datastream navigator to locate a mnemonic, we also need to know which data type to request. e.g. for Mnemonic "UKCONPRCF" we use data type "ESA" Using the navigator, how do we find the data type, where can I find "ESA" for mnemonic "UKCONPRCF"? Image Caption
-
where can I find Datastream Navigator in EIKON?
I am using EIKON Research and Advisory (EIKON RNA) with DSWS API add-in. In ds.get_data, datatype needs to be entered in 'field'. But, I do not know how to search a valid 'field' name. For example, if I want to call a revenue, I do not know what to enter for 'field'. Moreover, it is hard to know what 'MV', 'PO', 'PH'…
-
What happened to the datatype INDX
Hello, I used to be able to draw down the static datatype "INDX" for an equity item. This gave me the market that the firm was based in. The INDX datatype is no longer available - what has replaced it? Thanks, Ed
-
Currency for Datatype in DSWS
I am just wondering whether/how I can specify a currency for datatypes in the REST Desktop Web service (Datastream). An example of monthly outputs from a Timeseries request are below for EPS1FD12 (12m forward EPS) for A:BHPX. The default currency value is in US$. {'DataType': 'EPS1FD12', 'SymbolValues': [{'Currency': 'U$',…
-
Get date of fiscal year end using datatype code WC05350
Below are a few isins that return WC05350 as “NA” * IE00BY7QL619 * US18482P1030 * US1251411013 * US0025353006 Here is the code snippet that I am using publicstring GetData_SnapshotSingle() { var request = new DSDataRequest() { Instrument = new DSInstrument("IE00BY7QL619"), DataTypes = new DSDataTypes("LOC", "EXNAME",…