how to use Eikon API to get information in different language？

xuke

Python code:

data, err = ek.get_data(instruments=code, fields=[

"TR.RICCode",

"CF_NAME",

"DSPLY_NMLL",

"TR.TRBCIndustry"

])

Now we get the TR.TRBCIndustry field value in English. and is it possible to get the value in Chinese, Japanese, Korean and traditional Chinese language？

Find more posts tagged with

eikon

api

workspace

refinitiv-dataplatform-eikon

#technology

Accepted answers

Jirapongse

@xuke

Thank you for reaching out to us.

I can use the Search feature in the Refinitiv Data Library for Python to get those values.

df = rd.discovery.search(
    view = rd.discovery.Views.EQUITY_QUOTES,
    filter = "RIC in ('0001.HK' 'IBM.N')",
    select = "BusinessEntity,DocumentTitle, RIC, RCSTRBC2012Leaf,RCSTRBC2012LeafML"
)
df["RCSTRBC2012LeafML"].tolist()

The output looks like this:

However, you may contact the helpdesk support team directly via MyRefinitiv to confirm if those values are available in Data Item Browser.

All comments

Jirapongse

@xuke

Thank you for reaching out to us.

I can use the Search feature in the Refinitiv Data Library for Python to get those values.

df = rd.discovery.search(
    view = rd.discovery.Views.EQUITY_QUOTES,
    filter = "RIC in ('0001.HK' 'IBM.N')",
    select = "BusinessEntity,DocumentTitle, RIC, RCSTRBC2012Leaf,RCSTRBC2012LeafML"
)
df["RCSTRBC2012LeafML"].tolist()

The output looks like this:

However, you may contact the helpdesk support team directly via MyRefinitiv to confirm if those values are available in Data Item Browser.

xuke

@Jirapongse It seems we cannot get the value in Korean.

And one more question, how can we get the CF_NAME field value in Chinese, Japanese, Korean and traditional Chinese language？

raksina.samasiri

Hi @xuke ,

There's a field named DSPLY_NMLL that stores local language instrument name, is this what you're looking for?

xuke

@raksina.samasiri Hi, I used to find this field. we found it returns in traditional Chinese character(博隆技術). I want the simplified Chinese character(博隆技术).

xuke

@Jirapongse Thanks for your reply. We try below python API, but we cannot get industry multiple languages for "BOND" security. We can get "TR.TRBCIndustry" field which is "Electrical Components & Equipment". Kindly tell us how to get bond industry in multiple languages.

Example:

df = rd.discovery.search(

view = rd.discovery.Views.EQUITY_QUOTES,

filter = "RIC in ('CN113672CB=')",

select = "BusinessEntity, DocumentTitle, RIC, RCSTRBC2012Leaf,RCSTRBC2012LeafML"

)

df["RCSTRBC2012LeafML"].tolist()

Jirapongse

@xuke

The CN113672CB= is not in the EQUITY_QUOTES view. In this case, you cau use the SEARCH_ALL view instead.

df = rd.discovery.search(
    view = rd.discovery.Views.SEARCH_ALL,
    filter = "RIC in ('CN113672CB=')",
    select = "BusinessEntity, DocumentTitle, RIC, RCSTRBC2012Leaf,RCSTRBC2012LeafML,RCSTRBCLeaf,RCSTRBCLeafML"
)
print(df["RCSTRBC2012LeafML"].tolist())
print(df["RCSTRBCLeafML"].tolist())

CN113672CB= is in the FIXED_INCOME_QUOTES and FIXED_INCOME_INSTRUMENTS view.

EXPLORE OUR SITES