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

question

Upvotes
Accepted
Danni.Qiu avatar image
11 ●2 ●6 ●6

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-apirefinitiv-dataplatform-eikonworkspaceworkspace-data-api
icon clock
10 |1500

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

wasin.w avatar image   wasin.w

Hello @Danni.Qiu

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

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS

1 Answer

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
14.2k ●30 ●5 ●10

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 512.0 KiB each and 1.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)

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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