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
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？
Hi @xuke ,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
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.
@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？
Hi @xuke ,
There's a field named DSPLY_NMLL that stores local language instrument name, is this what you're looking for?
@raksina.samasiri Hi, I used to find this field. we found it returns in traditional Chinese character(博隆技術). I want the simplified Chinese character(博隆技术).
@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()
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.
