Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
Question:
1. We get a stock information: 600687.SS and how to use Eikon API to get stock RIC code?
We use Eikon desktop to find the RIC code is 600687.SS^C21. This is a delisted stock.
2. Could we use search function and how to write the statement? Thanks.
Python statement we used now：
data, err = ek.get_data(instruments=600687.SS, fields=[
"TR.RICCode",
"CF_NAME",
"DSPLY_NMLL",
"TR.IPODate",
"CF_CURR"
])
Hi,
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.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
You can specify multiple RICs in the query with the OR operator. You need to specify the view to rd.discovery.Views.EQUITY_QUOTES.
df = rd.discovery.search( view=rd.discovery.Views.EQUITY_QUOTES, query="600687.SS OR 600688.SS", top=10, select="RIC,DocumentTitle,IPODate,OriginalRIC,QuoteCurrency,RCSCurrencyName,DocumentTitleZhHans,OldQuoteRICs" ) df
Hi @xuke ,
What about using the symbology function which will return available symbols for the instrument?
ek.get_symbology('600687.SS')
Hope this helps.
Best regards,
Haykaz
data1, err = ek.get_symbology(["600687.SS"], from_symbol_type="CUSIP", to_symbol_type="RIC")
error info:
get stock info exception: not enough values to unpack (expected 2, got 1)
which type should we use to "from_symbol_type" ?
It should be RIC.
data1 = ek.get_symbology(["600687.SS"], from_symbol_type="RIC", to_symbol_type="RIC") data1
The ek.get_symbology method returns a value (data1), not a tuple (data1, err).
You, you can use the search methon in the Refinitiv Data Library for Python.
The code looks like this:
df = rd.discovery.search( view=rd.discovery.Views.SEARCH_ALL, query="600687.SS", top=10, select="RIC,DocumentTitle,IPODate,OriginalRIC,QuoteCurrency,RCSCurrencyName,DocumentTitleZhHans,OldQuoteRICs" )
However, it doesn't return the IPO Date of 600687.SS.
We want to query data in batches,Whether it is possible to have code to query data in batches?
