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
I'm currently working on a python model that extracts and processes company data that is largely based on a pre-existing model in excel I received from a colleague. One part of this model uses a function: @Thomson.Reuters.AFOSpreadSheetFormulas.DSGRID(...) To my understanding this translates to a Datastream call using DSWS…
Hi, what is the approach to finding a WorldScope Item, e.g. Interest Coverage Ratio (EBIT/Total Interest Expense) Worldscope Item WC08291 for a universe of all US Stocks? I've tried for the NASDAQ 100 nut even for the 100 stocks some of the Interest Coverage Ratios are not reported, is this a license issue on my side?…
DSWS I would like to get the historical value of total return on FTSE World Government Excluding Japan Bond Index with JPY currency headged. I only can get the data of $ base - DSWS mnemonic FTSWGNJ and not able to find it in JPY. Please advise how to get to the similar caluculated value in JPY in python. The same as for…
Hello, I am having trouble getting the Total Return Index from selected Credit Default Swaps. The Error-Code: $$ER: E100,INVALID CODE OR EXPRESSION ENTERED keeps showing up, regardless of which CDS I choose in Datastream. I am able to get the Total Return Index for Stocks and Bonds, CDS are the only type that do not work:…
It looks like you're new here. Sign in or register to get started.
