how to use Eikon API to get stock RIC code

xuke

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"

])

Find more posts tagged with

eikon

api

workspace

eikon-data-api

workspace-data-api

#content

Accepted answers

Jirapongse

@joneliu

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

All comments

aramyan.h

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

joneliu

@aramyan.h

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" ?

Jirapongse

@xuke

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.

joneliu

@Jirapongse

We want to query data in batches,Whether it is possible to have code to query data in batches?

Jirapongse

@joneliu

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

joneliu

why these infos existed when I want to get price?

EXPLORE OUR SITES