Hi, I want to download data from the DSCHART app (TRI from several global indices) but I cannot figure out how to parametrize the dates to be end of month. I didn't find in the documentation how to do this. Using Dtart=BASE and End:LATEST provides monthly data but is not end of month (as in the screenshot, I get dates such…
Hi, I'm using the .net API for DSWS I want to retrieve the last available value and date from a time series prior to a specific date. For example: DSDataRequest reqDSRequest = new DSDataRequest() { Instrument = new DSInstrument("VOD"), DataTypes = new DSDataTypes("WC07240"), Date = ??? }; Is this possible ? Thanks, Fergal
Hello, is it possible to install Datastream API through Jupyter notebook? or can we install it without using the anaconda prompt? Thank you
How can I pull historical ticker-level closing auction volume in Refinitiv Eikon excel?
We are fetching snapshots of several thousands RIC's using ETA and RSSL_DMT_MARKET_PRICE. In the data retrieved is it possible to determine whether an instument is an ETF or not. For example, this would appear to be an ETF based on DSPLY_NMLL, and there is an IOPV. Does CONTEXT_ID:2633 mean that it is an ETF?…
Hi - I'm using WC07240 (Net Sales), but I have a problem when I set the variable dtAsOfDate to previous business day which gives me NA for my stocks. I want to see the relevant value + date for this item for my stocks - but how can I get this? Date = new DSSnapshotDate(DSDateType.Absolute(dtAsOFDate)
Hello, I would like to get the constituents of the index JPMGCOC. I've tried to add "L" and "|L" but it doesn't work. Could you help me please?
Hello, I have built this code in python - as a mere example - to open a specific Excel file using the Win32.client where I need to add a specific DSGRID code to fetch some data in Datastream with the COM addin. # # Open an existing workbook # import win32com.client as win32 # Set-up a Connection With Excel excel =…
How is historic beta calculated
Hello, trying to use plotly to plot this simple dataframe (dfplot): index Strat1 237 2022-11-29 -0.159187 238 2022-11-30 3.094787 239 2022-12-01 -0.086763 240 2022-12-02 -0.000000 241 2022-12-05 -0.000000 Using this code: import plotly.express as px fig = px.line(dfplot, x="Date", y="Daily Return", title='Daily Return…
It looks like you're new here. Sign in or register to get started.