Hi, Is it possible to query DSWS via R using package DatastreamDSWS2R with RICs instead of DS codes as identifiers? I tried the following but it won't work because it requires DS code @AAPL instead of AAPL.OQ. If this is not possible, can you suggest a workaround to get the DS codes from a list of RICs? cheers…
We have a number of jobs that use the Datastream API at the same time. They will each pull data (sometimes the same data) to calculate different models. We will intermittently get a "Read Timed Out" error: ``` requests.exceptions.ReadTimeout: HTTPSConnectionPool(host='product.datastream.com', port=443): Read timed out.…
Hi, how can i quickly transform yfinance ticker symbols to that of refinitiv? For example AAPL, and some other symbols. I notice that not all of your instruments end with ".O" which makes it difficult for me to just write a function to convert yfinance symbols to that of refinitiv
i notice that the TR.PriceClose data is different from yahoo finance's adjusted close price. code is df, err = ek.get_data( instruments = ['MSFT.O'] fields = [ 'TR.PriceClose.date', 'TR.PriceClose' ], parameters = { 'SDate' ... For example for microsoft on 2021-02-12, eikon TR.PriceClose gives 244.990, and for yahoo…
Hi, I have attempted to download daily stock returns for all stocks within the US tech sector, using their ISIN codes downloaded from Eikon's Screener tool, before using Datastream to create a request for daily price change within excel. This has been for between the periods of 2000-2022. Now, I'm worried that some of the…
I'm trying to get the beta value for FTSE All share index members for every month between 2010-2019 in datastream excel. How do I do this?
Hi, for awhile now I have been using the following block of code to access our datastream FTP: with FTP("datastreamddl.refinitiv.com") as ftp: print('Please input username') user_ = getpass.getpass() print('Please input password') password = getpass.getpass() This has previously worked without errors but now, before I am…
Hi all, I want to know how i can export the data named in the question above into excel. I need to see the percentage composition of two indices over the past 40 years. Hope someone can help me with that. Thanks
I am using this code to get price data on expired option NDXb1921A5075.U^B21: df5 = ds.get_data(tickers="<NDXb1921A5075.U^B21>", fields=['MP'], start = '2021-01-01', end = '2021-09-18', freq= 'D' ) According to the RIC rules this option should have been expired on February 19, 2021, however the code above returns price…
(eg: for saturday & sunday the FRIDAY prices should reflect), In Bloomberg the command we use is =BDH("RELIANCE IB Equity","PX_LAST","01/01/2023",TODAY(),"DAYS=A","FILL=P"), Here FILL=P used to fill for previous prices where HOLIDAY exists
It looks like you're new here. Sign in or register to get started.
