Retrieve Data in Chinese

Danni.Qiu

Hi Team,

Is there a way to retrieve all of the Data items in Chinese?

As when I use excel, if I set the preference languages as Chinese, all of the data items will be converted to Chinses. But it seems not working for Eikon Data API.

Thanks,

Danni

raksina.samasiri

Hi @Danni.Qiu ,

Could you please provide the Python code you used?

I tried to reproduce it but I got the formula with English field names

then I converted the Excel formula to Python format, which will be

Excel format

=@TR("AAPL.O","TR.BusinessSummary;TR.CommonName;TR.CUSIPExtended;TR.HeadquartersCountry;TR.ETPName","CH=Fd RH=IN",B2)

Python format

ric = "AAPL.O"
fields = ["TR.BusinessSummary, TR.CommonName, TR.CUSIPExtended, TR.HeadquartersCountry, TR.ETPName"]

df, err = ek.get_data(ric, fields)
df

and I'm getting the same data from Eikon Excel and Eikon Data API

Danni.Qiu

Hi @raksina.samasiri,

After you change your preference language to Chinese in Eikon desktop and restart excel.

All of the item in formula builder will become Chinese in excel.

But in API the output still remain in English.