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

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?

Best Answer

  • Jirapongse
    Answer ✓

    @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:

    1705900158514.png

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


Answers

  • @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?

    1706597034867.png

    1706597093907.png

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

    1706597585385.png

  • @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()

  • @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())

    1712828545859.png

    CN113672CB= is in the FIXED_INCOME_QUOTES and FIXED_INCOME_INSTRUMENTS view.