For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Danni.Qiu avatar image
11 ●1 ●2 ●4

Retrieve Data in Chinese

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

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikon
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
raksina.samasiri avatar image
1.7k ●2 ●4 ●7

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

1630324147798.png

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

1630324477570.png


1630324147798.png (133.6 KiB)
1630324477570.png (39.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Danni.Qiu avatar image Danni.Qiu

Hi @raksina.samasiri,


After you change your preference language to Chinese in Eikon desktop and restart excel.screenshot-2021-09-15-122516.png

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

But in API the output still remain in English.


screenshot-2021-09-15-122516.png (42.4 KiB)
Click below to post an Idea Post Idea