question

Upvotes
Accepted
3 0 1 1

How to get Asia or Europe close price via python get_timeseries or get_data function

Similar function to that in excel:

=@RHistory("BRTCALAMc1","TRADE PRICE EUROPE.Timestamp;TRADE PRICE EUROPE.Close","START:"2021-04-01" END:"2021-04-20" INTERVAL:1D",,"TSREPEAT:NO SORT:ASC CH:Fd",B6)


using either the get_timeseries or get_data function in python.

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apitime-seriestimestamp
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.

1 Answer

· Write an Answer
Upvotes
Accepted
25k 67 15 21

Hi @Ruofan.Wang,

You can use the get_data API call to get similar information from the Data API. Please note that all the information available in RHistory is not available, or same as Eikon Data API.

df, err = ek.get_data('BRTCALAMc1', ['TR.USCLOSINGTRADEPRICE', 'TR.USCLOSINGTRADEPRICE.timestamp'], {'SDate':'2021-04-01', 'EDate':'2021-04-20'})



Please use TR.EUROPECLOSINGTRADEPRICE field to get European Closing Trade Price.


1619023093354.png (30.8 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.

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.