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:…
Hi, I got an error as below when I tried to install DSWS library via Anaconda admin prompt. Would you advice on this issue?
Hi, I am trying to fetch the field EPS1UP (which is available as time series) for a list of Indian Stocks (for eg, RELI.NS, HDBK.NS, RLXO.NS etc.) from 2001-2023. How do I fetch this using the datastream API (Im currently using PYDSWS) in python? Also, can I use RICs as the ticker symbol in PyDSWS.get_data() ?
...ing the error message: AttributeError: module 'wincertstore' has no attribute 'CertFile'. Please can you advise? A client is installing DSWS to use in Jupyter with Python. He already has wincertstore installed but is getting the error message: AttributeError: module 'wincertstore' has no attribute 'CertFile'. Please can…
The following code has worked without issue for a long time but as of yesterday quit working: import DatastreamDSWS as DSWS ds = DSWS.Datastream(username = "XXXXX", password = "XXXXX") I'm using Jupyter Notebook and have not made any changes to Python or associated packages. The Eikon API and all other packages are working…
It looks like you're new here. Sign in or register to get started.
