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() ?
Hi @BlackBird ,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thank you,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
PyDSWS is not the official Refinitiv Datastream WebService Python library. You may need to contact the creator of this library via GitHub to verify what the problem is.
I tested the request with DatastreamPy, the official Refintiv Datastream WebService Python library and the request works fine.
import DatastreamPy as DSWS ds = DSWS.Datastream(username = username, password = password) ds.get_data(tickers='<ALSC.BO^E18>,<BION.NS>', fields=['EPS1UP'],start='2000-01-01')
Hi @BlackBird,
Yes, you can use tickers in the get_data request for DSWS - just enclose these in the braces <>.
E.g:
>>> ds.get_data(tickers='<RLXO.NS>, <RELI.NS>, <HDBK.NS>', fields=['EPS1UP'], start='2001-01-01', end='2020-01-01', freq='M') Instrument <RLXO.NS> <RELI.NS> <HDBK.NS> Field EPS1UP EPS1UP EPS1UP Currency IR IR IR Dates 2001-01-01 NaN 2 NaN 2001-02-01 NaN 1 NaN 2001-03-01 NaN 1 NaN 2001-04-01 NaN 4 NaN 2001-05-01 NaN 4 NaN ... ... ... ... 2019-09-01 1.0 8 1.0 2019-10-01 0.0 5 2.0 2019-11-01 2.0 8 10.0 2019-12-01 2.0 13 28.0 2020-01-01 0.0 11 1.0 [229 rows x 3 columns]
Im trying to fetch the same data for these 2 firms: ALSC.BO^E18, BION.NS using the below formula, but getting issues. The same works when I put "-100D" for eg in the start param. Why would it be so?
Also, is the data available for delisted stocks?
Its best to reach out to Refinitiv content support to get answers on data availability. You can raise a ticket at my.refinitiv.com and directly interact with a content expert.
Sure, can you help with the first part of the question?...the api syntax is not working for start = "2000-01-01" format.
great thanks, that works. But getting the below issue after a couple of api calls
Is this an issue from refinitiv side or syntax?
Nothing wrong with the syntax, I think you might be requesting too much data or too frequently. It could also happen due to the timeout and bad network. Try pacing out the requests.
