I am using ThomsonReuters.DswsApi DSDataRequest and have run a few times (five or six) for an Index and maybe 60 data columns So out going data should be small enough. However our network is alerting us of large volumes of data going OUT of the network within a short period of time (1GiB+) to datastreamwide.refinitiv.com…
Hi, I am using an R API call to extract historic returns from the datastream API from a dataframe of Sedols and Dates. The API call works perfectly for ISIN's however for this dataset I only have Sedols. I have noticed that the call only works on numeric Sedols and not alpha numeric Sedols. I don't have a country code so…
Hi, I am using the pydatastream package to query some data. I have a list of datastream mnemonics for stocks, such as @AAPL. How can I get the mnemonic of the chain of options that trades on AAPL? In this specific case I can find it through the DFO navigator, where for example the chain for live AAPL calls is LOPTAAQ$LC,…
Hey People, I am currently on my bachelors thesis and getting myself into Refinitiv. i am trying to retrieve "daily historic spreads" from a selection of bonds. All of them are in the "Latin American" markets e.g. Brazil, Argentina etc... i have major problems with getting any numbers using the excel add in: "Refinitiv…
How do you retrieve 1000 data points including missing ones (i.e. not omit missing ones) in DSWS? Thanks!
I have downloaded the „Excel VBA Sample” (v1.2, 24 Jul 2020) file from the Datastream product website (http://product.datastream.com/DswsClient/Docs/Downloads.aspx). I have made some minor changes on the “DatastreamRequests” tab (shown in red in the screenshot) and clicked on the “Get Data Bundle (REST_POST)” button. The…
I am having troubles getting the ISIN of the Cheapest to Deliver (CTD) linked to a list of futures. I was able to retrieve this datapoint from Datastream for futures on OAT/BTP/Bunds etc, but not for futures on US Treasuries or Japanese Govt Bonds. Here a couple of symbols/RICs which I cannot find: DS SYMBOL RIC JGB09222…
I am using the Datastream API for Python. It returns "NA" values - when I use the "DSGRID" Excel Add-in on the same list of securities, I get the required "SECD" values. My code: securities = ['US0235861004', 'US29362U1043', 'US5393192027', 'US07134L1070', 'CA91702V1013', 'US0008681092', 'US4281031058', 'US16411R2085',…
Hi, So I'm currently trying to get forecasted quarterly EPS that relies on IBES through the datastream formula. I'm a complete rookie when it comes to programming so I have zero idea why I'm getting denied acces. Even through my university network, I still don't get permission. This step is quite crucial for my data…
Hi all, I perform a successful login when try to download data from DSWS but, when I ask for data, results are empty. It's not working since a week ago, and some queries that used to work now don't.This is the way I try to reach the data: df = ds.get_data(tickers=<data_name>, start=<start_date>, end=<end_date>, freq="M")…
It looks like you're new here. Sign in or register to get started.
